Locking and unlocking a Column with a Formula

Vinton Douglas

How do I lock a column with a formula so that it cannot be tampered?

How do I unlock the column with the formula?

Andrée Starå

Hi @Vinton Douglas

I hope you're well and safe!

Unfortunately, it's not possible to automatically lock/unlock columns, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment.

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Genevieve P.

Hi @Vinton Douglas

To add to @Andrée Starå's correct answer, you could manually lock the column with the formula by right-clicking on the Column Name at the top of the sheet and selecting this option from the drop-down list.

Keep in mind that uses with Admin or Owner permissions on the sheet will still be able to make edits. See: Lock or Unlock Columns and Rows

Additionally, if you set a formula as a Column Formula this will also "lock" the column so only users with Admin permissions could make adjustments, see: Set Formulas for All Rows with Column Formulas

If you have more questions, it would be helpful to see a screen capture of your current set-up (but please block out sensitive data), and a copy/paste of the formula you're using.

Cheers,

Genevieve

Andrée Starå

Hi @Vinton Douglas

I hope you're well and safe!

Unfortunately, it's not possible to automatically lock/unlock columns, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment.

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Genevieve P.

Hi @Vinton Douglas

To add to @Andrée Starå's correct answer, you could manually lock the column with the formula by right-clicking on the Column Name at the top of the sheet and selecting this option from the drop-down list.

Keep in mind that uses with Admin or Owner permissions on the sheet will still be able to make edits. See: Lock or Unlock Columns and Rows

Additionally, if you set a formula as a Column Formula this will also "lock" the column so only users with Admin permissions could make adjustments, see: Set Formulas for All Rows with Column Formulas

If you have more questions, it would be helpful to see a screen capture of your current set-up (but please block out sensitive data), and a copy/paste of the formula you're using.

Cheers,

Genevieve

Vinton Douglas

Thank you both. This has been very helpful. Sharing as editor will definitely work for me.