Problem with filters on Licensed Users

Hi, Guys.

I have a smartsheet with private information on 50 people. Some of them are full licensed users, others are simple users (they use a company license, but they can't create)

I want each of them to view only what regards to their names, but when I shared the sheet with them, even selecting to share only the filtered option, the full-licensed users are able to go in Filter and select other person's filter. It occurs even if I lock the filtered colunm.

I don't want to make 50 sheets. What can I do?

Find more posts tagged with

Accepted answers

Elton Soares

I Created a report from the original sheet, and in the field "Who" I choose the Colunm I wanted and then "Current user".

Now I only shared with them the report and prohibited them from looking in the data sheet, because they must be "viewer" in both of them (sheet and report)

All comments

Elton Soares

I figured it out!

Paul Newcome

@Elton Soares Could you please post the solution and then mark it as the "accepted Answer"? That way others know a solution has been found and can refer to this thread if they are having a similar issue.

Elton Soares

I Created a report from the original sheet, and in the field "Who" I choose the Colunm I wanted and then "Current user".

Now I only shared with them the report and prohibited them from looking in the data sheet, because they must be "viewer" in both of them (sheet and report)

Paul Newcome

@Elton Soares Well done! 👍️

A report set to "Current User" was going to be my first suggestion. Glad you were able to figure it out!

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.