Auto Assign w/in Marketing Request Tracker

edited 12/09/19 in Formulas and Functions

I am trying to figure out how to write a formula to auto assign a task when it meets different criteria. For example, my column is "Type of Request". If it is Creative, then I want to assign Kristi from my contact list. If it is Product, I want to assign John. I have 7 different choices within the Type of Request column and I want to be able to assign directly to the person responsible.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!