Help with COUNT and DISTINCT function

Options
jmo
jmo ✭✭✭✭✭✭

Hi team - I have a column called Agreement # that has various agreement numbers in them but also many duplicates. I'm trying to get a count of unique numbers but when I combine the COUNT and DISTINCT functions - it keeps coming up with 1.

The Agreement # column looks like this (example):

Is there a problem because there are blanks between the parent row with a number in it?

How would I make the COUNT and DISTINCT funtions to work and disregard blank fields, if that's the problem?

Thanks,

Jeff

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!