Help with adjusting a formula

So the formula below is used to determine the colors of the dots. However, I need it modified so that for Blue Dots, they will be Blue based on the current condition already there, or if the start date or finish date are empty. I was unable to figure this out on my own so thought I would post it here

=IF(OR(Status@row = "Complete", [% Complete]@row = 1), "Green", IF(Finish@row <= TODAY(), "Red", IF(Finish@row > TODAY(7), "Blue", IF(Finish@row >= TODAY(), "Yellow"))))

Find more posts tagged with

Formulas

functionality

Accepted answers

Paul Newcome

Lets try some rearranging then...

=IF(OR(Status@row = "Complete", [% Complete]@row = 1), "Green", IF(OR(Finish@row > TODAY(7), Finish@row = "", Start@row = ""), "Blue", IF(Finish@row <= TODAY(), "Red", IF(Finish@row >= TODAY(), "Yellow"))))

All comments

Paul Newcome

Give this a go...

=IF(OR(Status@row = "Complete", [% Complete]@row = 1), "Green", IF(Finish@row <= TODAY(), "Red", IF(OR(Finish@row > TODAY(7), Finish@row = "", Start@row = ""), "Blue", IF(Finish@row >= TODAY(), "Yellow"))))

Clark Everson

Just tried this and the blank ones stayed Red

Paul Newcome

Lets try some rearranging then...

Clark Everson

That worked! Thanks so much!

Paul Newcome

Great! 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.