Expand my Community achievements bar.

SOLVED

"Anyof" or "Contains" Construct in "IF" Conditionals?

Avatar

Level 10

I know the tedious, endless, nested-if solution to this, but wondered if there is an easier way.

Does WF have a construct/conditional for calculated fiends that would do this:

IF fieldName is ANYOF (A, B, C) then output "Cat"

ELSEIF fieldName is ANYOF (X, Y, Z) then output "Ferret"

ELSEIF fieldName is ANYOF (P, Q, R) then output "Pygmie Bunny"

1 Accepted Solution

Avatar

Correct answer by
Level 10

Hi Kevin,

Sounds like a good fit for IFIN:

IFIN(fieldName,A, B, C,”Cat”,

IFIN(fieldName,X, Y, Z,"Ferret",

IFIN(fieldName,P, Q, R,"Pygmie Bunny",

“Red Herring”)))

Regards,

Doug

View solution in original post

2 Replies

Avatar

Correct answer by
Level 10

Hi Kevin,

Sounds like a good fit for IFIN:

IFIN(fieldName,A, B, C,”Cat”,

IFIN(fieldName,X, Y, Z,"Ferret",

IFIN(fieldName,P, Q, R,"Pygmie Bunny",

“Red Herring”)))

Regards,

Doug

Avatar

Level 10

Perfect, just what I was hoping for!