IF(OR (ISBLANK)... HELP

Elizabeth Aird
Elizabeth Aird ✭✭✭✭
in Formulas and Functions

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)


image.png


· Share on FacebookShare on Twitter

Best Answer

  • Brett Wyrick
    Brett Wyrick ✭✭✭✭✭
    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!

    · Share on FacebookShare on Twitter

Answers

  • Brett Wyrick
    Brett Wyrick ✭✭✭✭✭
    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!

    · Share on FacebookShare on Twitter
  • Elizabeth Aird
    Elizabeth Aird ✭✭✭✭

    Brett,

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


    so an AND statement instead?

    · Share on FacebookShare on Twitter
  • Brett Wyrick
    Brett Wyrick ✭✭✭✭✭
    https://community.smartsheet.com/discussion/comment/309415#Comment_309415

    @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!

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!