How do I prevent a formula from checking an empty row.

ALEX BOSTROM

I have a formula that checks a box if a name appears on another sheet. However, when there is an empty row the column remains checked. How do I prevent this?

In "Previous Student (within last year)" there are check marks when there is no name in the name column.

Here is the formula I am using: =IF(COUNTIF({Fall 21 Names}, [Legal Name (Last, First)]@row) + COUNTIF({SP 22 Student Names}. [Legal Names (Last, First)]@row) 0, 1)

MVP OPS

Hi Alex,

you could just add an =if(isblank(Namecolumn@row), "", IF(COUNTIF({Fall 21 Names}, [Legal Name (Last, First)]@row) + COUNTIF({SP 22 Student Names}. [Legal Names (Last, First)]@row) 0, 1)

Hope this helps.

best

Brad

MVP OPS

ALEX BOSTROM

That did solve part of the problem but now the rest of my formula doesn't work.

MVP OPS

Hi @Alex,

Can you post your formula here. It looks like there are some commas missing.

the formula should look something like this:

=if(isblank(Namecolumn@row), "", IF(COUNTIF({Fall 21 Names}, [Legal Name (Last, First)]@row) + COUNTIF({SP 22 Student Names}, [Legal Names (Last, First)]@row), 0, 1))

best,

Brad

MVP OPS

ALEX BOSTROM

Yes! That worked! Thank you so much for your help!

MVP OPS

Oh that's great! Happy to help.