Count Unique Entries Multiple Criteria
I would like to count the number of unique employees who have submitted an entry per quarter.
Here's the formula I tried:
=COUNT(DISTINCT(COLLECT(Employee:Employee, YRQtr:YRQtr, YRQtr@row, [Idea Approved/Denied]:[Idea Approved/Denied], "Approved")))
Always returns a value of 1.
Best Answer
-
I just tested out your formula and it worked perfectly for me:
=COUNT(DISTINCT(COLLECT(Employee:Employee, YRQtr:YRQtr, YRQtr@row, Status:Status, "Approved")))
Can you try creating a second sheet with just a couple rows and columns, and see if the formula works for you on a different sheet? Maybe something is going on with your main sheet that we need to figure out.
Cheers!
Nathan Braun (Founder of SSFeatures) (nathan@ssfeatures.com)
SSFeatures - The browser extension that adds essential features into Smartsheet.
Answers
-
I just tested out your formula and it worked perfectly for me:
=COUNT(DISTINCT(COLLECT(Employee:Employee, YRQtr:YRQtr, YRQtr@row, Status:Status, "Approved")))
Can you try creating a second sheet with just a couple rows and columns, and see if the formula works for you on a different sheet? Maybe something is going on with your main sheet that we need to figure out.
Cheers!
Nathan Braun (Founder of SSFeatures) (nathan@ssfeatures.com)
SSFeatures - The browser extension that adds essential features into Smartsheet.
-
It did work in a new sheet. Odd.
So… I ended up referencing the current sheet to a new sheet and got it to work. Thank you, but I really wish it would've worked on the original.
-
You're welcome! You can try deleting your YrQtr column and your Column10, then recreating those columns and re-adding the data back in. This is a super weird bug though!
Nathan Braun (Founder of SSFeatures) (nathan@ssfeatures.com)
SSFeatures - The browser extension that adds essential features into Smartsheet.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!