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
Solved! Go to 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?
This is what shows on my HR View
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
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?
User | Count |
---|---|
40 | |
36 | |
34 | |
23 | |
17 |