Add Or Condition to my formula
PMOGal
✭✭✭✭✭
Hi. How do I adjust my column formula to include Status <> Complete or <> Phase 2?
My formula is:
=IF(AND(Finish@row < TODAY(), Status@row <> "Complete", Health@row <> ""), "Yes", "")
Tags:
Answers
-
=IF(AND(Finish@row < TODAY(), OR(Status@row <> "Complete", Status@row <> "Phase 2"), Health@row <> ""), "Yes", "")
-
Sorry, that did not work. It turned items that were Complete as Past Due.
-
I changed the OR to and AND and that may be closer to what you are looking for:
=IF(AND(Finish@row < TODAY(), AND(Status@row <> "Complete", Status@row <> "Phase 2"), Health@row <> ""), "Yes", "")
-
Ba-Da Bing! Works like a charm. Thank you.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 200 Industry Talk
- 430 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!