- number—[optional]The number of days before (negative number) or after (positive number) the current date.
Smartsheet will update all instances of the TODAY function in a sheet to the current date when any of the following actions are taken:
- 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 by way of 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)
The following will not update formulas that are using the TODAY function to the current date:
- A report looking at the function in the sheet is opened.
- A dashboard showing information from the sheet is opened.
You can use TODAY to compare other dates with the current date. For example, the formula =IF(TODAY() > [Due Date]1, “Past Due”) will insert “Past Due” into a cell once the current date has exceeded the estimated due date.