Nested Formula for At Risk Flag

ALMF

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?

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.

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! 👍️