Converted from Column Formula to Cell Formula, but cant edit in Dynamic View

NickO

I have a few fields which are in a dynamic view and are not editable.

These fields are NOT set to read-only in the dynamic view.

In the Source Sheet, they are editable, just not the dynamic view. These fields are not currently a formula field. They previously were a column formula and I converted them to Cell Formula so that they could be edited in the source sheet (which works perfectly fine). We just can't edit them in the dynamic view. When I hover over the fields in the source sheet, it shows me the original formula that the field was created with.

How do I ensure that this field is just a text field and not a formula so that it can be edited in the dynamic view

Paul Newcome

You would have to remove the formula completely.

NickO

I figured it out about 15 minutes after I posted this. When I converted it back to cell formula, I still had to copy and paste values for the columns. Once I did that, it fixed the problem.