Hi I would like to say:

if the completed date is greater than the end date put "overdue" in the column

If completed date is empty and it is after the end date put "overdue"

If the end date is empty leave empty

This is not working

=IF(OR(AND(ISBLANK([Completed Date]@row), TODAY() > [END]@row), [Completed Date]@row > [END]@row), "OVERDUE", " ") + IF(AND([END]@row <>, ""))

And this works on some of my sheets but randomly leaves OVERDUE on three rows that are empty. yet the rows below it are also empty and they are not OVERDUE

=IF(OR(AND(ISBLANK([Completed Date]@row), TODAY() > [RQ END]@row), [Completed Date]@row > [END]@row), "OVERDUE", " ") + IF([END]@row = "", "")

Any help would be greatly appreciated! Thanks in advance



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!