Cant turn Non-Editable Fields to Editable due to cross referencing in Sheets

[Heena_Mirchanda]

I am trying to make an app from a Google Sheet where almost all cell values are cross referenced to another sheet for data. Now I want to edit/add some data in the column (for example name) but I am not able to since all data is cross referenced and hence contains a cell formula, which makes the field non-editable. How to proceed?

[Steve]

It is not possible to make a column editable if the column contains spreadsheet formulas.