Set the current date with the Record a Date action

Use Record a date action to set the current date into the chosen field when a workflow is triggered. The timezone of the date will be based on the sheet owner’s timezone. For more information, seeAdjust Your Personal Account Settings.

Get started with the record a date action

Create a record a date workflow

1. Select theAutomationmenu, thenCreate a Workflow.
2. Inside the workflow editor, scroll down to the action selector and choose theRecord a dateaction.
3. On theRecord a dateaction block, choose a Date field. This action type only sets dates into date columns. You will see a message if there aren’t any date columns on the sheet.

If aRecord a dateworkflow’s target date field is deleted or changed from date type to another column type, the workflow will be disabled, and sheet admins will receive an email notification.

NOTES:

• In cell history and activity log, the change will be attributed to内容自动化.
• Record a date is a terminal action. You will not be able to add conditions or actions after Record a date in your workflow.
• Dates relative to today’s date are not currently supported.
• Record a date cannot set start and end dates that are automatically calculated using predecessor or parent rollup dependencies.
• Each time a record a date workflow is triggered, it will overwrite any previously recorded date value.
• To prevent infinite approval loops, cells containing cross-sheet formulas or cell links will not trigger automation which automatically changes the sheet (Move Row, Copy Row, Lock Row, Unlock Row, Approval Request, Record a Date, Assign People, Change Cell, Clear Cell). To work around this, consider using time-based automation or recurrence workflows.
• Update cell actions need time to update the sheet, especially if there are multiple workflows.