IF formula for conditional formatting
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
-
@alexandra.richardson You can do this in your form.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!