Smartsheet Community

Find peer-to-peer information about everything Smartsheet related – from project management best practices to invaluable how-to guidance from fellow users and Smartsheet experts.

linking two columns togther

oakhayat

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

Find more posts tagged with

Formulas

Services

Conditional Formatting

Project Management

Cell linking

Comments

Shaine Greenwood

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

Quick Links

Trending discussions

Using SUMIFS with Cross Sheet References and CONTAINS
There seems to be lots of information on how to use SUMIFS with a CONTAINS criteria, referring to another sheet. Here is my formula on Sheet 1: =SUMIFS({Total Cost - Final Event Space Cost}, {Requested Event Date}, {Requested Event Date} > TODAY(), {Requested Event Date}, {Requested Event Date} >= TODAY(-365)) Total Cost -…
Target Start Date setup as a queue
I am looking to incorporate a dynamic target start date into a sheet. Essentially as a task completes it needs to reference an assignee, project ID, and the end date of a task to assign the next target start for the next task. I keep confusing AI when I try to generate this. Anyone have any experience with this or am I…
Index / Match
Looking for some guidance. Goal: If "KPI Availability %" @ row is equal to or greater than "Annual Score % Availability" row 10 then it will look at the "Previous Contract Year Event" @ row and match it with the column header 0 , 2,3,4,5,6,7,8 (individual columns). Then it will look down the matched column where it matched…