IF formula for conditional formatting

Options

Is there also a way to do an IF statement for if I have conditional formatting active in the row (highlighted yellow in my example), that it will set the Project Status field to Submitted?

I have conditional formatting to go yellow for a new submission (from my SmartSheet form) into my tracking sheet, where the Status would be blank. Can I also set it up that it would automatically move the Project Status field to Submitted?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!