I have an EnumList field which pulls a list from a filtered virtual column.
When choosing several options, it gives me an “This entry is invalid” error
I’ve spent hours troubleshooting.
Please help!
Solved! Go to Solution.
Remove the LIST() wrapping the SELECT().
I have the settings as you show, however the error persists.
Any ideas?
What is the column’s Valid If expression?
The Valid if expression is [actividad2], which refers to a virtual column which has the following formula:
list(select(actividades por pieza[actividad],([pieza]=[_THISROW].[codigo pieza]),true))
Remove the LIST() wrapping the SELECT().
Did that. Still gives me error.
This one is a doozy
I checked on the field details and it had reverted back to base type=text, changed it back to Enumlist and it works now!
Thank you for your guidance and patience!
Might you help me?
I have the same problem, the code I have is the following:
Select (Inventory [Normalized],
OR (ISBLANK ([_THISROW]. [Responsible]), [Responsible] = [_THISROW]. [Responsible])
)
I am making use of two virtual columns linked together, as a filter.
The “responsible” leaves me the “Normalized” elements that I want to select, but if I select more than 1, it marks the error, I want to have more than one “Normalized” to add.
Thanks a lot!
What problem? I’m not going to go back and reread the entire thread to figure it out.
What error? Please post a screenshot.
Typically, choosing more than one requires the use of an EnumList-type column.
User | Count |
---|---|
42 | |
25 | |
24 | |
19 | |
15 |