Summing up everyday new entry value into a different smart sheet
Comments
-
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
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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()) + .........
-
Hi Andree,
Thank you for your input. I will look into provided links.
Regards
Jay
-
Hi Paul,
Let me try with sumifs and will come back to you.
Cheers
Jay
-
Happy to help!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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.
-
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}))..............
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 142 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives