COUNTM not working


Hello community, I have a formula to count distinct values in my column. However, it is not working how I'd like it to. This is the formula with the image below that it relates to:

=COUNTM(DISTINCT([19th Mar]3:[19th Mar]60))

The number of counts is 5, but it should be 3 because 'FG' 'BK' are repeated.

I assume it's not working because of multiple cell values in one cell.

Does anyone have a solution?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!