Count Project Question

tbuilta ✭✭✭
edited 06/09/23 in Formulas and Functions

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!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!