OVERDUE Formula
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
Answers
-
Try this:
=IF([End Date]@row <> "", IF(IF([Completed Date]@row <> "", [Completed Date]@row, TODAY()) > [End Date]@row, "Overdue"))
-
Fantastic!Thanks so much for your response Paul. I am learning through your comments!
I now need to exclude if "Not Due" in the Execution Completed" column. I have been trying different variations but am going wrong somewhere here =IF([RQ END]@row <> "", IF([Execution Completed]@row "Not Due", "") IF(IF([Completed Date]@row <> "", [Completed Date]@row, TODAY()) > [RQ END]@row, "Overdue"))]
Thanks in advance 🙂
-
If I understand correctly, this should work for you:
=IF(AND([End Date]@row <> "", [Execution Completed]@row <> "Not Due"), IF(IF([Completed Date]@row <> "", [Completed Date]@row, TODAY()) > [End Date]@row, "Overdue"))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!