Level 1
Level 2
Sign in to Community
Learn more
Sign in to view all badges
Expand my Community achievements bar.
This conversation has been locked due to inactivity. Please create a new post.
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.
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
Perfect, just what I was hoping for!
Views
Likes
Replies