Can a Contact column populate based on selection in another cell?

Chris Topher

I have two columns; Workstream and Workstream Leader. Their column types are Dropdown (Single Select), and Contact List respectively and each contains five available selections and are set to Restrict to list values only. I want the Workstream Leader column to populate with the contact that I know to be responsible for that Workstream.

How can this be accomplished? I was attempting this via use of an IF function, but that has not yielded positive results...

Paul Newcome

Do you have a reference table built that has every workstream going down one column and the respective leader going down another column?

Chris Topher

I do not. I've had challenges doing this sort of thing with a contact cell; vlookups and indexing etc..

Paul Newcome

Ok. Since you only have 5 then we could make it work with a nested IF. It would look something like this...

=IF(Workstream@row = "A", "PersonA@email.com", IF(Workstream@row = "B", "PersonB@email.com", IF(Workstream@row = "C", "PersonC@email.com", IF(Workstream@row = "D", "PersonD@email.com", "PersonE@email.com")))))

Chris Topher

That worked Paul, much appreciated.

Paul Newcome

Happy to help. 👍️