Locking Automations

Brianna Kempfer

We have numerous automations set up across multiple sheets, is there a way to lock these so editors/viewers aren't able to change them?

Andrée Starå

@Brianna Kempfer

Editors and viewers aren't able to change or delete them or at least they shouldn't be able to.

What are they doing more specifically?

Andrée Starå

@Brianna Kempfer

Excellent!

You're more than welcome!

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

Mary_A

@Brianna Kempfer A user with Admin or Owner rights on a sheet can create formula lock rows. Users with editor or view permissions cannot edit locked rows.

I typically add the phrase FORMULA LOCK to a text column in the row and then use conditional to format them. Learned this working with some Smartsheet folks.

Brianna Kempfer

Thank you, but I am talking about the notification automations that you can build into sheets.

Andrée Starå

Hi Brianna,

Editors and Viewers can only create and edit row level reminders.

What isn’t working?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

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

Brianna Kempfer

Hey! We want to lock the workflow automations so that other editors and viewers aren't able to change or delete these. I am able to lock the rows and understand that, but I can't find information on locking the workflow automations.

Andrée Starå

@Brianna Kempfer

Editors and viewers aren't able to change or delete them or at least they shouldn't be able to.

What are they doing more specifically?

Brianna Kempfer

Awesome! That is exactly what I needed. I must have overlooked it when I checked there. Thanks!

Andrée Starå

@Brianna Kempfer

Excellent!

You're more than welcome!

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