If you need to allow users to override formula-driven columns in SecureSheet, you  must set the property that allows them to override formulas. This is set per SecureSheet.

A formula-driven column must be unlocked in a view and this property must be turned on in order for the user to be allowed to enter data in a formula-drive column.

Allow Users to Override Formulas

1. Select Properties from the Admin Tasks drop-down.

2. Click the Allow User to Override Formula checkbox.

3. Click Apply.
4. Click<< Go Back. Users will be allowed to override formulas in unlocked columns in the view(s) they have permission to access.