Forum Discussion
Carl_Williams
Dec 18, 2021Iron Contributor
List Validation
Hello. I'm very confused about list validation.
Every input whether correct or incorrect fails.
I'm attempting to set it so:
- If the [Contact Type] field is not "Band" and the [Band Type] field is populated, throw the error OR,
- If the [Contact Type] field is "Band" and the [Band Type] field is left empty, throw the error.
As you can see in the attached images, even updating information to correct values throws the error. Perhasps I'm expecting too much from this validation?
EDIT: I've updated my validation to: =IF([Contact Type]="Band",IF([Band Type]<>"",TRUE,FALSE),TRUE)
However it's allowing me to add "Band Type" choices regardless of "Contact Type" required to be "Band".
EDIT2: This works:
=IF([Contact Type]="Band",IF([Band Type]<>"",TRUE,FALSE),FALSE)
Thanks!!
No RepliesBe the first to reply