SEQUENCE function in Excel - Dashboard Guide

Dashboard Mode - SEQUENCE function

Goal

Create a dashboard that shows a list of numbers generated automatically using the SEQUENCE function. This helps to quickly produce numbered lists for tasks like attendance, inventory IDs, or daily tracking.

Sample Data

Task	Status
Prepare report	Done
Send emails	Pending
Update website	Done
Call clients	Pending
Backup files	Done

Dashboard Components

• Number List (A2:A6): Formula: =SEQUENCE(5,1,1,1)
  Generates numbers 1 to 5 for each task row.
• Task List (B2:B6): Static list of tasks from sample data.
• Status List (C2:C6): Static list of status from sample data.
• Count of Done Tasks (E2): Formula: =COUNTIF(C2:C6,"Done")
  Shows how many tasks are marked as Done.
• Count of Pending Tasks (E3): Formula: =COUNTIF(C2:C6,"Pending")
  Shows how many tasks are Pending.

Dashboard Layout

+----------------------+----------------+---------+---------------------+
| Number List (A2:A6)  | Task List      | Status  | Summary (E2:E3)     |
| 1                    | Prepare report | Done    | Done: 3             |
| 2                    | Send emails    | Pending | Pending: 2          |
| 3                    | Update website | Done    |                     |
| 4                    | Call clients   | Pending |                     |
| 5                    | Backup files   | Done    |                     |
+----------------------+----------------+---------+---------------------+

Interactivity

Currently, this dashboard is static. To add interactivity, you could add a filter dropdown to select task status (Done or Pending). When a status is selected, the Number List, Task List, and Status List update to show only tasks with that status. The summary counts would also update accordingly.

Self Check

If you add a filter to show only tasks with status "Done", which components update?

• The Number List will show numbers 1 to 3 for the filtered tasks.
• The Task List will show only tasks marked Done.
• The Status List will show only "Done" statuses.
• The Summary counts will update to show Done: 3 and Pending: 0.

Key Result

Dashboard showing a numbered list of tasks generated by SEQUENCE with status counts.