Count and Distinct Formula returns 1

lschek1 ✭✭
edited 05/06/22 in Formulas and Functions

Hi, I'd like to retrieve the total values excluding duplicates, this is the formula used: =COUNT(DISTINCT([Part Number]:[Part Number])) ; using the count formula only returns the total value of 3535, which is correct considering duplicated cells, I thought it was due to an error in the data format or something similar, so I expected an error in the grand total as well, but I have no clue.

The total value excluding duplicates should be 475.

Best regards,

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!