Project Manager's Rolled up % allocation using metrics sheet


Hi there, looking for help from this group.

We currently have a master sheet where all projects live (1 row per project) and have a column for the project manager's name and a column with their manually entered allocation in percentage per project.

I would like to be able to have a metric sheet that would be able to calculate the total percentage per project manager from the allocation percentage column and allow me to show the allocation in a dashboard from a report.

I know this is probably super simple but I just can't seem to get it working.

Please help!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!