IF(OR (ISBLANK)... HELP
So I want a box to check IF any of the green boxes below are blank.
This isn't working... just trying to use 2 of the boxes.
=IF(OR(ISBLANK([1421 COATING WEIGHTS]@row), (ISBLANK([1310 CTG WEIGHT 1]@row), 1, 0)
Best Answer
-
Hey Elizabeth. Try this:
=IF(OR([1421 COATING WEIGHTS]@row="", [1310 CTG WEIGHT 1]@row=""), 1, 0)
If this answer answers your question, please press "Yes" above - it helps the community (and those random Googlers out there 👀) find solutions like yours faster.
Love,
Brett Wyrick | Connect with me on LinkedIn.
------------------------------------------------------------------------------
2023 update: I'm no longer working on Smartsheet stuff. I started working at Microsoft in 2022, plus I have 1-year-old twins at home and frankly, I don't have enough time to do Smartsheet anymore. It's been real, Smartsheeters!
Answers
-
Hey Elizabeth. Try this:
=IF(OR([1421 COATING WEIGHTS]@row="", [1310 CTG WEIGHT 1]@row=""), 1, 0)
If this answer answers your question, please press "Yes" above - it helps the community (and those random Googlers out there 👀) find solutions like yours faster.
Love,
Brett Wyrick | Connect with me on LinkedIn.
------------------------------------------------------------------------------
2023 update: I'm no longer working on Smartsheet stuff. I started working at Microsoft in 2022, plus I have 1-year-old twins at home and frankly, I don't have enough time to do Smartsheet anymore. It's been real, Smartsheeters!
-
Brett,
That worked ..but now that I look at it I need it to check if both are blank..
so an AND statement instead?
-
@Elizabeth Aird yes, an AND statement would work there!
If this answer answers your question, please press "Yes" above - it helps the community (and those random Googlers out there 👀) find solutions like yours faster.
Love,
Brett Wyrick | Connect with me on LinkedIn.
------------------------------------------------------------------------------
2023 update: I'm no longer working on Smartsheet stuff. I started working at Microsoft in 2022, plus I have 1-year-old twins at home and frankly, I don't have enough time to do Smartsheet anymore. It's been real, Smartsheeters!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!