Count(Distinct()) function that works with one column (range), but not another.


Hi All! I am using a =Count(Distinct({Range})) which works exactly as expected with one range of data, but returns a "1" with the exact same formula on an adjacent column of data. The only difference between the data in the 2 columns is the data. Same column type, similar numbers, etc.

Anyone had this issue before?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!