How to use Nested IF AND/OR Formulas?
Lekha Oberoi
✭✭
I want to compare two columns Health and Date and populate the column for update required or not required.
Conditions are
- If the date is in the past and Health is Blue - Update Not Required
- If the date is the past and Health is either Yellow, Green OR Red - Update required
- If the date is in the future and Health is either Yellow, Green OR Red - Update Not Required
- If the date is in the future and Health is Blue - Update not required
The formulas I have is
- =IF([Target date]35 > TODAY(), "NA", IF(OR(Health35 = "Yellow", Health35 = "green", Health35 = "Red"), "NA", IF(AND([Target date]35 < TODAY(), Health35 = "Blue"), "NA", "Update Required")))
- =IF(AND(TODAY() > [Target date]34, (Health34 = "Blue")), "NA", "Update required")
The first one will not work if the date is in the future, second one does not work if the date is in the past and the health is anything other than blue. Kindly Help!
Tags:
Best Answer
-
Try this one...
=IF(Health@row = "Blue", "Update Not Required", IF([Target Date]@row> TODAY(), "Update Not Required", "Update Required"))
Answers
-
Try this one...
=IF(Health@row = "Blue", "Update Not Required", IF([Target Date]@row> TODAY(), "Update Not Required", "Update Required"))
-
Thanks Paul! It did solve the problem.
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62K Get Help
- 338 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.3K Ideas & Feature Requests
- 130 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 454 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 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!