Use a Filter to hide/show/reorder columns? (Like a SQL "view")
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.)