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?
It is not possible to make a column editable if the column contains spreadsheet formulas.
User | Count |
---|---|
32 | |
31 | |
30 | |
19 | |
16 |