2 selections with 1 result

michael_parker · 10-11-2021 07:41 AM

If I have three columns in Google Sheets, and I am wanting to select 1 item from A and B columns and have the third column, C, display my result, how would I do this? I am currently using Enum for A and B Column, and text or show for C column.

Example:
Google Sheet

Select one from A and one from B and get C as the result?

  A                    B                        C

Aluminum. Lithium Compatible
Lithium. Calcium Not Compatible

WillowMobileSys

I assume you mean you are trying to combine the text from Column A and Column B to them together as a single value?

You would use the CONCATENATE() function like so:

CONCATENATE([Column A], ". ", [Column B])

There is also a shorthand approach like this:

[Column A] & ". " & [Column B]

Steve

The third column would have an App formula expression that produces the appropriate result value from the values of the first and second column. I can imagine an expression like this:

SWITCH(
  ([column1] & ":" & [column2]),
  "Aluminum:Lithium", "Compatible",
  "Lithium:Calcium", "Not Compatible",
  ...,
  "Unknown"
)

See also:

michael_parker

So, I actually have them manually typed out, for all of the possible results.

I want to select and option from each drop down, and generate an answer (Compatible or Not Compatible).
On the back in, on Google Sheets, I have the results listed.

Steve

Useful to know.

ANY(
  SELECT(
    table[Compatibility],
    AND(
      ([Thickner Type 1] = [_THISROW].[Thickner Type 1]),
      ([Thickner Type 2] = [_THISROW].[Thickner Type 2])
    )
  )
)

michael_parker

Thank you! Where do I need to enter this?

And do I need to change the TYPES?

michael_parker

I actually figured it out! Thank you for the help!