Can you help me finding my syntax error?

=IF(AND(Statut@row <> "Terminé", ([Date prévue de l'événement@row] <= TODAY(-5), "Rouge")); IF(Statut@row = "Terminé" ,"Vert", "Jaune"))

What I want is: If Statut@row is not "Terminé" and the [Date prévue de l'événement@row] is equal or less than 5 days before the event, then "Rouge", If Statut@row is "Terminé", then "Vert", if not then "Jaune" 

Thank you in advance for your help,

Melanie

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!