ISO - Simple At Risk Formula


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


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!