Saved View w/ Filters & Hidden Columns

It would be a great feature to be able to save a view with certain filter criteria as well has hidden coumns. We use and love smartsheet for reference and for example our accounting team needs to see (and often copy) info that differs from what our permitting team would need to view. Since all this info is stored on the same smartsheet - there is a lot of scrolling side to side . . .or repeated hide/unhide of columns. Thanks!

Sign in to vote!

Find more posts tagged with

Idea Submitted

Comments

rosegarretson

Hi -

I have repetitive tasks I do in certain sheets. It would be very helpful if I could create a view with hidden columns and save that view - much like how filters work. I know I can also create a report or reports that can mimic the same thing visually. Still, there are functions and features in sheets that aren't in reports...

Is this on the table for development?

Thanks!

Rose

Genevieve P.

Hi @CTrezona

Have you thought about creating two Reports from the same sheet? That way you can provide a filtered view with select column for each team to work in. You can make changes to most cell data in a Report which then immediately is updated in the underlying sheet.

They would still need to be shared to the underlying sheet, but it would prevent the scrolling/hiding and unhiding that you're mentioning. 🙂

CTrezona

Thank you Genevieve P. - I'll study up on my reports! Appreciate your time. CT

Koleen Steiner

@CTrezona - OR Try the Dynamic View. I love them for permission control OR when I want to build with a base filter on the original sheet, with a "layered" filter on the DV - with the added benefit of controlling what columns are exposed and what columns they can edit. This protects any accidental updates on the original sheet, cleans up the view and ensures the filters are working correctly! Reach out if you need more creative ideas. :)

Good Luck!

K-

Quick Links

Trending ideas

Automations Tracker
I have a workflow with nearly 40 automations, half of which are email-based requests for updates with various sets of triggers. While I know the automations work, due to months of testing, when our system went live to the institution, I became very worried that the automations wouldn't run and I'd have no idea whether or…
Preserve Original Filenames for Multi-Photo Uploads in Smartsheet Mobile App
Description: When users upload multiple photos in one action via the Smartsheet iOS mobile app, all files are assigned the same generic name and timestamp. This makes it difficult to identify individual photos and creates confusion in workflows that rely on accurate, unique file naming. Why This Matters: Industry Standard:…
Joyful Animations - in Smartsheet!
I am proposing bringing a bit of pizzazz to Smartsheet by having celebratory animations for certain criteria. Think Joyful Animations in Outlook! My team was hoping to have some sort of confetti pop/gif/image when we close out a project or hit a milestone. Bonus points if it is configurable like the automations are.