Hi everyone, I have two columns. One is Department, the other is Analyst.
I have created an if statement under the analyst column saying - =IF([Lead Department]2 = "Education", "Analyst Name". The formula is a lot longer because I added 13 departments in total, but it works.
That said, in some cases we need to select multiple departments under the department column. Ex - Central Services and Municipal Relations. It would appear as follows:
Is there a formula I can create that can identify which department/s are selected an than list the correct names under the Analyst column?
Help Article Resources
Check out the Formula Handbook template!