Set filter to only show certain columns

Hello!

I'm curious if a way has been found to only show certain columns, regardless if its implemented by SS or a work around.

The columns don't need to be automatically filtered by a specific criteria, but more if I could hide certain columns and have the sheet save that sort of setting for when I need it again, so I don't have to manually hide columns each time.

Find more posts tagged with

Filters

Accepted answers

All comments

Darren Mullen

@sawuzie That's what reports can be used for, and by the way, reports are 2 way so you can still edit sheet data directly in the report.

Debi.Fisher

@Darren Mullen - I did just that yesterday - created a Report with only the columns I want users to be able to see, so that they can easily enter some data. However, it doesn't appear even I can edit the report to add new rows, and I am the owner. I made sure that each user has Edit permissions for the report. I am the only one with a License.

Darren Mullen

@Debi.Fisher Correct, you can't add rows from a report. Only in a sheet or a form connected to that sheet.

Possible workarounds (the key to all Smartsheet solutions)

Use Dynamic View if you have it. This can limit column visibility and allow users to add rows
Embed the report on a dashboard with a form, this makes it easier for users to navigate between the 2
Add a column in the sheet with a link to the form, that way users can click on that link from any row to create a new one
Have users install the SSFeatures browser extension and save their own views of the sheet with the specific columns hidden/unhidden that they need.
https://ssfeatures.com/features/hide-unhide-column?via=guru

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.