Select Values that are in the same row but different column after dropdown value is selected.

AppSheet AppSheet Q&A
, , , ,
8

Hi @Jpaulsen

I’m glad to help, and glad you found it by yourself eventually. Sorry for answering that late, I was out of office for the weekend.

Just in case someone else reads this thread: here is the final correct expression.

I previously forgot the default case.

Aurelien_0-1665979735414.png
Aurelien_0-1665979735414.png709×474 35 KB

IFS(
  AND(
    ISNOTBLANK([Type of Filter]),
    ISNOTBLANK([Part Number])
  ),

  SWITCH([Type of Filter],

    "Engine oil Filter",
    FILTER("Equipment",
      [_THISROW].[Part Number]=[Engine oil filter]
    ),
  
    "Fuel Filter",
      FILTER("Equipment",
      [_THISROW].[Part Number]=[Fuel Filter]
    ),

   "Water Separator Filter",
    FILTER("Equipment",
     [_THISROW].[Part Number]=[Water Separator Filter]
    ),

    FILTER("Equipment",
     [_THISROW].[Part Number]=[columForDefaultResult]
    )
  )
)