Fixing Count Distinct Collect Returning 1


I want to calculate the number of values in a column that are unique. However, I'm getting a return of 1 instead of a full count. How do I fix this?

Formula: =COUNT(DISTINCT(COLLECT([PRJ Number]:[PRJ Number], [PRJ Number]:[PRJ Number], ISNUMBER(@cell))))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!