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, smartsheetguru.com
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.2K Get Help
- 360 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!