Formula help to count a distinct field when a condition is met
Hello Smartsheet Community,
I'm trying to count the Distinct Project names in a different sheet's column when another column, PI Group, matches [PI Group]@row, but am getting an Incorrect Argument. Can you help me finesse this formula? Thank you!! Below is the formula that's not working and the data it's referencing. -kerri
Best Answer
-
Try
=COUNT(DISTINCT(COLLECT({Product Increment Data Project Name}, {Product Increment Data PI Group}, [PI Group]@row)))
Answers
-
@Kerri S I would use Collect() inside the Distinct function to ensure you are only looking at the right subset of project names. The Collect function should let you build the list of projects where PI groups match. The Distinct function will then pick distinct project names, which you can count.
dm
-
Hi Dale - I'm still gettting Incorrect Argument.
=COLLECT(DISTINCT({Product Increment Data Project Name}, {Product Increment Data PI Group}, [PI Group]@row))
-
Try
=COUNT(DISTINCT(COLLECT({Product Increment Data Project Name}, {Product Increment Data PI Group}, [PI Group]@row)))
-
Works perfectly, many thank yous!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 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!