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

New Participant

Solved

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

Forum|Forum|4 years ago
September 16, 2021
2 replies
650 views

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"

Workfront

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by Doug_Den_Hoed__AtAppStore

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

New Participant

Perfect, just what I was hoping for!

Doug_Den_Hoed__AtAppStoreAccepted solution

New Participant

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