I provide updates to different groups in PDF and Excel format. Not all columns are visible to all groups, and they aren't always in the same order for all groups.
I'm wasting more time than I would like unhiding and re-hiding specific columns, dragging the columns into the right order, and then setting the column widths, etc. to re-create these layouts all the time.
I would LOVE to be able to just set this up once for each group and SAVE the layout so I can recall it later. I.e. I want one sheet, where I make updates, and I then want to have different views of that sheet (not just card or grid or gantt, but actually my own layouts) that I can quickly pull-up to export a PDF or Excel doc.
Is there any way to do this? I'm not a smartsheet expert by any means, so maybe there is a way to do this using Reports, or something like that. I just don't know enough to know what is/isn't possible.
Any shove in the right direction would be helpful. Thanks in advance!
----------------edit to add additional info-------------------------
I use these sheets during cross-functional meetings and meetings with department managers, so I need to be able to present the correct "view" of the sheet (i.e. column order, hidden columns, column widths, etc.) during these meetings, and be able to make updates to the sheet during these meetings in real time. After the meeting, I create the report and send it out to additional parties.
