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)?




This discussion has been closed.