Unlock column with formulaHow 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.
Re: Unlock column with formulaThe 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
Re: Unlock column with formulaHi, 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
)
