Syntax
TODAY([number])
- number—[optional]The number of days before (negative number) or after (positive number) the current date
Sample usage
TODAY()
Usage notes
Smartsheet updates all instances of the TODAY function in a sheet to the current date on any of the following actions:
- You open the sheet and save it.
- A form submission adds a new row.
- An update or approval request workflow changes the sheet.
- You update the sheet through a report.
- A linked cell updates the sheet.
- You open the sheet being referenced in a cross-sheet formula.
- A move row or copy row workflow adds a new row to the sheet.
- A workflow updates the sheet's cells by assigning a user, recording a date, or explicitly modifying a cell.
- A lock or unlock row action.
If using TODAY in a sheet with a Modified Date/Time column, the Modified Date/Time value updates when TODAY updates to the current dates.
The following situations don't update formulas that are using the TODAY function to the current date:
- A report referencing the function in the open sheet.
- A dashboard showing information from the open sheet.
You can use TODAY to compare the current date with other dates. For example, the formula =IF(TODAY() > [Due Date]@row, "Past Due") inserts Past Due into a cell once the current date has exceeded the estimated due date.
Use automated workflows to update your sheet daily. A workflow can trigger the TODAY function to refresh to today's date without opening the sheet. See Automatically update the TODAY function in formulas for more information, or use Bridge to Schedule Daily Sheet Save.
Examples
This example references the following sheet:
Transaction Total | Units Sold | In Stock? (Checkbox column type) | Sold Date | Order Date | |
---|---|---|---|---|---|
1 | Transaction Total 1,170.00 | Units Sold 78 | In Stock? (Checkbox column type) true | Sold Date 10/06/24 | Order Date 10/06/24 |
2 | Transaction Total 1,491.00 | Units Sold 42 | In Stock? (Checkbox column type) false | Sold Date 10/09/24 | Order Date 10/09/24 |
3 | Transaction Total 812.00 | Units Sold 217 | In Stock? (Checkbox column type) true | Sold Date 10/14/24 | Order Date 10/14/24 |
Based on the table above, here are some examples of using TODAY in a sheet when the current date is 10/14/24:
Formula | Description | Result |
---|---|---|
Formula =SUMIF([Sold Date]:[Sold Date], <=TODAY(), [Transaction total]:[Transaction total]) | Description Sums the values in the Transaction Total column for rows where the date in the Sold Date column is less than or equal to today’s date. All three rows meet the criteria. | Result 3,473 |
Formula =IF(AND(NOT([In stock?]@row), [Sold Date]@row <= TODAY(7)), "Red", "Green") | Description If the column In Stock is cleared (false), and the date in Sold Date column is less than or equal to 7 days from today; the function returns Red. Otherwise, it returns Green. | Result Row 1: Green Row 2: Red Row 3: Green |
Formula =COUNTIF([Sold Date]:[Sold Date], >= TODAY(-7)) | Description Counts the rows where the date in the Sold Date column is greater than or equal to 7 days ago. Rows 2 and 3 meet this criteria. | Result 2 |
Still need help?
Use the Formula Handbook template to find more support and resources, view 100+ formulas, a glossary of every function that you can practice working with in real-time, and examples of commonly used and advanced formulas.
Find examples of how other Smartsheet customers use this function or ask about your specific use case in the Smartsheet online Community.