Using Reports / Dashboards for Analytics Recaps?

Stephanie Sperling

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

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.