Smartsheet Basics
Smartsheet Basics
Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.
Metric Widget is referencing sheet that has met the 500,000 cell limit - What do I do?
I have a dashboard widget that is referencing a sheet that recently met the 500,000 cell/row limit. I thought breaking out my sheets by year would be enough space, but I was wrong. Is there a way to keep the look and feel of my dashboard widget, but have it reference 2 sheets (or something like that)?
Thanks,
John Stanik
Best Answer
-
Hi @John Stanik
I hope you're well and safe!
You could maybe create a so-called Metrics Sheet where you collect data from multiple sheets and then add them together.
Make sense?
Would that work/help?
I hope that helps!
Be safe, and have a fantastic weekend!
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.
Answers
-
Hi @John Stanik
I hope you're well and safe!
You could maybe create a so-called Metrics Sheet where you collect data from multiple sheets and then add them together.
Make sense?
Would that work/help?
I hope that helps!
Be safe, and have a fantastic weekend!
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.
-
-
Andree,
Can this be done with the Summary section? I'm currently using Sheet summary data to populate the widget (forgot about that). If I duplicate the original sheet in order to continue collecting data, can I combine the summary data from both sheets into a single cell on the new sheet? Is there a formula for that?
Thanks,
John
-
Nevermind... I got it with the individual cells.
Thank you!!!!
John
-
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.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 208 Use Cases
- 517 Announcements
- 5.6K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 84 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
