Welcome!

Edit lock rows

Hi,

Can I lock rows and assign specific people to edit it? Example only sales people can edit rows 1-10 and managers can edit rows 11-20?

Hi Frances,

Unfortunately, it's not possible at the moment because the permissions for the sheet sets what's possible or not, but it's an excellent idea!

As a possible workaround, you could use the automation to lock/unlock the rows at specific steps in a process.

Would that work/help?

I hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Thanks Andree!

Happy to help!

Delete
How can I delete old sheets I no longer use from my account?
How do I get a dashboard chart based on a report to display as a donut chart?
I'm trying to display a task progress chart showing "complete", "late", and "not complete" in my dashboard and for some reason the chart will display as a column chart but it won't display as a donut chart even though I'm referencing the same report. I'd prefer to display as a donut chart as I think it looks better and is…
Keep getting Selected data cannot be charted. Please select a new range.
Hello, I am trying to create a chart widget in my dashboard, but I keep getting "Selected data cannot be charted. Please select a new range." error. The report I am using is already summarized in numeric value. What is funny is I have report that I created a chart widget in another dashboard, and when I use that same…