Dashboard Mode - TODAY and NOW
Dashboard Goal
This dashboard helps you track daily sales and see the current date and time automatically. It answers: "What are today's total sales and what is the exact current time?"
0
0
TODAY and NOW in Google Sheets - Dashboard Guide
Sample Data
| Date | Sales |
|---|---|
| 2024-06-01 | 150 |
| 2024-06-02 | 200 |
| 2024-06-03 | 180 |
| 2024-06-04 | 220 |
| 2024-06-05 | 170 |
| 2024-06-06 | 210 |
| 2024-06-07 | 190 |
Dashboard Components
- Current Date (KPI Card): Shows today's date.
Formula:=TODAY()
Output example: 2024-06-04 - Current Date and Time (KPI Card): Shows exact current date and time.
Formula:=NOW()
Output example: 2024-06-04 14:30:15 - Today's Total Sales (KPI Card): Sum of sales for the current date.
Formula:=SUMIF(A2:A8, TODAY(), B2:B8)
Output example: 220 (if today is 2024-06-04) - Sales Data Table: Displays all sales data with dates for reference.
Dashboard Layout
+----------------------+--------------------------+ | Current Date | Current Date and Time | | (TODAY) | (NOW) | +----------------------+--------------------------+ | Today's Total Sales (SUMIF) | +------------------------------------------------+ | Sales Data Table | | (Date and Sales columns) | +------------------------------------------------+
Interactivity
The dashboard updates automatically every time you open or refresh the sheet because TODAY() and NOW() recalculate. The SUMIF formula uses TODAY() to filter sales for the current date, so the total sales number changes daily without manual input.
Self Check
If you change your computer's date to 2024-06-06 and refresh the sheet, which components update?
- The Current Date card will show 2024-06-06.
- The Current Date and Time card will show the new date and current time.
- The Today's Total Sales card will update to 210, the sales for 2024-06-06.
- The Sales Data Table remains the same.
Key Result
Dashboard showing today's date, current time, and total sales for today using TODAY() and NOW() functions.