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

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)


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!