IF OR NOT ISBLANK

I am trying to write a column formula to return a value of "Yes" if certain criteria are met but am struggling to understand what I am doing wrong.
I need the column Removed From Respirator Program to change to Yes when
- Expiration date is not blank; and
- Expiration date is one day past todays date; or
- when Do you need to renew your respirator qualification is answered No
Here is my last attempt before reaching out here. I have tried several iterations but nothing has worked for me yet. This halfway works but not the part of Do you need to renew your respirator qualification = No.
=IF(AND(NOT(ISBLANK([Expiration Date]@row)), OR([Do you need to renew your respirator qualification]@row = "No", [Expiration Date]@row <= TODAY(-1))), "Yes", "")
Thanks in advance!
Answers
-
Hello,
You can give this a shot and see if it works for you:
=IF(AND(NOT(ISBLANK([Expiration Date]@row)), OR([Do you need to renew your respirator qualification]@row = "No", [Expiration Date]@row = TODAY() + 1)), "Yes", "")
This formula checks if:
- Expiration Date is not blank
- Either "Do you need to renew your respirator qualification" is answered "No"
- Or, Expiration Date is one day past today
https://www.linkedin.com/in/zchrispalmer/
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!