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".
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
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".
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
I feel silly, thank you so much!!!!!!!!!
-
Happy to help. 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!