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

Find more posts tagged with

Formulas

Accepted answers

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.

All comments

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. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.