I was previously using an enum dropdown list within appsheet. The flaw with this is I use the same list multiple times and changes take a lot of time.
I wanted to switch to the Valid If technique as it will allow me to make one spreadsheet change that affect heaps of lists.
The issue I am having is illustrated below with two screen recordings:
One column with valid if:
Two columns with valid if:
As you can see It looks like having two valid if columns in one table causes some sort of issue.
I have no clue what is going on, any ideas would be much appreciated.