Count Project Question
Good afternoon,
We have various different 'centers of excellence' that our team supports for projects. Some projects may be overlapping between the centers of excellence, while others may just be specific to one singular center of excellence.
Overall, we have 26 projects altogether being worked between the different centers of excellence; however, as you can see in the visual below it shows many more projects when you add up the numbers because it is counting projects being worked on by more than 1 center of excellence multiple times:
Do you have any suggestions on how to limit it so the number of projects (26) is also represented in the chart, but you are able to see any projects being worked on by all/some COEs? For example, if HRIS and Regulatory have a project together is there a way to show that within the chart as 1 project, but associated with both COE? Here is the sheet we are using with projects and COEs associated with the projects -- our main point of concern is that we want to appropriately have COEs listed with however many projects they have, but we also don't want projects counted multiple times (if that makes sense)?
Please let me know if you have any questions.
Thank you!
Answers
-
@tbuilta Is there an issue with having a separate metric widget that simply displays the total number or projects? Then you could have the chart with the breakdowns?
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!