Help with Switch () Enumlist

I have ColumnA as an ENUMLIST column type with REF Base Type with four different option (values). I have ColumnB that returns the values not picked from the ENUMLIST. Them I have ColumnC with the Switch() function. Let’s say one of the values returned in ColumnB is “Upgrade” (not picked from ColumnA), I want ColumnC to switch it to “Needs Upgrade” , which is it does as long as ColumnB returns only one of the options from CoumnA. If ColumnB returns more than option (not picked from ColumnA) then the Switch () Function doesn’t work. Is there a workaround or what am I doing wrong??

Thank you.
image
image

Perhaps something like this:

(
  LIST(
    IFS(IN("Upgrade", [ColumnB]), "Needs Upgrade"),
    IFS(IN("Leaks", [ColumnB]), "Needs Repair"),
    ...
  )
  - LIST("")
)
1 Like

Hey Steve I tried you suggestion but no luck.

Is ColumnB not an EnumList? How is ColumnB given its value? Could you share a screenshot of the expression used?

1 Like

Thank you for the screenshots!

Try changing the 17a. Needs Attention (Handwashing Station) column type from Text to EnumList.

image

2 Likes

You’re awesome Steve! Thank you.

image

3 Likes