Changing Duration cell based on specific dropdown from Status at row


I'm trying to create some type of function that performs the following:

  1. Status dropdown has "Not Started, In Progress, Complete, Exempt"
  2. Status at row is selected as "Exempt"
  3. When status at row is "Exempt", the duration at row will change to 0

My goal is when someone selects the "Exempt" option in the status dropdown that the duration for that row changes to 0.

Is this possible with an IF function or say an automation workflow?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!