Green, Yellow, Red Blue Formatting

Hello,

Newbie here. Trying to set some formatting for some specific RYGB and I can only get it to work for Yellow. Any thoughts? I receive the #INCORRECT ARGUMENT error. Thanks in advance!

=IF([Completed%]2 = 1, "Green", IF(AND(Today1 > Start2, Today1 < Finish2, [Completed%]2 = 0), "Yellow", IF(Start2 > $Today$1, [Completed%]2 = 0, "Blue", IF($Today$1 > Finish2, "Red"))))

Find more posts tagged with

Accepted answers

Ameya Athalye

Try this?

=IF([Completed%]2 = 1, "Green",

IF(AND([Today]1 > [Start]2, [Today]1 < [Finish]2, [Completed%]2 = 0), "Yellow",

IF(AND([Start]2 > [Today]1, [Completed%]2 = 0), "Blue", "Red")))

All comments

Ameya Athalye

Try this?

=IF([Completed%]2 = 1, "Green",

IF(AND([Today]1 > [Start]2, [Today]1 < [Finish]2, [Completed%]2 = 0), "Yellow",

IF(AND([Start]2 > [Today]1, [Completed%]2 = 0), "Blue", "Red")))

Erin Miller

Perfect! Thank you for the 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.