Unique Count of Courses
gwson
✭✭✭✭✭
I am trying to get a count of unique courses from the source sheet (sample below) but it returns value of 1. What am i doing wrong?
=COUNT(DISTINCT({course}))
Answers
-
I figured it out, looks like there were some mix of numbers and text, and DISTINCT does not understand it for some reason.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!