Problems with formulas
i am having difficulties with my formulas .
I am trying to acheive the following:
IF status row is not "complete" AND due date is Today or in the past, if true Flag, if not unflag.
My formula is:
=IF(AND(Status28 <> "Completed", [Planned Finish]28 >= TODAY(-15)), 1)
However this is the results - it is not calulation what i want it to show. What am i doing wrong or what have i missed?
Best Answer
-
Duh. I totally missed it! I just noticed that you are looking for "Completed" You should be looking for the word "Complete".
=IF(AND(Status28 <> "Complete", [Planned Finish]28 <= TODAY()), 1)
Answers
-
Your current formula is looking at everything that is greater than 15 days ago. So everything in the future is being looked at. To convert that to everything that is less or equal to today, make this change...
=IF(AND(Status28 <> "Completed", [Planned Finish]28 <= TODAY()), 1)
-
I only want it to work on the row that are not Complete, but it is still flagging all completed rows. The time frame i can work with, its that status that is not being recognised in this formula.
This is what has happened with the new formula.
-
Duh. I totally missed it! I just noticed that you are looking for "Completed" You should be looking for the word "Complete".
=IF(AND(Status28 <> "Complete", [Planned Finish]28 <= TODAY()), 1)
-
I do that ALL... THE... TIME...
"Complete" vs "Completed" is definitely in my top 5 most annoying things to work with in formulas.
-
lol Thank you i missed it too and this is more most frequent issue too.
Thanks everyone :)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!