Copy Row automation brings original sheet 'Created date' instead of showing date it was moved
Please help, I have a helper sheet that I am using to capture time stamps of when a row goes to different statuses (ex: capture time stamp when request status changes from: In Review, Pending Response, and Completed).
To do that I set up a copy row automation that triggers when those statuses change. Then it copies the row to my new helper sheet.
But when it copies over to the helper sheet, it is just bringing the Created Date from that original sheet. It doesn't actually show the created date on the helper sheet. And the modified date column just changes every single row when something new populates on that sheet. How do I get the time stamp at each status change?
Screenshot of my copy row automation:
Screenshot of the columns on my helper sheet that the rows are being copied to:
Help Article Resources
Check out the Formula Handbook template!