I am working on an app where I am able to collect the names of people and register them in the database. See I don’t want to repeatedly incode the same name so I want to tell appsheet to look for the values of the cell and use it as enum values on a dropdown. but this form will be recording on another sheet. I have sheet A as masterlist of name to get the values and I have sheet B which will be the record of the app.
Have you tried using Valid if?