TODAY Function

Used in a Date column to return the current date.
Sample Usage
  • [
  • number
    The number of days before (negative number) or after (positive number) the current date.
Usage Notes

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.

Was this article helpful?