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😃