Flag Formula to Alert a Person

DaniellaH

I'm trying create a flag formula that shows if the "problem resolved" box is not checked and the "current date" was two days ago, then flag in "past due".

Smartsheet User 99

Hope this helps you out.

=IF(ISBLANK(Problem@row), "", IF(ISBLANK([Date Due]@row), "", IF([Problem Resolved]@row = 1, "", IF(AND([Problem Resolved]@row = 0, [Date Due]@row < TODAY() - 1), "Past Due"))))