IF OR/AND Nesting Part 2

Hi - I just asked a IF OR/AND nesting question recently and it was answered. Then I tried to modify it slightly and it is unparseable. Could you please look at this one below?

=IF(OR(AND([Round #3 Price Sheet Status]@row = "Not Renewing"), AND([Account has Updated Renewal Added to TL]@row = 1,)), "Blue", IF([Price Sheet Deadline]@row >= TODAY(20), "Green", IF([Price Sheet Deadline]@row < TODAY(18), "Red", IF([Price Sheet Deadline]@row < TODAY(20), "Yellow"))))

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

The issue is with the second AND function

AND([Account has Updated Renewal Added to TL]@row = 1,)

Either the AND function needs removed along with the last comma before the closing parenthesis, or you forgot to add a second "logical statement" to the AND function.

Carrie Tortorella

So this would work? =IF(OR([Round #3 Price Sheet Status]@row = "Not Renewing"), IF([Contract Renewal Health]3[Account has Updated Renewal Added to TL]@row = 1,)), "Blue", IF([Price Sheet Deadline]@row >= TODAY(20), "Green", IF([Price Sheet Deadline]@row < TODAY(18), "Red", IF([Price Sheet Deadline]@row < TODAY(20), "Yellow")))

Paul Newcome

No. Now you are missing the AND function entirely, and you need to move the comma after the second criteria to between the first and second criteria.

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.