Duplicate (countif) keeps showing false value

edited 02/12/24 in Formulas and Functions

I am using the countif function to show if a duplicate exists, but it keeps counting when there is no duplicate.


It works for the previous data I created, but when I add more using the forms, it always shows 1 as a duplicate count for the column. Even when I type in random letters and numbers, it will always show as 1. It only shows as 0 when I change the value to more than one zero.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!