Work with the Record a date action

To record a date when a workflow triggers:

1. Go to Automation > Create workflow from template...
2. In the Sheet change section, select Record the date when specified criteria are met > Use Template.
3. Enter a name for your workflow. 
4. Configure what triggers the workflow. 
5. Select the date field where you want to record the date.
6. Select Save. 

The Record a date action type only sets dates into date columns. A message appears if there aren’t any date columns on the sheet. Also, Resource Management locks the date columns it uses to calculate start and end dates. Those columns aren’t available for the Record a date action. 

To know when working with change cell value

• The sheet owner’s personal account settings define the time zone of the date set.
• If someone deletes or changes a Record a date workflow’s target date field to another column type, the workflow gets disabled, and sheet admins receive an email notification.
• In cell history and activity log, you see the change attributed to Smartsheet Automation. 
• Record a date is a terminal action, and it doesn’t accept any other conditions or actions in the workflow.
• Smartsheet doesn’t currently support relative dates (5 days from today, 3 days ago).
• Record a date can’t set start and end dates that are automatically calculated by predecessor or parent roll-up dependencies.
• Each time a Record a date workflow triggers, it overwrites any previously recorded date value.

• To avoid creating endless loops, Smartsheet doesn't initiate the Record a date action when the trigger cell includes cross-sheet formulas or are linked to other cells. To work around this, use time-based automations or recurrence workflows. 

• Update cell actions need time to update the sheet, especially if there are multiple workflows.