Sign in to join the conversation:
Hello There,
I was wondering if it is possible to set a rule to limit the Editorial right in order to avoid deletion of rows and columns?
Thanking you.
Hi Sepi,
You could lock and unlock rows with Alerts & Actions rules.
Would that work?
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
Andree is correct. Editors cannot edit locked rows or columns. If there is particular data on a column or row that you don't want editors to touch, lock those columns. See this for more on column locking:
https://help.smartsheet.com/articles/522077-locking-unlocking-columns-and-rows
My manager set up a weekly smartsheets attachment of a sheet to be emailed to them every week. She now wants to turn this off but when her and I go into the Send as Attachment section of the page it only shows that two were sent instead of weekly for the last year or two and there is no way to turn anything off. How do I…
I have a large master sheet that I do not want anyone to have access to except the small team of admins. Is there a way for everyone in a dept to see the projects their dept are involved in (this is defined by a column), but only the PM can make edits to it? Bonus points if we can sort by "Status" then by "Kick-Off Date".…
Is there a way to have a master report that is pulling in the data from all of the necessary sheets and then several minor reports off this one where certain rows can be shown in certain sheets? The reason for this is because as projects get created in the workspace the admin then has to go into 5 reports and link the new…