Need help with an IF Statements with multiple ORs and an AND
Hi. I need to write an IF statement where if the Review column has one of the following: Review Complete, Reviewed - Not applicable, Do not include, Reviewed - Not applicable, send feedback
AND
the COMM Review column has the following: COMM Review Complete
If both the Review Column has one of the 3 options AND the COMM Review column has COMM Review Complete, then enter "All Reviews Complete" in the All Reviews Complete column.
This is the formula I wrote, but I'm getting a unparseable error:
=IF((AND(OR([Review Complete]@row = "Review Complete", [Review Complete]@row = "Reviewed - Not applicable, Do Not Include", [Review Complete]@row = "Reviewed - Not applicable, send feedback")), IF([COMM Review Complete]@row = "COMM Review Complete"), "All Reviews Complete", " "))
If neither of the conditions are fullfilled, then leave the All Reviews Complete column blank.
Thoughts?
Thanks,
Adrienne
Best Answer
-
Sorry. went a little fast on that one.
IF(AND(OR([Review Complete]@row = "Review Complete", [Review Complete]@row = "Reviewed - Not applicable, Do Not Include", [Review Complete]@row = "Reviewed - Not applicable, send feedback"), [COMM Review Complete]@row = "COMM Review Complete"), "All Reviews Complete", " ")
Answers
-
IF((AND(OR([Review Complete]@row = "Review Complete", [Review Complete]@row = "Reviewed - Not applicable, Do Not Include", [Review Complete]@row = "Reviewed - Not applicable, send feedback"), [COMM Review Complete]@row = "COMM Review Complete"), "All Reviews Complete", " "
Give that a try
-
Hi L_123,
I tried the formula you suggested, but there were a few missing parenthesis. So this is the formula I used with the parenthesis:
=IF((AND(OR([Review Complete]@row = "Review Complete", [Review Complete]@row = "Reviewed - Not applicable, Do Not Include", [Review Complete]@row = "Reviewed - Not applicable, send feedback")), [COMM Review Complete]@row = "COMM Review Complete"), "All Reviews Complete", " ")
Unfortunately, I still am receiving an #unparseable error.
Thanks,
Adrienne
-
Sorry. went a little fast on that one.
IF(AND(OR([Review Complete]@row = "Review Complete", [Review Complete]@row = "Reviewed - Not applicable, Do Not Include", [Review Complete]@row = "Reviewed - Not applicable, send feedback"), [COMM Review Complete]@row = "COMM Review Complete"), "All Reviews Complete", " ")
-
That worked! Thanks!!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 459 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 138 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!