IF(AND( Formula Calculating...half correctly
See above for reference.
I cannot figure out what is wrong with my formula. My goal is that the Flag is "checked" anytime the second column of dates (named End Date/Ship Date) is within ten days or later of todays date, AND the status column is anything not matching Complete.....
Completely brain dead after going at this for hours. What am I missing? The flag is correctly unchecked for Milestone 1 Tasks 1 & 2, but is incorrectly unchecked for Task 3, which is "in progress" for status and is well before todays date 10 and should be flagged.
Thanks in advance
Best Answer
-
Your formula is essentially saying to flag if 10 days from now is earlier than the end date. Try flipping that argument around to "greater than" instead of "less than".
Answers
-
Your formula is essentially saying to flag if 10 days from now is earlier than the end date. Try flipping that argument around to "greater than" instead of "less than".
-
I feel silly, thank you so much!!!!!!!!!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 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!