copy text from one cell to another in one sheet

Joerg Schmidt

Hi,

solution seems to be simple ;-) I want to show text that I choose from a dropdown field in another cell in the same sheet.

[column one] [column two] [column three]

before choosing [blank] [options 1-5] [options 6-10]

after choosing [ =text no. 7 ] [options 1-5] [chosen option 7]

what kind of fomula do I have to enter in column one in order to show one of the chosen issues

e.g. ="([column one]@row) + ???

Thank you for brainstorming ;-)😎

Andrée Starå

@Jörg Schmidt Novum Hospitality

Happy to help!

Try this.

=JOIN(COLLECT([Anlass Allgemeine Anfrage]:[Anlass Wartung];
[Anlass Allgemeine Anfrage]:[Anlass Wartung];@cell <>""); CHAR(10))

Did that work?

Paul Newcome

Are you able to provide a screenshot with mock data manually entered that shows what you are trying to accomplish?

Joerg Schmidt

Anlass.png

Andrée Starå

Hi @Jörg Schmidt Novum Hospitality

I hope you're well and safe!

I'm not sure I follow.

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Paul Newcome

Try something like this...

=JOIN(COLLECT([Column 1]:[Column 2]; [Column 1]:[Column 2]; @cell <> ""); CHAR(10))

Joerg Schmidt

Hi Paul,

could you check my entry once please. I still get "unparseable" as result ;-)

=JOIN(COLLECT([Anlass Allgemeine Anfrage]:[Anlass Behördenschreiben]:[Anlass Brandschutz];@cell <>); CHAR(10)) 🤔😏

Andrée Starå

Hi @Jörg Schmidt Novum Hospitality

Try something like this.

=JOIN(COLLECT([Anlass Allgemeine Anfrage]:[Anlass Behördenschreiben];
[Anlass Allgemeine Anfrage]:[Anlass Behördenschreiben];@cell <>""); CHAR(10))

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Joerg Schmidt

Hi Andree,

it works with the 2 topics. But why does it not work with 4 topics ?

=JOIN(COLLECT([Anlass Allgemeine Anfrage]:[Anlass Behördenschreiben]:[Anlass Brandschutz]:[Anlass Wartung]; [Anlass Allgemeine Anfrage]:[Anlass Behördenschreiben]:[Anlass Brandschutz]:[Anlass Wartung]; @cell <> ""); CHAR(10))

Thank you

Andrée Starå

@Jörg Schmidt Novum Hospitality

Happy to help!

Try this.

=JOIN(COLLECT([Anlass Allgemeine Anfrage]:[Anlass Wartung];
[Anlass Allgemeine Anfrage]:[Anlass Wartung];@cell <>""); CHAR(10))

Did that work?

Joerg Schmidt

Hi Andree,

thanks for your help.

Currently, I cannot see the difference between you first and second proposal ?

Could you explain it to me ?

kind regards Joerg 😃

Joerg Schmidt

Hi,

happy to have found explanation on myself right now

Now, it works. Phantastic.

Thanks to both of you - Paul and Andree - for helping again.

You are great 😁

Andrée Starå

@Jörg Schmidt Novum Hospitality

Excellent!

You're more than welcome!

To answer your question. The ranges have to match.

=JOIN(COLLECT([Column 1]:[Column 4];
[Column 1]:[Column 4];@cell <>""); CHAR(10))

Make sense?

Joerg Schmidt

Dear Andree, dear all,

unfortunately, I have to reopen this issue. Somehow, it does not work properly, yet. Pls see screenshot.😏

I use:

=JOIN(COLLECT([Anlass Allgemeine Anfrage]:[Anlass Trinkwasserhygiene]; [Anlass Allgemeine Anfrage]:[Anlass Trinkwasserhygiene]; @cell <> ""); CHAR(10))

2021-08-04 Fehlermeldung helper.png

Paul Newcome

Try using "@row" references to only reference the row the formula is on.

=JOIN(COLLECT([Anlass Allgemeine Anfrage]@row:[Anlass Trinkwasserhygiene]@row; [Anlass Allgemeine Anfrage]@row:[Anlass Trinkwasserhygiene]@row; @cell <> ""); CHAR(10))

Also make sure that the wrap text functionality is turned on for the column the formula is on.

Joerg Schmidt

Hi Paul,

nice to hear from you. Hope you are fine ?

What does it mean?

"Also make sure that the wrap text functionality is turned on for the column the formula is on."

and how can I make sure that the formula works when a new line has been built after sending data by a form?😏

Paul Newcome

Click on the column header and then click on the circled button in the screenshot below to enable text wrapping. This will take full advantage of using the line break (CHAR(10)) as you delimiter.

To ensure the formula pulls down into new rows, you can right click on any cell that contains the formula and select the option to "Convert to Column Formula".