How to restrict edit permission on Sheet or Workspace

vikrantyadav · 03/30/24

Hi Guys,

Need your help to apply restriction on Edit permission. So that user won't be able to edit or make any change in sheet. Kindly suggest, how can I make sheets view only or remove Edit permission ?

Andrée Starå · 04/02/24

@vikrantyadav

Happy to help!

I'd recommend using Groups to make sharing with different departments and similar ones easy.

Groups | Smartsheet Learning Center

https://help.smartsheet.com/learning-track/level-1-get-started/groups

Create groups in Smartsheet to quickly and easily control access to sheets and workspaces. Add new employees and team members to groups to get them up and running, and remove people from groups to ensure they no longer have access after they leave your organization.

Would that work/help?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

BullandKhmer · 03/30/24

Just change their permission to viewer.

vikrantyadav · 03/31/24

Hi @BullandKhmer Thanks for your response!

For viewer permission, I need to uncheck all these options like below screenshot ?

Andrée Starå · 03/31/24

Hi @vikrantyadav

I hope you're well and safe!

No, those settings are for the specific user on the account.

Have a look at this help article.

Sharing permission levels and tasks | Smartsheet Learning Center

https://help.smartsheet.com/articles/1155182-sharing-permission-levels

There are five permission levels in Smartsheet. When you share a Smartsheet item with someone, you can set the following permission levels:

Did that work/help?

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

BraylenStanton · 04/01/24

To restrict access to editing a table, you need to do the following: Open the table to which you want to apply restrictions. From the menu, select Settings or Options. In the Permissions section, select the Read Only or View option. Save your changes.

vikrantyadav · 04/02/24

Hi @BraylenStanton @Andrée Starå Thanks for your suggestion.

How can I do it in bulk, i want to restrict edit permission for 33 workspace and 130 sheets.

If I revoke user licence in that case, user will have view only permission , or still they will be able to edit sheet data ?

Andrée Starå · 04/02/24

@vikrantyadav

Happy to help!

I'd recommend using Groups to make sharing with different departments and similar ones easy.

Groups | Smartsheet Learning Center

https://help.smartsheet.com/learning-track/level-1-get-started/groups

Create groups in Smartsheet to quickly and easily control access to sheets and workspaces. Add new employees and team members to groups to get them up and running, and remove people from groups to ensure they no longer have access after they leave your organization.

Would that work/help?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

vikrantyadav · 04/04/24

Hi @Andrée Starå Thanks a lot for your help!

Group thing works for me.

Andrée Starå · 04/04/24

@vikrantyadav

Excellent!

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Smartsheet Basics

Smartsheet Basics

How to restrict edit permission on Sheet or Workspace

Best Answer

Groups | Smartsheet Learning Center

Answers

Sharing permission levels and tasks | Smartsheet Learning Center

Groups | Smartsheet Learning Center

Quick Links

Categories

Trending in Smartsheet Basics

How can people view my report of 4 combined sheets without sharing the 4 sheets?

Form Layout

Dashboard Help- COUNTIFS, Checkboxes and Hierarchy