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

Level 10

Solved

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

Forum|Forum|4 years ago
September 16, 2021
2 replies
651 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

Doug_Den_Hoed_AtAppStore

Community Advisor

Accepted solution

Community Advisor

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

Level 10

Perfect, just what I was hoping for!