ISO - Simple At Risk Formula

Lynda Ross

Hi Friends,

Looking for AT RISK Formula -

I'd like a formula that says IF Start Date is less than today (in the past) and Status ISBLANK then AT RISK flag is flagged. Below is a completely wrong formula - I just don't know how to get the ISBLANK in there.

Can anyone help? Formula challenged but love learning!

=IF(AND([Start Date]@row < TODAY(), Status@row = ISBLANK), 1, 0)

desired result is that the flag would be flagged (red)

Thanks! Lynda

Dan Berens

Hi Lynda,

Instead of ISBLank, you might use null. (Status@row = ""),1,0)

Dan Berens

Hi Lynda,

Instead of ISBLank, you might use null. (Status@row = ""),1,0)

Lynda Ross

@Dan Berens, Thank YOU! Immediate help! Amazing! Thanks!