Quick View of Pre-built Tables in Google Spreadsheets

including:
(1) Smart chips ??
(2) Placeholders –> show placeholders: show hint/example inside table
(3) Custom color palettes

Trying

  • Setting Column types
    • Dates
    • People chips
    • Dropdowns
  • Custom views
    • Group rows by a selected value
    • Filter views to analyze a subset of data without altering what collaborators see
  • Personalize
    • Custome name, color pallete

 

    1. Feature
      1. Event tasks
        1. Column: Task, Status ※, Owner (Name), Stage ※, Due date, Notes
        2. Status: Not started, In progress, Blocked, Completed
        3. Stage: Pre-event, Day of, Post-event
      2. Project tasks
        1. Column: Task, Priority ※, Owner (Name), Status ※, Start date, End date, Milestone
        2. Priority: P0, P1, P2, P3
        3. Status: Not started, in progress, blocked, completed
      3. Content tracker
        1. Column: Content, Type ※, Details, Owner, Status ※, Post date, File
        2. Type: Email, social media, TV, Blog post, All
        3. Status: New, In progress, Under review, Published, Suspended, Paused
      4. Product prioritization
        1. Column: Feature, Category ※, Status ※, Owner, Size ※, Launch ※, Notes
        2. Category: Category 1, Category 2, Category 3, Category 4
        3. Status: Not started, In progress, Blocked, Launched
        4. Size: XS, S< M, L, XL, XXL
        5. Launch: Q1, Q2, Q3, Q4
      5. Recruitment applicants
        1. Column: Applicant, Stage ※, Role, Team ※, Resume, Interviewer, Score ☆, Notes
        2. Stage: Hire, Interviewing, Decision Needed, No hire
        3. Team: Team 1, Team 2, Team 3, Team 4
    2. Event planning
    3. Customer relations
    4. Project management
      1. Project resources
        1. Column: Name, Role, Status ※, Hours per week, Total hours, Allocated hours
        2. Status: Full-time, Part-time, On leave
      2. Office hours
        1. Column: Meeting date, Category, Description, Attended, Status ※, Documents, Notes
        2. Status: Not started, Met, In progress, Postponed, Cancelled
    5. Travel planner
    6. Product roadmap
      1. Product team list
        1. Column: Team member, Team, Role, Status ※, Notes
        2. Status: Free, Has bandwidth, Assigned
    7. Inventory management
      1. Inventory tracker
        1. Column: Item ID, Item name, Type ※, Price, Stock, Status ※, Notes
        2. Type: Category 1, Category 2, Category 3, Category 4
        3. Status: In stock, Temporarily Unavailable, Re-purchase needed, Sold out
      2. Inventory vendor list
        Vendor's reliability: e.g., 3 stars
      3. Purchase order
        Order's priority, order's status (Ordered, Approved, Shipped, Delivered)
      4. Sales order
        Order's priority, product (A, B, C), status (Received, Accepted, In progress, Shipped, Delivered)
    8. Recruitment
      1. Recruitment positions
        Position's priority, team, status (Open, Closed), Location, Post date, # Days posted
    9. Team planner
      1. Team goals
        Goal's priority, owner (names), status (Delayed, At risk, On track), Start date, End date, Related files
      2. Team budget
        Month, Income (actual), Income (projected), Expense (actual), Expense (projected), status (Under budget, At budget, Over budget), End of month budget
      3. Team resource planning
        Name, role, # Hours per week, # Total hours, # Aloocated hours, % Capacity
    10. Marketing
      1. Campaign tracker
        Status: Planning, Developing, Under review, On hold, Published, Start date, End date, Assets
      2. Campaign results
        Status (Previous, Current, Future), Cost, # Impressions, # Conversions, Next steps (Analyze, Pause, Stop, Continue)