Calculations on data located in multiple sheets

Katherine Britt

I am trying to pull project hours from multiple sheets and then find the average hours spent on each task. Is there a way to do this other than copying the rows to another sheet then performing the calculations?

Thanks!

Katherine

Bassam Khalil

Hi Katherine,

you can use in your summary sheet the following functions and build a formula to do that for you:

1- SUMIFS

2- VLOOKUP

3- AVG

if you can upload a screen shot for your work i can build the formula for you.

Best Regards

Bassam Khalil

Hi Katherine,

you can use in your summary sheet the following functions and build a formula to do that for you:

1- SUMIFS

2- VLOOKUP

3- AVG

if you can upload a screen shot for your work i can build the formula for you.

Best Regards

Katherine Britt

Thank you. I'll reach out if I get stuck. I was just hoping it was an easier way. Do you know if we will be able to do calculations in reports soon?

Bassam Khalil

Hi Katherine,

at your service any time, for calculations in reports i don't have any Idea when we can do that, to be sure smartsheet devlober team take care about this issue please send your request using the following form for Smartsheet Product Enhancement Requests.

https://app.smartsheet.com/b/form/739aa75f30ca43a8a22eb53e4da7d409?ss_v=110.0.2

Best Regards

Andrée Starå

Hi @Katherine Britt & @Bassam.M Khalil

It was scheduled for release at the end of October but has since been delayed.

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Bassam Khalil

@Katherine Britt 

You are welcome