Need to count project managers and number of projects
I'm hoping the smartsheet Gods can help me.
I'm struggling. I have 126 projects in my sheet and about 30 different project leaders. Each project leader is set up as a contact (see 2nd screentshot - Pink)
I'm trying to count projects by project lead.
I'm hoping to come up with something like the first screenshot.
Any ideas are greatly appreciated.