Can you help me finding my syntax error?

Melanie Courtemanche

=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

Paul Newcome

Try this:

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

You will need to figure out whether you should be using commas or semicolons in formulas (based on region) and use them consistently.

Paul Newcome

Try this:

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

You will need to figure out whether you should be using commas or semicolons in formulas (based on region) and use them consistently.

Melanie Courtemanche

Thank you so much for your help. I will try that.

Paul Newcome

Happy to help. 👍️