Formula

Hi all,

I am trying to combine the following two formulas, only one works at a time.

=IF([Variance (Target End date)]@row = 0, "Green", IF([Variance (Target End date)]@row <= -4, "Red", IF(OR([Variance (Target End date)]@row = -1, [Variance (Target End date)]@row = -2, [Variance (Target End date)]@row = -3), "Yellow", "Green")))

=IF([Status]@row = "Complete", "Blue"

Best,

Alejandra

Find more posts tagged with

IF(AND

Accepted answers

Paul Newcome

You would put the one reading Status as the first in the string of the nested IFs.

All comments

Paul Newcome

You would put the one reading Status as the first in the string of the nested IFs.

aleja

I tried that but I get #INCORRECTARGUMENT SET. I used the following:

=IF([Status]@row = "Complete", "Blue", [Variance (Target End date)]@row = 0, "Green", IF([Variance (Target End date)]@row <= -4, "Red", IF(OR([Variance (Target End date)]@row = -1, [Variance (Target End date)]@row = -2, [Variance (Target End date)]@row = -3), "Yellow", "Green")))

Paul Newcome

You forgot your IF( after you finish off the first "Blue".

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.