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?
Help Article Resources
Check out the Formula Handbook template!