Manage conditional formatting rules

You can edit, reorder, clone, turn on/off, or entirely delete your conditional formatting rules. You can also reorder them.

Who can use this?

Plans:

  • Pro
  • Business
  • Enterprise

Permissions:

  • Admin
  • Owner

Find out if this capability is included in Smartsheet Regions or Smartsheet Gov.

Conditional formatting rules

To add, edit,clone, disable, enable, or delete a rule:

  1. Select Conditional Formatting Conditional formatting icon .
  2. Select the drop-down arrow Drop-down arrow icon.
    A screenshot of where the drop-down arrow is
  3. Make your selection:
    • Add Condition (AND): Add more conditions to the rule.
    • Clone Rule: Duplicate the rule and use it as a template to create new rules.
    • Disable or Enable Rule: Turn the rule on or off.
    • Delete Rule: Delete the rule entirely. You can’t undo this, so you may want to disable the rule instead. 

Rearrange rules

Rules are applied from top to bottom in the list. If rules conflict, the rule higher in the list takes priority. 

To change the order of your rules, select a rule and drag it to the new location while holding down the mouse button.