how to copy one cell value to another in workflow

Joachim Mund

Hi all,

In a workflow if a trigger occurs I would like to copy the value of "cell A" to "cell B".

This seems not to be possible or is there a workaround?

Thank you, Joachim

Andrée Starå

Hi @Joachim Mund

Can you elaborate?

Is it on the same row? Is the other cell empty?

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!

Joachim Mund

Hi @Andrée Starå

yes, it is on the same row

no, the target cell is not empty

Situation:

1. Ticket system
2. contact cell "worker" contains programmers contact
3. Status changed to "test"
4. workflow should copy contact cell "responsible" to contact cell "worker"

does this help?

Andrée Starå

@Joachim Mund

Yes, it helps, but unfortunately, it's not possible natively without some helper columns or a 3rd party service like Zapier.

Would it work if we add helper columns?

Joachim Mund

a helper column is a great idea, how would make this?

Andrée Starå

@Joachim Mund

I think you could add a master contact column with a formula referencing the other two main columns and use the Workflow to change those, which would show the correct one in the master.

Something like that.

Make sense?

Joachim Mund

yes, this could make sense, but I built some reports and filters etc in this ticket system which will has to be modified.

In the meantiem I decided to send an Update Requests to the responsible person to manually change this field. Not perfect but will work.

Thank you @Andrée Starå for your great help and impressive ideas and solutions

Andrée Starå

@Joachim Mund

Yes, that is an excellent workaround.

You're more than welcome, and thanks for the kind words!

✅Remember! 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!