linking two columns togther
Hello Everyone,
I have two columns, one has the name of the customer "name" and the other column has the number we assigned to the customer "number". I am trying to link these two for example, let us say if I type 111 in the number column the name joe will appear in the name column, and the other way around. If I write joe in the name column the assigned number 111 will show in the number column.
Thanks,
Omar
Comments
-
Hi Omar,
There currently isn't a way to link columns together such that you can type their name in one column and have the number appear OR type the number to have their name appear.
You can, however, create a LOOKUP function in your sheet that will automatically type the number in if you type their name in.
Note that you can only have the number fill in if you type their name (not the other way around), as formulas can't be placed in contact columns.
Details on the LOOKUP function are available in our help center: https://help.smartsheet.com/function/lookup
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!