- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Unlock column with formula
How do I unlock a column that contains a formula? I have a binary column which is computed based on a formula. I have allowed the formula to evaluate, then suppresed the formulas evaluation and would like to edit some of the rows to change form 0 to 1 or vice versa (essentially there is no good way for me to get my formula to give me the perfect result 100% of the time due to variablity in my data so i'd like to edit a few) however the column is locked and greyed out so I cannot change any of the rows.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Unlock column with formula
The only way to do this is to
col << delete formula;
which will remove the formula, but will leave the calculated values. Then you can edit the cells.
You can also do the same thing interactively in the Col Info window, by removing the formula in the Column Properties
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Unlock column with formula
The only way to do this is to
col << delete formula;
which will remove the formula, but will leave the calculated values. Then you can edit the cells.
You can also do the same thing interactively in the Col Info window, by removing the formula in the Column Properties