Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Apply formulas to data aggregated in a report
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)?