Gridview to Dashboard

edited 12/09/19 in Smartsheet Basics

I am collecting data on hundreds of IDs that are designated by the primary column in grid view. Data is added as additional columns. I'd like to be able to condense the data for each ID, e.g. using a dashboard and 'card view', but I can't figure out how to do this without having to manually create the dashboard for each ID. 'Card view' doesn't seem to work either, because the primary column is Text. Anyone with an epiphany?


  • Hi, how about using a simple formula to "grab" the IDs from the primary column and present them in another column which is of the type DropDown List.  Simply set that DropDown column up with a copy of your ID numbers as values and then put the formula in over the top.  You can then use the card view.