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

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!