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,



Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!