SpreadSheet Formula Column Bug

Hello!

As you can see in the image, there is a message indicating that: “Column Type ‘Text’ has a ‘Sheet Formula’ so the column is being marked ‘Read Only’”.

However, in no place in my spreadsheet have I used a formula. Furthermore, there is no formula anywhere inside the column in the App Sheet Editor. I tried copying and pasting as values all contents in the entire spreadsheet, tried reestructurating de columns of the table in App Sheet Editor and problem still persists.

Anyone knows how to solve the issue?

make sure you remove anything from here as well

3 Likes

This fixed the problem! Thank you so much! :slight_smile:
Did not know App Sheet stored the formula in its own method. This was really helpfull.

2 Likes