Validation logic help for multiselect fields | Community
Skip to main content
JohnJOSullivan
New Participant
October 16, 2025
Question

Validation logic help for multiselect fields

  • October 16, 2025
  • 1 reply
  • 551 views

Hi friends,

So, I have something which is driving me kinda crazy. I'm trying to write a validation logic rule where if a particular multiselect field is selected along with any other field that the validation error kicks in.

Here's the formula:IF(ARRAYLENGTH({DE:fieldName})>1&&CONTAINS({DE:fieldName},"option"),"Option must be the only contract selected. Adjust this and resubmit.")

Now, this is a valid expression. However, it isn't validating. I've been trying to cheat with Copilot and Grok and neither are giving me something which works.

This is killing me because there's gotta be something simple that I'm clearly not seeing. 

Help?

 

-j

1 reply

skyehansen
New Participant
October 16, 2025

sorry, I'm not clear. Are you saying it's a valid expression because it didn't error, or are you saying "I tested it out as a calculated field, and it gave me the results I'm looking for"?

JohnJOSullivan
New Participant
October 16, 2025

Sorry. What I'm saying is that Workfront is allowing me to save the expression. The syntax is correct but it's just not validating when I attempt to make it validate on a sample document. 

 

 

skyehansen
New Participant
October 16, 2025

Sorry, I should have said "what result do you get if you make a test calculated field with this same expression?"