Problem with filters on Licensed Users

Elton Soares

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?

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)

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!