- [number]
- number—[optional]The number of days before (negative number) or after (positive number) the current date
Smartsheet updates all instances of the TODAY function in a sheet to the current date when you take any of the following actions:
- You open the sheet and save it
- You add a new row to the sheet from a form submission
- You make changes to the sheet from an update or approval request (more on these alerts here)
- You update the sheet through a report (more on reports here)
- A linked cell updates the sheet (more on cell linking here)
- You open the sheet being referenced in a cross-sheet formula (more on cross sheet formulas here)
- You add a new row to the sheet from a move row or copy row workflow (more on these workflows here)
- You update cells using a workflow, such as change cell, assign user, or record a date. You can also use the lock and unlock row action to update the sheet without making any changes to cell values (see all sheet change workflow actions here)
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 doesn't update formulas that are using the TODAY function to the current date:
- A report referencing the function in the sheet is open.
- A dashboard showing information from the sheet is open.
You can use TODAY to compare other dates with the current date. 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 on a daily basis. A workflow can trigger the TODAY function to refresh to today's date without opening the sheet. See the article Automatically update the TODAY function in formulas for more information or use Bridge to Schedule Daily Sheet Save.
This example references the following sheet information:
| Transaction Total | Units Sold | In Stock? | Sold Date | Order Date | |
|---|---|---|---|---|---|
| 1 | 1,170.00 | 78 | true | 02/12/23 | 02/12/23 |
| 2 | 1,491.00 | 42 | false | 02/15/23 | 02/15/23 |
| 3 | 812.00 | 217 | true | 02/20/23 | 02/20/23 |
Given the table above, here are some examples of using TODAY in a sheet where the current date is 2/20/23:
| Formula | Description | Result |
|---|---|---|
| =SUMIF([Sold Date]:[Sold Date], <=TODAY(), [Transaction Total]:[Transaction Total]) | 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. | 4.285 |
| =IF(AND([In Stock?]@row = false, [Ship Date]@row <= TODAY(7)), "Red", "Green") | If the checkbox of the In Stock? column is cleared (false) and the date in Ship Date column is less than or equal to the date 7 days from today, the function returns Red. Otherwise, it returns Green. | Row 1: Green Row 2: Red Row 3: Green |
| =COUNTIF( [Sold Date]:[Sold Date], >=TODAY(-70)) | Counts the rows where the date in the Sold Date column is greater than or equal to the date 7 days ago. Rows 2 and 3 meet this criterion. | 2 |
Still need help?
Use the Formula Handbook template to find more support resources, and view 100+ formulas, including 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.