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.

Thank you.




In a new smartsheet you can set up a formula with cross-sheet references to do this. Set up the column of users email addresses in one column and user names in another then in the third column add the following adjust the column titles accordingly: 

=COUNTIFS({People at work}, OR(@cell = [email protected], @cell = [email protected]))

I check for both the display name and the email as in some instances smartsheet looks for one but not the other. In my screenshot, I couldn't find the Mike Wilday tasks by looking for email, it was only referencing the Name, but craig's tasks were only counting his email. Clearly smartsheet has a bug for accessing the email column and how it references them. 

How to insert a cross-sheet reference: https://www.youtube.com/watch?v=u01GHwmlDRA

Awesome! Glad I could help you out. Happy Smartsheeting! laugh