Metrics from Report for Sight

I currently have a sheet for each account manger that lists there account and a few key metrics. I then created a report that brings in all of the 10 sheets into one place so I can see our entire portfolio. We move/add accounts often so the report allows me to see total book in a much easier format than linking. I have a dashboard that I want to display Total Number of accounts, count the statuses - is there no way to use metrics off a report. Will I have to go back to sheet level with single cell links?

Find more posts tagged with

Reports

Dashboards

Cell linking

Account and User Management

Comments

Dartwohl

Please see attached screenshots. In this example sheet (Project 1), the administrator has chosen to gather sheet metrics through formulas. The administrator does this for all of his/her project sheets (Project 2, Project 3 etc.). From there, a master sheet is created using cell linking to gather the metrics from each sheet. Finally, the cell data widget is used to show things like the total number of open tasks, at-risk projects etc.. Hope this helps.

1-16-2018 11-20-18 AM.jpg

1-16-2018 11-19-46 AM.jpg

1-16-2018 11-12-18 AM.jpg

Doug Carr

Dartwohl . . . This is a decent work around but, unfortunately, it is still a work around. Is there no movement on being able to pull metrics from a report. This seems like something that should have been built in from the beginning. The use of a lot of calculated fields and cell inks is fragile in Smartsheet. It doesn't take much to get a bad link and then have a lot of missing metrics on dashboards.

Paul Ayres

I have a similar issue. 100 projects feeding into a row summary report where I now need to count projects with various status. The number of projects makes cell linking an unwieldy solution. Being able to essentially 'report on a report' would be very useful indeed.

Sign in to join the conversation!

Quick Links

Trending discussions

Folder Level Sharing
Circling back to this….. Another year goes by and still no folder level sharing. Smartsheet developers don't listen to their clients. I have seen hundreds or posts and requests for this over the past 7-8 years. And still NOTHING!! This has been a huge issue for us as a company. As you can tell this is a sore spot for us…
Restore multiple cell changes from Snapshot
Today a team member accidentally changed several rows by either deleting the data or the row itself. Do I download a snapshot of each one to restore? Some of them didn't seem to be too helpful. What is the protocol for restoring this information? I've only done this before with the help of a representative and it was…
Why are my answers not showing up when a document is generated?
I have my Smartsheet set to generate a document when a form is filled out. The document is a fillable PDF and when the document generates not all of the answers populate on the generated PDF. I have tried making the PDF again from scratch, I have tried copying and pasting the fields so I know they're the exact same…