If, then Formulas

Hi there! I am trying to create a formula for the following scenario and i've been unable to figure it out

If Status Column is "Complete", Mark as Green, IF Status of Column is NOT Complete, then apply the formula

=IF([End Date]@row < TODAY(5), "Red", IF([End Date]@row = TODAY(5), "Yellow", IF(AND([End Date]@row > TODAY(5), [End Date]@row < TODAY(30)), "Blue", IF([End Date]@row >= TODAY(30), "Green"))))

I cant figure out how to add the first part to the already working last part

Thank you!

Find more posts tagged with

Formulas

Accepted answers

Adam Murphy

Hi Megan! Do you mean you want to use your formula only if status is not complete?

Like this: =IF(Status@row = "Complete", "Green", IF([End Date]@row < TODAY(5), "Red", IF([End Date]@row = TODAY(5), "Yellow", IF(AND([End Date]@row > TODAY(5), [End Date]@row < TODAY(30)), "Blue", IF([End Date]@row >= TODAY(30), "Green")))))

Is that what you mean?

All comments

Adam Murphy

Hi Megan! Do you mean you want to use your formula only if status is not complete?

Is that what you mean?

MeganMcHenry

Adam Murphy - YES this worked thank you so much!

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.