What formula do I use to change cells once another cell changes?

Options

Basically for me it's once an item is selected in the form it will then change 2 other cells in the row. These 2 new cells will have email addresses that will be used for an automated status emails. I am new to the formula/functions in Smartsheet.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!