We work with volunteers that log their hours via a form.
How might we calculate the hours of each volunteer so that it shows a running total of each in another board?
EG: Tony works 3 shifts of 4 hours.
In another board, under Tony’s name, it shows 12 hours.
Use a connected board column. Ie Board 1 is the volunteers, Board 2 is the forms. Each form is connected to a volunteer. Then on Board 1 you do a mirror column to pull in the a column that includes the hours (it will total it)
Hi @dmccarthy22710!
Thanks for the response.
When you say “Each Form”, do you mean each form response ie Item?
I’m having trouble visualising how that works.
Correct, each form response ie item would then be connected to a volunteer on the other board.