Count unique values based criteria
I want to count the unique values in my data, but based on a specific criteria.
I have set up my data as above, and I want to get the unique count of Date and Handyman, but I would like to do it based on the value in the Month column. I know I can manually select the relevant rows for each month, but ideally if I can set up a formula that takes into consideration the Month column that would be ideal.
The formula I have used to get the distinct count of Date and Handyman is =COUNT(DISTINCT({Date and Handyman}))
Best Answer
-
Hey,
The way to use DISTINCT with COUNTIF is this:
=COUNT(DISTINCT(COLLECT({Date and Handyman}, Month:Month,1-Month number you would like to count)))
Hope it works for you.
Here is a link to a previuos discussion on this topic:
Let me know if that helped!
Itai Perez
Reporting and Project Manager
If you found my comment helpful any reaction, Insightful, Awsome etc... would be appreciated🙂
https://www.linkedin.com/in/itai-perez/
Answers
-
Hey,
The way to use DISTINCT with COUNTIF is this:
=COUNT(DISTINCT(COLLECT({Date and Handyman}, Month:Month,1-Month number you would like to count)))
Hope it works for you.
Here is a link to a previuos discussion on this topic:
Let me know if that helped!
Itai Perez
Reporting and Project Manager
If you found my comment helpful any reaction, Insightful, Awsome etc... would be appreciated🙂
https://www.linkedin.com/in/itai-perez/
-
Hi @Itai that worked perfectly! Thank you so much, knew there would be way to do it, just couldn't quite figure it out
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!