Hello! I was wondering if anyone could help get me started on carrying out what I think will be a very long IF/AND statement. See attachments - I've created a formula to read the department column and the output will be the employee that has been entered into the top grey section in the Assigned To column. My issue is that some cells in our Department column will contain more than one department for instance, IT and Business Development), therefore I will need the output to produce more than one employee in the Assigned To column. I started adding additional IF statements to the formula but kept getting Unparsable. Can someone help me get started in the right direction? Thanks!
Help Article Resources
Check out the Formula Handbook template!