Cell value for main or subworkflows.

krumale

I am trying to create a formula or workflow that changes a cell value to a value in another cell.

I tried with workflow, but I can only assign a text or specific value from a drop down.

But I want to assign a value from a specific cell. Formula would help, but this then needs to change depending if the cell is already fill.

What I mean in detail.

1. I have a sheet with workflow that assigns an automated number to each new line e.g. ASA001 etc. in the primary column
2. Then in one step the workflow might need to be duplicated so I can do
   1. either with an extra sheet and workflow first copying it to the sheet and then sending it to the main sheet.
   2. or by just copying the line manually to the same sheet.
3. What I want is the first line submitted to have a column that is called "Main ID" that is empty when the workflow is created, and the worklfow then assigns ASA001 to the line in Primary column and the column "Main" retrieves the same value ASA001. This can be filled in manually by users, but I would like to automate this to avoid errors.
4. Now when I duplicate (either by extra sheet or by copying) the new line will get automatic number ASA002 in Primary column, but I want a formula or workflow to check column "Main"
   1. if it already includes ASA001, it will stay unchanged
   2. bu if it is empty, it will again copy the value from Primary column.

This is so that I can filter the main workflows and subworkflows to see which belong together with the same topic.

Thank you!

Linda