On Sheet Summary: Count # of distinct values in a column
Hello, I have a Smartsheet where I'm trying to count distinct values in a column. Currently I've tried this but get #UNPARSEABLE.
Where Prj_ID is the column where I want to to count distinct Project IDs.
I'm hoping to get help from someone who's done something similar.
I've also tried:
but in that case I get the value as '1' which isn't correct.
Help Article Resources
Check out the Formula Handbook template!