Solved: Select Values that are in the same row but differe... - Page 2

Jpaulsen · 10-14-2022 04:53 AM

Morning,

Was wondering if someone could help me out here. I'm trying to wrap my head around a formula I am trying to get to work but seem to have some problems. I got two drop down list at the top of my form. Once the first on is select, the second one appears with a select values based on the first drop down. Now what I am trying to do is, once both drop downs are complete, I want to gather a list of values from another column that are associated to the second dropdown because it's in the same roll.

I have tried using _thisrow but seems to not work. I have to let appsheet sheet know that _thisrow = "value" I'm trying to IFS, SELECT AND NOT(ISBLANK( and(

First Drop Down [Type of Filter], Second Drop Down [Part Number]

IFS(SELECT(Equipment[Unit],NOT(ISBLANK([part number], and(

[Type of Filter] = "Engine oil Filter",
UNIQUE(Eqipment[Engine oil filter]),

[Type of Filter] = "Fuel Filter",
UNIQUE(Eqipment[Fuel Filter]),

[Type of Filter] = "Water Separator Filter",
UNIQUE(Equipmet[Water Separator Filter])

)))))

Thank you in advance,

Jason

Aurelien

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]
    )
  )
)

Hi @Jpaulsen

I forgot one square bracket.

Here is the correct expression.

I suggest you install the Chrome's extension "AppSheet Toolbox". It's immensely useful.

EDIT: the SWITCH part is not exactly correct, as the "default-case" part is missing. I added the correct solution in a post later.

View solution in original post

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