Solved: Restrict choice if NONE selected - Page 2

Jethro · 11-26-2019 07:53 AM

Hi all,

I have an enumlist allowing multiple colour choices with the following options:

If you select 1 or more colours it is fine however:

Is there a way to restrict or show a valid_if error when:

None + any other option is chosen? eg. None, Purple

I want to make sure that when the user chooses NONE, they dont accidentally match with a colour.

thanks in advance

LeventK

IF(
	COUNT(SPLIT([_THIS],",")) > 1,
	NOT(
		IN(
			"None",
			[_THIS]
		)
	),
	TRUE
)