How do I build a formula that looks for duplicates that also ignores blanks or "N/A"?


I'm trying to build a formula that counts if it finds a match so it will check a box but I don't want it to count blanks or when someone enters "N/A".

=(IF(COUNTIFS([Document ID #*]:[Document ID #*], [Document ID #*]@row) > 1, 1))

And no matter what I try I seem to break the formula.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!