Summing up everyday new entry value into a different smart sheet

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.

Find more posts tagged with

Healthcare

Reports

Cell linking

Comments

Andrée Starå

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

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

Hi Andree,

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

Regards

Jay

admin58441

Hi Paul,

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

Cheers

Jay

Andrée Starå

Happy to help!

admin58441

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

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}))..............

Sign in to join the conversation!

Quick Links

Trending discussions

I am an Admin, but I cannot edit the workspace
I am already an Admin of a workspace, but when I enter the sheet to edit, it prompts me that I am a viewer. Has anyone encountered this situation? In the share tab, it shows that I am both an Admin and a viewer. How could a product from such a large company have such a BUG?😫
How to recover data after I ran a new workflow and lost my data
The black arrow indicates when (around 4:30pm) the mistake was made. I would like to recover a previous version say around 2pm.
Why is % Complete not the same between Smartsheet and Microsoft Projects
I have two identical projects with the exact same data, but the % Complete in Smartsheet is 14% and the % Complete in Microsoft Projects is 4%. Which one is correct