Unlock column with formula

[#1]

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.

[#2 · Accepted solution]

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

[#3]

Hi, I had the same question and came to this thread. I ended up solving it a different way: I wanted the formula in the formula column to continue updating so I made a new column called modifier column. I added in a new if function to the original formula column that says if the modifier column == "" then continue with the original formula. If it is not blank, display the value in the modifier column. The original formula looked something like this:

If( :Formula Modifier == "",

//original formula

:Formula Modifier

)