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)



Best Answer

  • Brett Wyrick
    Brett Wyrick ✭✭✭✭✭
    Answer ✓
    Options

    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

  • Brett Wyrick
    Brett Wyrick ✭✭✭✭✭
    Answer ✓
    Options

    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!

  • Elizabeth Aird
    Elizabeth Aird ✭✭✭✭
    Options

    Brett,

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


    so an AND statement instead?

  • Brett Wyrick
    Brett Wyrick ✭✭✭✭✭
    Options

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!