Split in Valid_If not allowing me to select and save

[Juan_Camilo_Sie]

Hey guys !

I have A simple formula for selecting multiples values which contains Lists in it and I split those result to create a dropdown.

Formula:

SPLIT(
SELECT(
Pieza[Ubicación],
[ID Pinta]=[_THISROW].[OP].[Pintas]
),
","
)

It works!, But When The user select the value, appsheet is not saving it

Selected Value

Result After Click "Done"

Thank you in advance

[TeeSee1]

maybe the function SPLIT is returning some weird values.

Why do you need to use SPLIT? SELECT returns a list and that should work as an input to a dropdown?

I would try it without the SPLIT.

[Juan_Camilo_Sie]

I need to use split because the values that I'm calling are type EnumList, So, it is being save as "Value1, Value2, Value3" So I use Split with the "," To "Split" those values

[TeeSee1]

I tested with the condition you mentioned and it works without any issues..

What is the data type of [Tipo Pieza], text, ref to something?

[Marc_Dillon · Accepted solution]

Change your SPLIT() to SPLIT(TEXT()), then changed the delimiter to " , " (space-comma-space).

[Juan_Camilo_Sie]

Perfect !

IT Worked !! Thank you