Expression to select the values from an enumlist called [Kids].

[EmadK]

How do I select the different values that are separated by commas by default in an enumlist called [Kids].

An expression with LEFT only selects the left-most and right-most values.

LEFT([Kids], FIND(",", [Kids]&",") - 1)

Thanks!

[SkrOYC]

I don't know what you mean.
Maybe INDEX() is your thing.

Read the whole docs for reference, that's the best way to understand "how do I ..."

INDEX() - AppSheet Help

[EmadK]

My column (type is enumlist) has these values stored:

I am trying to retrieve the first (or the second value) using an expression.

Can the INDEX function retrieve values stored in an enumlist?

Thank you

[SkrOYC]

---

@EmadK wrote:

Can the INDEX function retrieve values stored in an enumlist?

---

[EmadK]

The new column value '=ANY(LIST(INDEX([Kids], 2)))' of data action 'Add Second Kid' does not match the type of the column

This expression works but te column type for the Customer ID is a ref.

How do I fix this? 🙂
Thanks