Workflows updates

Aimee Colton

Hello,

I wanted to know if there is functionality for the following:

I have two sheets, #1 Master and #2 Calendar. I have set up an automatic workflow: when a tick box on sheet #1 Master is ticked, a row is copied to sheet #2 Calendar.

I then realised that if I needed to update anything on #1 (after the row was copied over), the amendments were not being carried over to #2. I tried other workflows but only succeeded in creating a duplicate row on sheet #2.

Is there anything I can do to correct this? Perhaps a workflow or function that removes duplicates with the same row identifier?

Thanks😃

Itai Perez

Hi @Aimee Colton

How many columns do you have on your sheet? I am thinking maybe you can use DataMesh if you have access to it so it will evaluate and run every set time to check and update the columns according to the identifier.

Aimee Colton

Hi @Itai

I don't think we do have access to DataMesh. Is there another way?