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

Options

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

Comments

This discussion has been closed.