How to change metrics by row for Dashboard
I have a sheet that has information for potential projects. Each project has a main row containing info that I have linked up to a dashboard. The idea is that I will pdf the dashboard with the project info, much like a proposal. I would like to make it so that I only have one dashboard and I can change the row that it references rather than have a dashboard for each project.
- I have tried filtering via reports, but the dashboard uses mainly metrics widget so doesn't work with reports.
-I have tried having one row at the top of the sheet that will mirror the required row by entering the row number in another cell. I think this might work as Concatenate in Excel, but the cell references in Smartsheet works differently.
Any suggestions welcome!