Nested IF Statement with OR and AND functions
Hello, I am trying to create a nested IF statement. The formula is fed by two columns Status and End Date. The formula should return that IF status is one of "Completed" or "Adoption/Sustain" AND the end date column has a date (any date) then return "Yes" if true. I keep getting Unparseable or Circular Reference errors.
The current formula I have is =IF(OR(AND([End Date]@row]),Status@row = "Completed",Status@row="Adoption/Sustain"),[TEST Regulatory Controls Verified]@row = "Yes")
Answers
-
Try placing the formula below into your "TEST Regulatory Controls Verified" column. It should populate that column with "Yes" if the status is either "Completed" or "Adoption/Sustain" AND "End Date" is a date. It will populate the column with "No" if the conditions aren't met. You can substitute "" for "No" in the formula to leave the cell blank if the conditions are not met.
=IF(AND(OR(Status@row = "Completed", Status@row = "Adoption/Sustain"), ISDATE([End Date]@row)), "Yes", "No")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!