topic Re: Unlock column with formula in Discussions

Unlock column with formula

RVhydrA — Tue, 01 May 2018 13:48:26 GMT

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.

Re: Unlock column with formula

txnelson — Tue, 01 May 2018 14:12:59 GMT

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

Re: Unlock column with formula

Ryn — Fri, 14 Mar 2025 14:42:52 GMT

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

)