Formulas in Contact Columns

Kyle Lewis

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".

Overview.PNG

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

Rep Column.PNG

Dispatcher Column.PNG

Dispatcher Formula.PNG

Rep Formula.PNG

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

Paul Newcome

Are all columns set as contact type columns?

Kyle Lewis

Yes sir on both sheets all columns are set as contact columns.

Paul Newcome

Are any of them set to select multiple contacts?

Kyle Lewis

No. They are set as 1 selection only. None of the columns have the selections to choose from either.

Paul Newcome

Double check that the source data is actually a contact and not just text.

Kyle Lewis

I just remembered that I change the source sheet to multiple contacts on Monday. If i change it back to single everything works.

I'll come up with a work around.

Thanks Paul!

Paul Newcome

Happy to help. 👍️