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
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 494 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!