Using Reports / Dashboards for Analytics Recaps?
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!