Have a table dropdown_lists ; with a bunch of different drop down lists columns inside it.
Have a Column H which basically converts a nested list dropdown list into a single word.
dowpdown_lists Column B value cells make up a "dropdown list app user selects in form, from ref_dropdown in main table.
Wish to pull the matching row value out of Column H and.....
how to add the H cell value from same row from dropdown selected into another user form field automatically???
_____________________________________________________________
I'm sure the answer is out there, however have spent days looking and confusion because so many different types of drop downs and many ways to do it. So many different examples in different orders and combinations. Looked at the continent country example but this doesn't really have to do with pulling a single value from another column. Looked at the State City School example but this is narrowing down to multiple value results.
Just want to pull a single value from a row based on a selected ref dropdown in the same table, same row.
To my understanding Ref is the best way to do a drop down and the most likely way it will transfer if moved to a database format in the future from a sheet?
At first we tried this with Formulas in the sheet but that info does not transfer into appsheet.
Really grateful if someone can help answer; did try to figure out on own, but the more I look the more confused I get.
Have rearranged ref parent child as this is confusing.
Have tried using valid_if , select, any select thisrow.
The drop down in the form works, but not yet just the single value automatically.
An example would be
COLUMN B: Company_Department_Section_SubSection_Result
COLUMN H: And pulling our just the _Result which has already been put as Result in a matching row in the same table; but instead of using the word _result wish to another word which has already been defined in the H column.
LinkedIn
Twitter
