Automation is not copying column across to new sheet

Chris Martin

HI All

I have a simple automation that is supposed to copy row to new sheet once triggered

this is the source sheet, you can see that the collection date is there in the source sheet (this date is automated to populate when row is added through the form)

but in the "copied to" sheet it is not there and has not come across.

Why is it doing that?

My only thought that one automation has bet another. Does the automation list have hierarchy? like the top of the list automates first?

thanks for you help.

Chris

Michael Culley

Yea i'd be willing to be the row being copied happens before the date is populated.

Since you're just copying and not moving it, couldn't you just use an index/match formula on the 2nd sheet to populate the dates from the first? Perhaps by searching the flock ID.