Help with formula (IF > AND > THEN)


Hi team,

Could you kindly help me out with the formula syntax for the following scenario please:

If the "Rag Status" column is 'Red', and the "Complete" checkbox is not checked, then the "Action Status" must change to 'Overdue'.

Link to sheet is HERE.


Screenshot 27-06-2018.JPG


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!