Can I give an editor the right to delete rows on a single sheet?

Colleen Jones

Hi, we developed individual timesheets that feed the data into a team timesheet using automation. One problem we run into is when people enter rows by mistake or don't end up using, and they have no way to delete them from the individual sheet. This means that many of these rows end up in the team timesheet, which requires a lot of work tracking down if the time is missing or the row is a mistake, and so on. All of our team except for three of us have "editor - cannot share" permissions and are non-licensed users. I tried to look this up in the community, but couldn't find specific info about this particular scenario. Thanks for your help.

MichaelTCA

@Colleen Jones

Hello, sorry to say, but the minimum requirements for deleting locked rows require you to be an admin. Unlocked rows, you must be an editor.

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

Colleen Jones

Hi Michael, the rows are unlocked, though some of the columns are locked because of formulas. Does that make a difference?