I am trying to include an "if this than that" automated column in a form I created in appsheets.
I have a list of different sites that can be selected. I want to be able to add an automated column/question that detects that if a specific site is selected in the form, than the region that site is associated with will automatically populate in the "region" question. I have a list of about ~20 sites; they are associated with 3 different regions (Site X, Site Y, Site Z, etc. are in the Coast Region ; Site A, Site B, Site C are in the Inland Region; etc).
What expression can I use for this? I currently have the site question as an enumlist, and multiple sites can be selected; typically only one site will be selected, although when multiple are selected, I foresee the max sites being selected being about ~3. They should fall in the same region, but perhaps there could be an anomaly.
Thanks for any help!
LinkedIn
Twitter
