Restrict editing while allowing table filtering

Copper Contributor

Hi! I'd like to restrict users in my SharedDrive from editing a workbook, but I'd like them to be able to sort the data within the workbook (for themselves). Is this possible without requiring them to save a copy first? 

 

The document tracks projects/priorities company-wide. I'd like a member of a team to see what their team is working on and prioritizing, but also see what everyone is working on. The table allows filtering and sorting, but I don't want users to change the content within any cell. 

0 Replies