Check Value on EnumList

[AI-FL]

This seems trivial but is stumping me. I just need to check the value of a column that is an EnumList.

[Parts Status] = “Parts Needed”

If column value matches the string or text of specified value in the list, do something.
I’m getting error
Cannot compare List with Text in ([Parts Status] = “Parts Needed”)
Also tried and failed with:
([Parts Status].Value = “Parts Needed”)

[Suvrutt_Gurjar]

If [Parts Status] is Enumlist type column, please try the expression

IN(“Parts Needed”, [Parts Status])

help.appsheet.com

IN()

Is item in list?

[AI-FL]

Suvrutt_Gurjar:

IN(“Parts Needed”, [Parts Status])

This is just checking if the entered value is in the list, correct? I am not allowing other values to be entered so they will all be in the list. But how do I check to see which list value was input by the user?

[Suvrutt_Gurjar]

I am sorry, I could not exactly understand the requirement. Could you elaborate?

[AI-FL]

I have an EnumList column [Parts Status] with only 3 possible values for the users to choose.
I would like to format based on which value the user chose.

If they chose “Parts Needed”, then do this formatting.
If they chose “Parts Ordered”, then do this formatting.
If they chose “Parts Received”, then do this formatting.

Something like, IF[Parts Status].Value = “Parts Needed” then do this.

[Suvrutt_Gurjar · Accepted solution]

Thank you. Does the user choose only one values at a time? In that case do you wish to consider Enum instead of Enumlist?

Asking this query because with enumlist, a user can select more than one value, so expression may need to consider if the user chooses two or three possible values simultaneously?

[AI-FL]

That was it. Feel a bit silly now. Thank you for your help.

[RAISTLIN]

Sir.. What if the user is able to chose two or three possible values simultaneously? How do we solve it?

[polohi]

Sth like this will do

First you get the INTERSECT of what user are choosing and the LIST which are valid input(**I put this LIST in suggest value)
COUNT how many time the appearance of the INTERSECT and compare with actually count of user input
if intersect count equal to actual value count, which mean all the value are intersect so user does not add value him self

COUNT(
  INTERSECT([_THISROW].[COLUMN], LIST)
) = COUNT([_THISROW].[COLUMN])