Exclude blank rows from intra-sheets IF formula

Silvia Brochet

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

bisaacs

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!