How to automatically copy a cell value to the next column

SIS

Hi =),

It is likely a very easy solution for you guys. I've two columns one for the client names (Dropdown list) and another one for OTHER ( if they can't find the client name from the dropdown). I wanted to bring the OTHER client name automatically to the client name once someone enters data in the OTHER column.

Goal is to use the client column to run analytics.

Any help will be appreciated

Thanks =)

Please see attached

Copy cell value to the left cell.PNG

Uploaded Jan 5, 202217.2 KB

Christina09

Hi @SIS

Devin formula will work, just the logic is switched. The logic should be if "other client name" is entered, show the "other client name", if not show the "client"

=IF([OTHER CLIENT NAME]@row <> "", [OTHER CLIENT NAME]@row, [Client]@row)

Devin Lee

You will need to have a third column that uses logic to pull from the other two columns.

=IF(Client@row <> "", Client@row, IF([OTHER Client Name]@row <> "", [OTHER Client Name]@row, ""))

SIS

Client list.PNG

Uploaded Jan 5, 202212.37 KB

Form input for client.PNG

Uploaded Jan 5, 20223.77 KB

Hi Devin,

Thanks for your input. It does bring the Client names into the new column but the Other client name is not being carried over. I used a dropdown in the form that I'm capturing the data from where it says OTHER. Added a logic where if anyone selects other, OTHER CLIENT NAME textbox pops out and they can type in the name. Any input?

Christina09

Hi @SIS

Devin formula will work, just the logic is switched. The logic should be if "other client name" is entered, show the "other client name", if not show the "client"

=IF([OTHER CLIENT NAME]@row <> "", [OTHER CLIENT NAME]@row, [Client]@row)

SIS

Worked like a charm. Thanks so much.