I have a formula that extracts values from a Spreadsheet “Warengruppen”:
FILTER("Warengruppen", IN([Modell], [_THISROW].[DescrParts]))
“DescrParts” is on of the virtual columns. AppSheet interpreted this as following:
The list of values of column ‘Name’
…from rows of table ‘Warengruppen’
…where this condition is true: ((The value of column ‘Modell’) is one of the values in the list (The value of ‘DescrParts’ from the row referenced by ‘_RowNumber’))
I need to have column “Hersteller” instead of “Name”. How can I do this?