Creating a report with grouping and summarizing from 2 different sheets

I have attached a screen shot of an excel template that I am trying to recreate in Smartsheet in a report. There are 2 sheets where this information is coming from. The first is just the names of the Supervisors and the Region they are managers of. The second spreadsheet has all of the information for everything else. I am not sure how to summarize or group these to make it look like the templates. Any help would be appreciated.

I also have attached the first sheet for more look into how that is set up. I need to figure our how to connect the 2 sheets as well through the Region column to match the region to the supervisor/manager

(the second sheet with the rest of the information does not have the supervisors name)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!