Exclude blank rows from intra-sheets IF formula

Options

Hello,

I am very new to Smartsheet and figuring out how formulas work.

I am using this formula to have a checkbox column checked when the values of another column match the ones of another sheet. I realized that in this other sheet that I am comparing it I have blank rows and when this happens the checkbox column is checked. How can I avoid this i.e. add to my formula to not check when there are blank rows?

My formula:

=IF(COUNTIFS({BioDISC test Range 3}, Species@row) > 0, 1, 0)

Thank you!

Silvia

Answers

  • bisaacs
    bisaacs ✭✭✭✭✭
    Options

    Hi @Silvia Brochet,

    You can use the ISBLANK() function to help you filter out blank cells:

    =IF(AND(NOT(ISBLANK({Cell Range})), COUNTIFS({BioDISC test Range 3}, Species@row) > 0), 1, 0)

    Hope this helps!

    If my response was helpful in any way (or answered your question) please be sure to upvote it, mark it as awesome, or mark it as the accepted answer!

    I'm always looking to connect with other industry professionals, feel free to connect with me on LinkedIn as well!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!