Is there a way to reference a summary field from one sheet in another sheet?
I have sheet that contains master data for customers. The master data customer sheet has a set number of support hours available for each customer. I have another sheet that is collecting support hour information for the customers. A summary field has been created for each customer that sums the support hours for that customer.
Is there a way to reference the summary field containing support hours for the customer in a formula in the master data sheet? I would like to build a report or dashboard that would show the available support hours for each customer (Total support hours available - sum of customer support hours used = total available customer support hours).
Answers
-
I hope you're well and safe!
Yes, you can use cross-sheet formulas in the Sheet Summary too. Another option would be to add so-called helper columns or select a sheet section and link the Sheet Summary field to that area and then use cell-linking to collect everything in a Master Metrics Sheet.
Make sense?
Would that work/help?
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 support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
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 Andree,
Thank you. I am well and hope you are the same.
This is helpful, but I could not find anything in the Help / Support documents that showed how to reference the summary fields from a syntax perspective. In particular, how to reference the sheet and column needed.
Regarding the second option, the helper columns, I am unclear how that could be implemented in my situation. If you could point me to a reference document, that would be appreciated.
Thanks,
Matt
-
Hi Matt,
Thank you for asking this question. Did you ever get around to the answer on how to reference sheet summary from a different sheet? I've been looking around for a bit but haven't found anything either.
Wondering how you got around it!
Thanks,
Hem
-
Thanks for getting back to me, but I did not find a solution.
Thanks,
Matt
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 438 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives