Using Reports / Dashboards for Analytics Recaps?

Hey there!

I'm currently tracking our sales analytics using a smartsheet.

Column A lists all of my metrics and then i create a column for each week. As the weeks progress, i fill in the rows with sales data.

I'd like to create a Dashboard that shows me the data from the last column (most recent week ending) on this smartsheet but I'm not sure how to pull that data into a report to display on my dashboard.

Appreciate any help you can offer!

Thank you!

Stephanie

Find more posts tagged with

Sheets

Healthcare

IT & Operations

Comments

Andrée Starå

Hi Stephanie,

You don't need to create a report for that. You could either gather the metrics on the same sheet or a separate one. Then use the metric widget on the dashboard.

Would that work for you?

I hope this helps you!

Best,

Andrée Starå - Workflow Consultant @ Get Done

Paul Newcome

We recently helped someone with almost this exact same thing...

https://community.smartsheet.com/discussion/how-select-value-last-column-range

If you would like to post a screenshot we may be able to help you tweak it to fit your needs a little better.

Sign in to join the conversation!

Quick Links

Trending discussions

SUmmary in Report Widget
How can i create a Report widget that only shows a status with "red status" from my main data source? Do i need to create a separate data source on just my "red status"
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…