Filtering top Column

Hi I am wondering if I can filter the Top Row ( RIbbon ) to produce a sheet with a lot of data that I can set up departmental filters and not have to hide columns to do so.

It would be great if I could set up a filter called "accounting" and it would show only needed and agreed upon Data - and all else would be hidden

Thanks,

Answers

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭

    Hi @Mike Gieselman ,

    A workaround is to create a report for each department or user type. Include the columns and rows they need to see and leave out those they don't. Put links to the reports on a portal so people can find them quickly and select the report they need for the task at the time.

    Help?

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!