Update Status formula - late versus complete

BJIloveSmartSheet

Howdy,

Question. I am using a status formula:

=IF(Finish@row < TODAY(), "Late", IF([% Complete]@row = 0, "Not Started", IF([% Complete]@row = 1, "Complete", "In Progress")))

This formula populates the status based on the % complete and due date. It works well, with one exception. If the % complete is marked 100% after the due date, the status remains "Late", when it's actually 100% complete. The 100% complete needs to override the "Late" status.

Any ideas on how to modify this formula? Attached is a screenshot displaying the issue.

Thanks!

Snag_1a32c28a.png

BJIloveSmartSheet

perfect. It works great. thank you!!

ker9

I think if you change the order it will work, it stops on the IF it finds first:

=IF([% Complete]@row = 1, "Complete", IF(Finish@row < TODAY(), "Late", IF([% Complete]@row = 0, "Not Started", "In Progress")))

BJIloveSmartSheet

perfect. It works great. thank you!!