Tardy Identification System

I am able to flag down if the 'Date Completed' surpassed the 'Deadline'; however, I am unsuccessful in making a tiered tardy system: Ontime, Late (+30 days late), and Super Late (+60 days late).
=IF([Date Completed]@row - Deadline@row > 0, "LATE", IF([Date Completed]@row - Deadline@row <= 0, "ON TIME", IF([Date Completed]@row - Deadline@row < 90, "SUPER LATE")))
When I changed the 'Date Completed' to be greater than 90 days, my formula is not able to recognize this.
Answers
-
Hi @rdief
You're close!
Nested IF statements will stop as soon as they find the first match, meaning that the order you place them in is important.
Right now, your first statement is looking to see if the date is greater than 0, which would include 60+ days as well. Let's swap around your IF order and that should do the trick!
=IF([Date Completed]@row -Β Deadline@rowΒ > 60, "SUPER LATE", IF([Date Completed]@row -Β Deadline@rowΒ > 0, "LATE", IF([Date Completed]@row -Β Deadline@rowΒ <= 0, "ON TIME")))
(Note - I also swapped around the > sign so it's looking for greater than 60 days. You can change this back to 90 if you meant 90 days!)
Let me know if this works for you,
Genevieve
Need more information? π | Help and Learning Center
γγγ«γ‘γ― (Konnichiwa), Hallo, Hola, Bonjour, OlΓ‘, Ciao!π | Global Discussions
-
Thank you! I found out after trying so many times! But I didn't know. Appreciate it mate!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 208 Use Cases
- 517 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 84 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!