Incorrect data show in my dropdowns

[Ash_Zim]

Hi All

I am at a loss, so I have created a google sheet and with drop down menus (data validation) and it works great on the google sheet, but when I take it into AppSheet it seems to loose / move the data. ie 

In the google sheet when I select one of the drop down menus under the product header I get all the products based on the client i have selected (which is exactly what we need) when I go to the AppSheet and select products it brings back the headers of the sheet 

Any ideas or am I asking to much from App Sheets 

[WillowMobileSys]

You need to check the configuration of the Product column in your "Thankful Brands" table.  There must be an incorrect expression either in the "Valid If" property or in the "Suggested Values" property.  OR the column is configured as a REF type in appropriately.

I think what you want is a config like this:

[Ash_Zim]

Thank you for your help

I had a look in the products column and it is pulling the header of my sheet 👇

 I then deleted the headers and made the changes you suggested - the only thing I couldn't do is leave the base type blank because it would not let me. 

I then started from scratch, new sheet add the drop down (data validation) then this time when I created the app it came back with many error and the app did not recognise the drop down instead called them color? 👇

New Sheet with. drop downs

The data the drop downs are pulling from

The Error on app sheet

When I change it to enum i get this 👇

Still no dropdown info