Help

Re: Total Volunteer Hours

914 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Cosmo_Catalano_
5 - Automation Enthusiast
5 - Automation Enthusiast

I have a table where I collect the hours from individual vols working on specific projects. They enter their hours via a Form. Some vols have 30 different entries. I can group them by name to see the total hours for each individual, but have to scroll to each one to compile annual totals for each volunteer. I want to be able to take that total and create a table where each volunteer record returns their total annual hours. Shouldn’t be that hard to do, but I can’t crack it.

Cosmo

5 Replies 5

You can add a Formula field for the Year (from the entry Date), with the YEAR() function, and then Group by that too.

Cosmo_Catalano_
5 - Automation Enthusiast
5 - Automation Enthusiast

Sorry, I didn’t do a great job explaining what I’m attempting. Here’s a screen shot of the Table sorted by volunteer name. I want to be able to create a view that shows just the names and the Sum (circled in red).
Screen Shot.jpeg

Otherwise I need to scroll through the list at the end of the work season and create a spreadsheet manually. I set up a fresh new Base for every season, since we only report annually but want to save the work hours year to year.

Cosmo

You can add the Year field, and then Group by year as I said, or create Views for every year. You can collapse the Groups from the settings.

Original:
Captura de pantalla 2018-12-01_11-24-40_p. m..png

Gruped by Year and with totals per Volunteer:
Captura de pantalla 2018-12-01_11-25-49_p. m..png

Views by Year:
e846eedd6646eb274acf76f580f708732692a623.png
7dab8988423e424736cb05871fb46dc5a2121dad.png

Cosmo_Catalano_
5 - Automation Enthusiast
5 - Automation Enthusiast

Got it. thanks! Any way to collapse the groups for the entire table at once, or do I need to go through and manually collapse each person?

804101e21b4d3defce2a2c440f919732f7c0998c.png