Hello! I am a newbie learner of Alteryx. I am currently creating a workflow that will identify the replacement of members. Here's the hierarchy of replacement.
1. Manager
2. CRM
3. FS
So, if the associate for replacement is the Manager (John), my workflow should show CRM. If John is also the CRM, it should select FS instead. Here's the sample to make it clear.
I've tried creating IF formulas but I am unable to produce my desired output. Appreciate your help, All! Thanks, thanks!![sample.png sample.png](https://community.alteryx.com/t5/image/serverpage/image-id/339310i56E42190DE43C3AA/image-size/large?v=v2&px=999)