So we've just started using smartsheet to track hours used for different projects. Each person gets one individual sheet to fill in.
Once a week a report extracting the hours from the last 7 days is extracted and sent to the people keeping track of the mother organization.
However, as a manager I'd like to keep track of the hours as well. Is there anyway I can use the data in the report (extracted from multiple sheets) and calculate their sum (e.g. how many hours where spent in the deptatrment on project C last week)?
Christopher
