# IF(OR (ISBLANK)... HELP

Options
✭✭✭✭

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)

• ✭✭✭✭✭
Options

Hey Elizabeth. Try this:

=IF(OR([1421 COATING WEIGHTS]@row="", [1310 CTG WEIGHT 1]@row=""), 1, 0)

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!

• ✭✭✭✭✭
Options

Hey Elizabeth. Try this:

=IF(OR([1421 COATING WEIGHTS]@row="", [1310 CTG WEIGHT 1]@row=""), 1, 0)

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!

• ✭✭✭✭
Options

Brett,

That worked ..but now that I look at it I need it to check if both are blank..

• ✭✭✭✭✭
Options

@Elizabeth Aird yes, an AND statement would work there!

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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!