Prevent Check Box formula from erasing when check-box is manually checked by accident.

Jonathan Chan

In below scenario, check box formula disappears when the cell is checked manually by accident. Is there a way to prevent check-box-formula from being erased when the check box is manually checked?

• Pls refer to attached picture “Query - Check Box Formula” for check box formula used.

 

Thank you.

 

Jon

Brett Evans

You could lock the column so only useres with admin rights could edit it.

Jonathan Chan

Hello Brett:

 

Tks for the tips.

 

Meanwhile, Smartsheet (SS) team responsed that they will add this request to consideration list for future augmentation to SS.

 

Best.

 

Jon