Solution for copying a Contact List column to another Contact List Column

sophiaashepard

Hello,

I am trying to figure out a way to copy a contact from one column over to another column (both columns are Contact List) in the same sheet whenever someone selects "Yes" for a seperate column asking if the Reporter is the same as the Risk Response Owner. If someone selects yes, I would like for the person identified in the "Reported By" column to be copied over to the "Risk Response Owner" column.

Paul Newcome

Are you trying to keep the [Risk Response Owner] column as manual entry as needed, or do you want it to be left blank if "Yes" is not selected?

sophiaashepard

@Paul Newcome I have the Risk Response Owner as manual entry if the answer is no to the question of whether the risk response owner is the same as the reporter. Used logic within a form.

Paul Newcome

In that case you will need an extra column. One would be [Risk Response Owner (manual entry)] and the other would be [Risk Response Owner (automatic)].

The manual entry would be just that, and the automatic would house the formula.

=IF([Manual Entry Column]@row <> "", [Manual Entry Column]@row, [Reported By]@row)

sophiaashepard

@Paul Newcome Thanks! Is there a way to combine those two columns into one column so I end with having only one column visible to users for [Risk Response Owner]?

Paul Newcome

Unfortunately not. You cannot have both free text and formula in a cell at the same time. But if people are entering the information via form, you do not need to include the automatic column in the form.