AnsweredAssumed Answered

if statement in validate field

Question asked by soco1509 on Mar 26, 2018
Latest reply on Mar 26, 2018 by soco1509

Hi,

help would be greatly appreciated, thankyou in advance

 

i wish to have F1 be validated by a combination of what is in first word of F2 and F3 as a combination.

so F1 can only contain a specific value if combination of F2 F3 is true, if not F1 can contain any value

 

this is what i am trying to use

 

If (

LeftWords(F2;1 )="zzz" and LeftWords(F3,1 )="yyy";

F1 = "xxx",

F1

)

Regards

 

Stephen

Outcomes