Data shuttle & Unchanged Rows
Hello! I am trying to think of a simple way to highlight rows in my target sheet that are no longer in my source sheet. I know I can have them deleted but I am trying to see if there is an option where they stay on target sheet until I delete them myself.
What I have tried so far was to add a column to my source sheet where I would enter date before uploading to Target. Once uploaded, I would then filter out any rows that did not just get added/updated using that column.
While this isn't very complicated or long to do I was wondering if there was an even easier way to accomplish this? I considered the "Record a Date" workflow but cannot think of an appropriate trigger. When I tried it with no specific trigger except When Any Field changes for rows added/changed, it kept adding a date even to the rows I know no longer existed on Source as I was working in it so it was just not a reliable method. My first solution works better.
Any other ideas or should I stick with what I have?