


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"
Solved! Go to Solution.
Views
Replies
Sign in to like this content
Total Likes
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
Views
Replies
Sign in to like this content
Total Likes
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
Views
Replies
Sign in to like this content
Total Likes
Perfect, just what I was hoping for!
Views
Replies
Sign in to like this content
Total Likes