Applies to

  • Pro
  • Business
  • Enterprise


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. 


  • Smartsheet
  • Pro
  • Business
  • Enterprise


  • Owner
  • Admin

To create a Clear cell value workflow:

  1. Go to Automation > Create workflow from template...
  2. In the Sheet change section, select Clear a cell value when specified criteria are met > Use Template.
  3. Enter a name for your workflow. 
  4. Configure what triggers the workflow. 
  5. Select the column where the cell you want to clear is. 
Brandfolder Image
Clear cell value automation
  1. 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.

Was this article helpful?