If Or????
I've replicated this formula from another sheet of mine but this one is a bit longer. All the cells are highlighted property when the formula is highlighted, but I still ger an #unparseable
=IF(OR(ISBLANK(Client@row), isblank([Planter Location]@row), isblank(Item@row), isblank(Color@row), isblank(Size@row), isblank(Quantity@row), isblank([Purchase Price]@row)), 1, ""))))))))
Best Answer
-
From what I can tell you have Way too many ) at the end of your formula. Based off the formula it should be.
=IF(OR(ISBLANK(Client@row), isblank([Planter Location]@row), isblank(Item@row), isblank(Color@row), isblank(Size@row), isblank(Quantity@row), isblank([Purchase Price]@row)), 1, "")
The reason is each of your isblank statements are already closed off. So you just have to close off the OR statement. Which you have done properly. The. You finish off the true or false conditions for the if statement. Then close it off. When you enter the formulas watch the colors of the ) at the end. They will match up with the corresponding one at the beginning of the function you are closing off. Once they turn all black you have too many.
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
Answers
-
From what I can tell you have Way too many ) at the end of your formula. Based off the formula it should be.
=IF(OR(ISBLANK(Client@row), isblank([Planter Location]@row), isblank(Item@row), isblank(Color@row), isblank(Size@row), isblank(Quantity@row), isblank([Purchase Price]@row)), 1, "")
The reason is each of your isblank statements are already closed off. So you just have to close off the OR statement. Which you have done properly. The. You finish off the true or false conditions for the if statement. Then close it off. When you enter the formulas watch the colors of the ) at the end. They will match up with the corresponding one at the beginning of the function you are closing off. Once they turn all black you have too many.
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
-
Thank you Mark!!! Much appreciated.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 378 Global Discussions
- 208 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 290 Events
- 33 Webinars
- 7.3K Forum Archives