Can dropdown values chosen in one column be copied to another column?

kowal

Dear Folks,

We have a situation that in a Form there is a field with about 70 dropdown values (column ABCD).

There is also column EFGH that should have all the chosen values from Column ABCD or less.

Just to save time by selecting the same values for Column EFGH is it possible to copy those and remove the one that are needed?

JamesB

@kowal

Will the values in EFGH be exactly the same as ABCD or will their be potentially be additional values in EFGH?

kowal

hi @JamesB there will be no additional in EFGH but can be less than ABCD so that's hiding the EFGH field and using formula =ABCD will not work :(

JamesB

@kowal

Based on your response, the only solution I can think of at the form level is to make a primary and secondary input. Your fields look like they are for selecting resources. So if you make Primary = EFGH, so the person inputting the selection would only place those needed in EFGH, and then put the additional resources in ABCD or Secondary. From there you can create a third column not on the form and use a formula to bring the Primary (EFGH) and Secondary (ABCD) fields together.