Prevent Accidental Overwrite of Function Columns with Locking or Confirmation Dialog

[wiktorpyk]

Describe the problem to be solved

Our employees frequently overwrite formula columns by accidentally typing data into them. This replaces the entire column's formula with a static value.

Proposed Solutions:

1. Add an option to "lock" formula columns.

2. Trigger a warning popup when a user attempts to edit a cell in a formula column directly (not via the sidebar).

If there already is a solution to this problem, please let me know.

Describe the solution you would like

No response

[DavidFabijan]

Something like this would be super helpful.

[tgolub1]

I would recommend extending the lock / read-only feature to all data cells in addition to formulas (perhaps a system-wide toggle) to prevent accidental deletions / unintended edits when filtering / read-only interactions.