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?

Best Answer

  • Elton Soares
    Elton Soares ✭✭
    Answer ✓

    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)