Applies to
- Pro
- Business
- Enterprise
Capabilities
Who can use this capability
You must be a licensed Smartsheet user with Owner, Admin, or Editor-level permission on the sheet to create workflows. Users with Editor-level permissions can only create, edit, or delete alerts or reminders with themselves as the recipient. Learn about workflow permissions.
The sheet Owner and Admins can add the Change cell action.
Work with the clear cell value action
Use the Clear cell value action to delete the contents of the chosen field when a workflow is triggered.
To create a Clear cell value workflow:
- Go to Automation > Create workflow from template...
- In the Sheet change section, select Clear a cell value when specified criteria are met > Use Template.
- Enter a name for your workflow.
- Configure what triggers the workflow.
- Select the column where the cell you want to clear is.
- Select Save.
If a Clear cell value workflow’s target field is deleted, the workflow is disabled and sheet admins receive an email notification.
To know when working with Clear cell value action
- In cell history and activity log, the change is attributed to Smartsheet Automation.
- Clear cell value is a terminal action. You aren’t able to add conditions or actions after Clear cell value action in your workflow.
- You can’t clear formulas or Auto-Number/System generated columns.
To avoid creating endless loops, Smartsheet doesn't initiate the Clear cell value 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.