"Anyof" or "Contains" Construct in "IF" Conditionals? | Community
Skip to main content
KevinQu1
Level 10
Sep 16, 2021 12:22 PM UTC
Solved

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

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"

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Doug_Den_Hoed__AtAppStore
Doug_Den_Hoed__AtAppStoreAccepted solution
New Participant
Sep 16, 2021 1:39 PM UTC

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 reply

2 replies

KevinQu1Author
Level 10
Sep 16, 2021 1:52 PM UTC

Perfect, just what I was hoping for!

Translate
Doug_Den_Hoed__AtAppStore
Doug_Den_Hoed__AtAppStoreAccepted solution
New Participant
Sep 16, 2021 1:39 PM UTC

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

Translate
Terms & ConditionsAccessibility statement

Loading footer...