Use a Filter to hide/show/reorder columns? (Like a SQL "view")

Jamie Bedford

Hi there,

Is it possible to do something similar to a SQL "view" with a sheet? I see that I can create named Filters, but these only let me change which Rows appear -- not which Columns (and not in what order).

It'd be very useful to have multiple "views" of a data set that could be targeted to different audiences who need different information.

I tried linking rows to a new Sheet and then modifying ordering, etc., in that sheet, but then when I add a new row to the source sheet it does not automatically appear in the destination sheet. Not a very good behavior. Plus, having multiple sheets is not ideal -- more sources of truth = more likelihood of things breaking, data becoming out-of-date, or people referring to different data without realizing it.

(I'm on a Government / Smartsheetgov tenant, btw.)

Thanks!

Jamie

Matt Johnson

Hi @Jamie Bedford

"Reports" is the what you are looking for. Creating reports from your single source of truth will provide you the options to select specific / rearrange columns and select specific rows on each report. When the report is updated, it automatically updates the worksheet.

You could even create a dashboard where each report can be viewed and clicked on right there on the dashboard. It could be the one-stop-shop for all reports leading to the single source of truth. Even without the dashboards though, reports are what you are looking for. Please reach out again if you have any questions.

Thanks,

Matt Johnson

Hi @Jamie Bedford

"Reports" is the what you are looking for. Creating reports from your single source of truth will provide you the options to select specific / rearrange columns and select specific rows on each report. When the report is updated, it automatically updates the worksheet.

You could even create a dashboard where each report can be viewed and clicked on right there on the dashboard. It could be the one-stop-shop for all reports leading to the single source of truth. Even without the dashboards though, reports are what you are looking for. Please reach out again if you have any questions.

Thanks,

Paul Newcome

Keep in mind...

To have access to a report that can be edited, the user(s) will need at least Viewer permissions to the source sheet(s). If you do not want the user to have access to the source data, then you can publish the report(s), but published reports cannot be edited.