IF formula for conditional formatting

alexandra.richardson

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?

JamesB

@alexandra.richardson You can do this in your form.