Nested Formula for At Risk Flag

I've been trying to create a nested IF/AND function. I can get them to work individually, but the formulas are unparseable when I try to nest them. Below is an image of my sandbox where I am learning formulas. Here is what I am attempting to flag in the RISK column:

If FINAL DUE is today or in past, AND
If FINAL DUE is not blank, AND
If STATUS is not FULL, enable flag

Here are formulas that work on their own:

=IF([FINAL DUE]@row <= TODAY(1), 1)
=IF(ISBLANK([FINAL DUE]@row), 0)
=IF(NOT(STATUS@row = "FULL"), 1)

When I try to nest these in the RISK column using an IF/AND formula, the result is unparseable, I think because I'm unclear on where to put additional parenthesis or brackets. Help?

Screen Shot 2020-01-02 at 3.11.33 PM.png

Find more posts tagged with

Formulas

functionality

Accepted answers

Paul Newcome

=IF(AND(ISDATE([FINAL DUE]@row), [FINAL DUE]@row <= TODAY(), Status@row <> "Full"), 1)

Basically you are going to take the logical statement portion of each IF statement and drop it into the AND which will replace the logical statement portion of the main IF.

All comments

Paul Newcome

=IF(AND(ISDATE([FINAL DUE]@row), [FINAL DUE]@row <= TODAY(), Status@row <> "Full"), 1)

Basically you are going to take the logical statement portion of each IF statement and drop it into the AND which will replace the logical statement portion of the main IF.

ALMF

[Sigh] You make this look easy!

Thanks, @Paul Newcome! Your explanation makes perfect sense and this formula works great!

Paul Newcome

@almrie Haha. Thanks. It comes from trial and A LOT of error. 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.