Expand my Community achievements bar.

Wondering how Workfront Proof works? Join our AMA on May 8th and ask our Community experts!

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

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
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

View solution in original post

2 Replies

Avatar

Correct answer by
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

Avatar

Level 10

Perfect, just what I was hoping for!