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

I am an Admin, but I cannot edit the workspace
I am already an Admin of a workspace, but when I enter the sheet to edit, it prompts me that I am a viewer. Has anyone encountered this situation? In the share tab, it shows that I am both an Admin and a viewer. How could a product from such a large company have such a BUG?😫
How to recover data after I ran a new workflow and lost my data
The black arrow indicates when (around 4:30pm) the mistake was made. I would like to recover a previous version say around 2pm.
Why is % Complete not the same between Smartsheet and Microsoft Projects
I have two identical projects with the exact same data, but the % Complete in Smartsheet is 14% and the % Complete in Microsoft Projects is 4%. Which one is correct