AND/IF formulas

Options

I'm trying to identify the syntax error in my formula. Can someone help me?

=IF(Statut@row= "Terminé", "Vert), IF(AND(Statut@row = "En Cours"; IF(Échéance@row<=TODAY(); "Rouge", "Jaune")))

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!