Applies to

Smartsheet
  • 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.

Change a cell value with an automated workflow

With the Change cell value action, you can input data to text/number, single-select dropdown, multi-select dropdown, and checkbox columns.

PLANS

  • Smartsheet
  • Pro
  • Business
  • Enterprise

Permissions

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.

Get started with Change cell value action

Cell typeValues you can input
Text/NumberA text or number value with a 4,000-character limit.
CheckboxChecked, unchecked, or a custom value.
Single-select dropdownOne of the dropdown list’s values OR a text or number value with a 100-character limit.
Multi-select dropdownOne or more of the dropdown list’s values AND/OR one or more text or number values. Each value has a 100-character limit. 

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. 
    View of the Change cell value action in the workflow window.
  6. Enter or select the new value. For multi-select dropdown columns, you can overwrite the existing value or append another value to the cell. 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.

To know when working with change cell value

  • 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 that have a cell-link or cross-sheet formula don't trigger the Change cell value action.
  • You must specify the exact value that 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.
  • To prevent infinite approval loops, cells containing cross-sheet formulas or cell links do not trigger automations that automatically change the sheet (Move Row, Copy Row, Lock Row, Unlock Row, Approval Request, Record a Date, Assign People, Change Cell, Clear Cell, Generate document). 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. 

Frequently Asked Questions

Can I use the Change cell value action to update Date columns?

No. Use the Record a date action to automatically record the current date in Date columns. You can also turn on dependencies in Gantt view to easily update dates as your timeline shifts.

Can I use the Change cell value action to update Contact List columns?

No. Use the assign people action to automatically update Contact List columns.

Was this article helpful?
YesNo