How can a contact field by aggregated to show a count?

Carol C
Carol C ✭✭
edited 10/19/22 in Smartsheet Basics

I have a list of projects and each project has an individual as a contact. An individual could be listed for multiple projects. I'd like to chart to reflect how many projects each individual is responsible for. The trouble I'm encountering is that the report doesn't allow me to summarize on the contact list field and the chart widget doesn't support charting a contact list. Is there something besides converting the contact list to text?

Best Answer