Apply formulas to data aggregated in a report

Christopher Grinde

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

Kara Lumley

Hi Christopher,

 

I have an idea that would likely work for this, can we set up a 30 minute call so I can so you?

Best,

Kara

Christopher Grinde

Sure. Either within the next hour (9 PM CET Thursday 11 August) or sometime next week (e..g Monday 9 PM CET/12 your time?). 

Kara Lumley

Thanks, just sent you an invite.

Best,
Kara