Formulas in Contact Columns

I have 3 columns on a sheet that holds new submissions via form. Based on the job# submitted, i pull in the assigned Dispatcher, Rep and Tech. I use these for alerts. However, only the Dispatcher column is showing correctly. The other two just pull in the name. See attached "Overview".

I am using Index Match formulas in a ll 3 column and they are setup as contact columns.

Any help as to why only 1 of the columns works correctly, but the other two do not is greatly appreciated.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!