How to create a dashboard from a client smartsheet project
We are working on a system conversion. The project is in Smartsheet but owned by the new system company.
They've not been able to provide the level of reporting my SLT is requesting.
How can I create a dashboard from that project without doing any changes or calculations, summaries within their project?
They did make me an admin so I can create reports, but they lack some details that I need to calculate.
Any suggestions?
Thanks for your help!🙂
Answers
-
You can leverage premium apps if you have access. DataMesh can create a dynamically updating duplicate of the original sheet, Data Shuttle to produce "snapshots" of the sheet that in turn can be selectively moved to a sheet you own, and Pivot can aggregate info from reports you can already create. Since you'd own those assets, you can add the formulas or summaries to your need, and use them as the basis of your dashboarding.
If you don't have any premium app access (or don't want to go that deeply), you can create KPI sheets - cross-sheet formulas that could be strategically created to give you a separate place to do the calculations you need. This may or may not be able to solve what you're after, depending on the specific calculations you need.
The simplest answer to me, though, seems to be to add column formulas to the existing sheets and then hide those columns. That way you'll have access to whatever info you need (and can resurface via Reports) but the user experience on the project management sheets will be effectively the same.
If this answer resolves your question, please help the Community by marking it as an accepted answer. I'd also be grateful for your response - "Insightful"or "Awesome" reactions are much appreciated. Thanks!
-
Hi,
I hope you're well and safe!
You could add a so-called helper sheet that replicates the structure using cell-linking or cross-sheet formulas and then add the other necessary columns.Make sense?
Would that work/help?
I hope that helps!
Be safe, and have a fantastic day!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!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
I started with cell linking but the cell limits would take too much time to set up.
I don't think I know about cross sheet formulas. I don't think I've heard of it but will look it up.
-
Ok.
You could connect the sheets using cross-sheet formulas combined with either a VLOOKUP or INDEX/MATCH structure. When you update the source sheet, it will reflect on the destination sheet.
To connect them row by row, you'd use an Autonumber Column in the Source sheet and add a so-called helper column to manually add the row ID on as many rows as you think you need in the Destination sheet.
✅ Remember! Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!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,
Thank you. I will give it a try.👍️
Angie
-
Excellent!
You're more than welcome!
✅ Remember! Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 439 Global Discussions
- 138 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
