Applies to
Smartsheet
- Pro
- Business
- Enterprise
Capabilities
Who can use this capability
- Owner
- Admin
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.
Brandfolder Image
![Clear cell value automation](https://cdn.bfldr.com/NB5M6M91/at/tt3z8p732hfgwz5rxj4pk7q/Clear_cell_value_automation.jpg)
- 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.