How do I update multiple cells when one cell is updated?

How do I update multiple cells when one cell is updated?

Example A: If Done is checked, then Status is updated to Completed and Progress is updated to Full.

Example B: If Status is updated to Completed, then Done is checked and Progress is updated to Full.



Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!