Unparseable and then need to scale up IF statement
I have the following - =IF(OR[Does pipe size match drainage drawing?]@row="",[Does pipe material match drainage drawing?]@row=""),"Awaiting assessment","Test")
This is imparseable - is this the blank check bit - ""?
I have noticed too that I would like to check for a 'No' in either of the cells. A 'No' would replace the Test text above with "Error found".
The bit I am missing then is if I get two yes's - this would be "No errors found".
I tried using IsBlank but after trawling the help pages still became imparseable!
I think if I have explained this right I should have covered every permutation of 2 cells which can only have Yes/No as answers?
Regards,
Paul
Best Answer
-
=IF(OR([Does pipe size match drainage drawing?]@row = "", [Does pipe material match drainage drawing?]@row = ""), "Awaiting assessment", IF(OR([Does pipe size match drainage drawing?]@row = "No", [Does pipe material match drainage drawing?]@row = "No"), "Error Found", "Checks OK"
You were missing an end parenthesis for your or statement.
You can combine or statements in various different ways, not knowing exactly what you are trying to do I can't help in to much depth. You are missing potential variations of the statement however. This formula will return blank for false variations of the first if statement.
Answers
-
=IF(OR([Does pipe size match drainage drawing?]@row="",[Does pipe material match drainage drawing?]@row=""),"Awaiting assessment","Test")
you're missing an open parenthesis after OR
-
Thank you - cannot tell you how many times I have looked at that equation. To achieve the next stages now, would you use nested IFs or is there a better way? I think once I have checked for 2 blanks and then a NO in each box, then the answers in the two fields must be YES? I can therefore add this to the end as - if not true?
-
Got to this and now get incorrect arguement set.
=IF(OR([Does pipe size match drainage drawing?]@row = "", [Does pipe material match drainage drawing?]@row = ""), "Awaiting assessment", IF(OR([Does pipe size match drainage drawing?]@row = "No", [Does pipe material match drainage drawing?]@row = "No", "Error Found", "Checks OK")))
Can you combine two IF OR statements?
-
=IF(OR([Does pipe size match drainage drawing?]@row = "", [Does pipe material match drainage drawing?]@row = ""), "Awaiting assessment", IF(OR([Does pipe size match drainage drawing?]@row = "No", [Does pipe material match drainage drawing?]@row = "No"), "Error Found", "Checks OK"
You were missing an end parenthesis for your or statement.
You can combine or statements in various different ways, not knowing exactly what you are trying to do I can't help in to much depth. You are missing potential variations of the statement however. This formula will return blank for false variations of the first if statement.
-
Excellent, thank you L@123. IF hierarchy works perfectly.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 143 Brandfolder
- 136 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!