Who can use this capability
Users that are the sheet Owner or have Admin sharing permissions can create and edit formulas on a sheet. Users with Editor sharing permissions can also create and edit formulas in unlocked cells on a sheet.
Automatically update the TODAY function in formulas
The TODAY function in Smartsheet returns the current date within formulas.
For the TODAY function to recognize what the current date is, the sheet must be updated and saved. If there is a chance that a sheet may not have enough daily activity for TODAY to update, there are few different workflows you can leverage to automatically update your sheet.
Option 1: Record a date in a helper column
First, add a Date type of column to your sheet and add yesterday's date (or any date in the past) into a cell. You can then hide this column.
To create this workflow:
- Select Automation > Create workflow from scratch.
- Title your workflow (for example, "Daily Update").
- Set the trigger to When a date is reached.
- Select Run Once and change this to Custom > Repeat every Day.
- Select an early morning time for the trigger (e.g. 2:00AM).
- Configure a condition block for where the new date column is in the past.
- Set the Action block to Record a date in that date column.
Remember to add at least one past date into your new date column so that your workflow has a cell to update tomorrow.
Option 2: Record a date and use cell links to update multiple sheets
If you have multiple sheets to update, you can set up the date column and workflow described above in a separate reference sheet. Next, use a cell link to bring the date from this reference sheet into your current sheet that contains the TODAY function.
The automation will add a new date to the reference sheet daily, which will in turn update your formula sheet via the cell-link data change.
Option 3: Use Bridge to schedule a daily sheet save
If you have access to Bridge, see the Bridge article explaining the Schedule Daily Sheet Save template.