Change the column name the FILTER shows

[rreimche]

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?

[Marc_Dillon · Accepted solution]

help.appsheet.com

SELECT()

Gather column values from row in table or slice