Column is being marked 'Read Only'

[m247]

I’m having problems with making my drop down list for my “Status” Column in my Leave Filing app. It works fine for my HR view but my Department view is only showing the “Pending” option and not the other two.

Both my HR and Department Head have the same formula but only shows “column is being marked ‘Read Only’” for my Department Head View

[m247]

This is what shows on my HR View

[Steve]

[m247]

That’s the thing though. Both of them have sheet formulas but why does the on for the HR Department work. I check the column type and data validity of both and they are the same

[Marc_Dillon · Accepted solution]

IIRC, adding a sheet formula after you load a table (or regenerate) means that Appsheet won’t know it exists. This could explain why the one column is still editable. And really, that’s the issue. Columns with either a Sheet Formula or App Formula are not editable. If a column should be editable, it should not have any formula. What exactly are you trying to accomplish here?