Filling a Contact List from another sheet

Jake C

Hello everyone,

I have a sheet that has a list of all of the managers and supervisors in my organization and I keep it updated monthly. I have another sheet that has a Contact List field and I am trying to see if there is a way to connect the Contact List field to the Sup/Mgr sheet, so that it automatically updates when I update the Sup/Mgr sheet. Or if there is a more elegant/workable solution, are there any suggestions?

Thanks!

Frank S.

Greetings Jake,

In my opinion, the easiest way to do this would be using something like the following formula:

=IF(ISBLANK([Sup/Mgr cell with name]@row), "", INDEX(COLLECT({Contact list }, {Name}, CONTAINS([Sup/Mgr cell with name]@row, @cell)), 1))

Contact List = the sheet and column from your contact sheet you want to display if the condition is made.

Name = the value you are comparing your Sup/Mgr sheet to on your contact list.

The ISBLANK component ensures that if the space is blank, nothing happens.

I hope this helps.

Frank S.

Greetings Jake,

In my opinion, the easiest way to do this would be using something like the following formula:

=IF(ISBLANK([Sup/Mgr cell with name]@row), "", INDEX(COLLECT({Contact list }, {Name}, CONTAINS([Sup/Mgr cell with name]@row, @cell)), 1))

Contact List = the sheet and column from your contact sheet you want to display if the condition is made.

Name = the value you are comparing your Sup/Mgr sheet to on your contact list.

The ISBLANK component ensures that if the space is blank, nothing happens.

I hope this helps.

Jake C

Hi Frank,

Thank you so much for your reply! This would create a workaround for what I was thinking of, but it would work. My first thought was to see if there was a way to create the entries in the contact list in my main sheet from the sup/mgr sheet, so that I only have to update the sup/mgr sheet and not the contact list in the main sheet. But I could add a column and use this formula to auto-populate the contact list column from the sup or manager name entered into the new column.

It adds a column, but that is ok! Thank you for this, I hadn't thought of building a formula like this.