Change a cell value with an automated workflow

To change the value of a cell when a workflow is triggered:

1. Go to Automation > Create workflow from template...
2. In the Sheet change section, select Change 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 edit is. 
   Image
6. Enter or select the new value. You can overwrite the existing value or append another value to the cell for multi-select dropdown columns. In all other column types, the new value overwrites the existing one.
7. If you want to change another cell value in the same row, select + Add another column and repeat steps 5 and 6.
8. Select Save.

Here are the values you can input per cell type:

Keep the following in mind

• This action can only update values in sheet columns—not sheet summary fields.
• You can input new values in cells that contain cell formulas, but the workflow doesn't run if you convert a cell formula to a column formula. 
• Cells with a cell-link or cross-sheet formula don't trigger the Change cell value action.
• You must specify the exact value you want to input in a cell. You can't add a formula, reference another cell, or reference the value in a sheet summary field.
• When you append one or more values to a cell in a multi-select dropdown column, the Change cell value action removes duplicates. List values are case sensitive.
• Update cell actions need time to update the sheet, especially if multiple workflows exist. 
• The Change cell value action is a terminal action, meaning no additional actions can be added to the workflow after it.

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