Using Count & Distinc formulas to
Hello everyone!,
I'm having troubles trying to get the count from a list and showing in other sheet (For this image, I put it in the same sheet but I'll on other "data sheet"). In the other sheet; I would like to have the count of unique date related with de responsible Column "Resp". So if someone put any kind of task related with their name, is going to count but with the criteria of the initial date. So in the image you can see that "Diego" has a number 3, beacuse even if the task is the same names, he got 3 different dates , so in that way the formula has to recognize and related the "Resp" & "Initial date".
So if someone can help me, it would be awesome!
I hope I made myself clear,
Thanks in advance
Diego
Best Answer
-
Hi @Diego Cardenas , give this one a try...
=COUNT(DISTINCT(COLLECT([Initial date]:[Initial date], Resp:Resp, "Diego Cardenas")))
This formula will work for your current sheet layout. If you want to cross reference to another sheet, just replace the ranges in the formula with your Cross Sheet Reference names.
Let me know if you run into any issues.
Ryan
Answers
-
Hi @Diego Cardenas , give this one a try...
=COUNT(DISTINCT(COLLECT([Initial date]:[Initial date], Resp:Resp, "Diego Cardenas")))
This formula will work for your current sheet layout. If you want to cross reference to another sheet, just replace the ranges in the formula with your Cross Sheet Reference names.
Let me know if you run into any issues.
Ryan
-
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!