"Anyof" or "Contains" Construct in "IF" Conditionals? | Adobe Higher Education

Level 10

해결됨

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

Forum|Forum|4 years ago
September 16, 2021
2 답변들
651 조회

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

이 주제는 답변이 닫혔습니다.

최고의 답변: 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

답변

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

KevinQu1작성자

Level 10

Perfect, just what I was hoping for!