Help with Automatically Assigning Contacts to Tasks
I'm attempting to use the below index/match formula to automatically assign contacts based on 1 - 2 criteria. However, I keep getting #UNPARSEABLE error. The [Assigned To] Column is setup as a contacts column, and I have the contacts listed (First Name, Last Name, Email) in the Values table. The below formula is to only look at the [Assigned Back Offer Team] column, but I'll also need something that looks at both [Assigned Back Offer Team] and [Region].
=IF([Assigned Back Office Team]@row = "Care", INDEX(Contacts:Contacts, MATCH("Taylor Riley", Contact:Contacts, 0)))
Help Article Resources
Check out the Formula Handbook template!