Can a Contact column populate based on selection in another cell?
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...
Answers
-
Do you have a reference table built that has every workstream going down one column and the respective leader going down another column?
-
I do not. I've had challenges doing this sort of thing with a contact cell; vlookups and indexing etc..
-
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")))))
-
That worked Paul, much appreciated.
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- 10.6K Get Help
- 63 Global Discussions
- 68 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 465 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
Check out the Formula Handbook template!