Overdue / Due <10 days
We are flagging items overdue as well as less than 10 days. The issue is when an item is past due we only want the flag on for Overdue not Due < 10 days so that reporting is appropriate. What I would like to do is check to see if overdue flag is set and not set the Due < 10 days.
=IF(AND([Over Due]@row = "FALSE") = IF(AND([% Complete]@row < 1, [Trending End Date]@row - TODAY() <= 10), 1, 0))
Answers
-
Hi Kristopher,
You can have all these statements in the same AND function. Try this:
=IF(AND([Over Due]@row = "False", [% Complete]@row < 1, [Trending End Date]@row - TODAY() <= 10), 1, 0)
Now all three of those criteria need to be met before this column will have a flag. If the Over Due column is not false (meaning there's a flag in that column), this one won't be flagged. Is that what you wanted? If I've misunderstood, it may be helpful to see a screen capture of your sheet (but please block out any sensitive data).
Thanks!
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 437 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!