Unique Count of Courses

gwson

gwson ✭✭✭✭✭

10/26/23 edited 10/26/23 in Formulas and Functions

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}))

Screenshot 2023-10-26 at 12.06.47 PM.png

0 ·

Answers

gwson ✭✭✭✭✭

10/26/23

I figured it out, looks like there were some mix of numbers and text, and DISTINCT does not understand it for some reason.

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Multiple Sequences Need to Be Complete/NA to Provide a Complete Value
Writing formulas is not a strong suite of mine - I've tried a few routes (IF OR AND) but I'm either running into invalid formulas or formulas that are not netting the right results. I am trying to write a formula where I'm looking for sequence values to be either Complete or N/A and based on those sequences being one of…
IF statement based on cells in same row
I have a sheet where every row requires two approvals before it's fully approved. What would the formula be to make this work? For example, approval column 1 is named "initial approval" and approval column 2 is named "COHS approval". Both cells are dropdowns with the options pending, approved, or denied. I want the first…
Need to add an or condition to Count/Collect Formula in Project Metrics Sheet.
I need to modify below formula to collect Project ID's on intake sheet where Project Status is "In Progress" or "Not Started". Below works only if Project Status is "In Progress" =COUNT(DISTINCT(COLLECT({Project ID}, {Project Status}, "In Progress", {Project Length}, Label@row)))