Summing up everyday new entry value into a different smart sheet

admin58441 · 08/29/18

Hi,

Can anyone give me some idea on Summing up across multiple smart sheets new entry value in separate smart sheet please.

I can sum up specific cell values or range but i am looking for sum of daily entered values of same column from different sheets.

Andrée Starå · 08/30/18

Hi,

You could use cross-sheet formulas or cell linking to accomplish this, but I would need more information to give a recommendation. Can you share some screenshots or some more detailed information?

Please see the attached link/screenshot for more information.

https://help.smartsheet.com/articles/2476606-formulas-reference-data-from-other-sheets

https://help.smartsheet.com/articles/861579-cell-linking

I hope this helps you!

Best,

Andrée Starå - Workflow Consultant @ Get Done Consulting

Paul Newcome · 09/04/18

With what information there is thus far, I would suggest a series SUMIFS statements paired with your date column along the lines of:

=SUMIFS({X-Sheet 1 Sum Range}, {X-Sheet 1 Date Range}, TODAY()) + SUMIFS({X-Sheet 2 Sum Range}, {X-Sheet 2 Date Range}, TODAY()) + SUMIFS({X-Sheet 3 Sum Range}, {X-Sheet 3 Date Range}, TODAY()) + .........

admin58441 · 09/06/18

Hi Andree,

Thank you for your input. I will look into provided links.

Regards

Jay

admin58441 · 09/06/18

Hi Paul,

Let me try with sumifs and will come back to you.

Cheers

Jay

Andrée Starå · 09/07/18

Happy to help!

admin58441 · 10/02/18

Hi Paul,

Thank you very much, it did work well.

I have another interesting question. I would like to sum each last entry irrespective of date?

Can any you please suggest on this.

Paul Newcome · 10/03/18

I would like to sum each last entry irrespective of date?

Do you mean that you want to sum the last entry of all sheets regardless of whether or not it was "Today"?

If you simply have a date for the entry then you could be pulling multiple entries from each sheet (pulling the entry from the last row is possible, but could get to being a pain very quickly depending on the layout of your sheets). If you are using a Created (Date) type column that has a time stamp, you would be able to pull the most recent entry down to the minute.

Either way, you would simply use a MAX function when referencing the criteria portion specifying your date.

=SUMIFS({X-Sheet 1 Sum Range}, {X-Sheet 1 Date Range}, MAX({X-Sheet 1 Date Range}))..............

Summing up everyday new entry value into a different smart sheet

Comments

Categories