Preventing a formula overwrite?

Andrew Gross

Looking to prevent anyone from overwriting a column that has a formula.   This is currently not possible, correct?  Owners and admins can always overwrite a cell's formula?

 

Thanks, 

AEG

 

Lachlan Stead

Correct, you would need to allocate everyone else editor permissions or lower to be able to have that sort of control.

Andrée Starå

Hi Andrew,

How would you use it? What's your use case?

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Andrée Starå

A potential workaround could be to publish the sheet.

Would that work?

Best,

Andrée

Andrew Gross

Hi Andreé,

 

The purpose of the column is for display purposes only -- no data should be put into the column

 

Thanks, 

AEG

 

Lachlan Stead

Or... add every column to a report. This will mean the data will already need to be there, but the changes can be made by admins and yourself to any column except for the formula column.

Andrée Starå

Happy to help!

Ok. I agree with Lachlan then to use a Report but know that the users that are shared to the report can open the sheet and make changes according to their permissions.

Hope that helps!

Best,

Andrée