Single Row Report

MatR ✭✭
edited 12/09/19 in Smartsheet Basics

I'm incredibly new to Smartsheets (I joined yesterday) and am feeling my way around quite nicely. However, certain things are eluding me.

We have a single smartsheet that contains information that we publish to a website. Each row is an indicator that gets published quarterly.

What I'd like to do is to be able to produce a graph from 4 columns in the sheet, but only on a single row that I could then adjust. I.e. The graph shows columns data from columns 4,5,6,7 in row 1, which I could then adjust to show data from the same columns on a different row....if that makes sense.

I'd like to produce a dashboard that will allow a user to cycle through each indicator and have the graphs and metrics adjust based on the indicator chosen.

Is this possible?