Checkbox find duplicate in a column, do not check either box if either has a value in 2nd column

I am using a checkbox to find duplicate entries in the column name Email. I can up with this that worked, =IF(COUNTIF(Email:Email, Email@row) > 1, 1). 

Next, I am looking for both duplicates to not have a value in the Using Generic Account field and then check both boxes. Do not check either box if one of the two duplicates has a value in the Using Generic Account field. I can up with this =IFERROR(AND(IF(COUNTIF(Email:Email, Email@row) > 1, 1), IF(COUNTIF([Using Generic Account]:[Using Generic Account], [Using Generic Account]@row) > 1, 1)), 0). 

This works if both rows do not have a value in the Using Generic Account field. But if one does, the one without the value is still checked. 

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!