Archive rows on Target sheet if they are not on Source Sheet - using Data Uploader

Automations 1

Hi,

I'm looking for a way to have rows archive on my target sheet if there is no match on the source sheet.

I know there's an option to have those rows deleted, but I don't want to do that. I would want to have them move to another sheet so that I still have record of them.

Any ideas?

Kelly Drake

Well that's frustrating that the previous comment did not post.... ugh.

You'll want to submit an enhancement request because data uploader cannot do what you're asking currently. To get to what you're looking for you'll need to create a move row workflow after your data uploader runs.

Assuming you have your workflow run on a schedule - for this lets say Monday 1 am. You can add a Last Updated system generated column and then a helper column using this formula:

=IF([Last Updated]@row = TODAY, 1, 0)

Then have your automation run an hour later (but only have it do this every Monday) and move rows where the box is not checked.

You may need to confirm that the today formula is triggered by the data uploader updates.

Kelly Drake

There was an error rendering this rich post.

Kelly Drake

Well that's frustrating that the previous comment did not post.... ugh.

You'll want to submit an enhancement request because data uploader cannot do what you're asking currently. To get to what you're looking for you'll need to create a move row workflow after your data uploader runs.

Assuming you have your workflow run on a schedule - for this lets say Monday 1 am. You can add a Last Updated system generated column and then a helper column using this formula:

=IF([Last Updated]@row = TODAY, 1, 0)

Then have your automation run an hour later (but only have it do this every Monday) and move rows where the box is not checked.

You may need to confirm that the today formula is triggered by the data uploader updates.

Automations 1

Thanks @Kelly Drake. I'm going to put in an enhancement request. Especially since I don't want to be tied down to making sure that the data gets uploaded exactly at a specific time.

I'm going to try your idea.

BTW, congrats on becoming an Over-Achiever! 😁

Automations 1

hi @Kelly Drake

Hoping you can still help me with this. I tried it out a few more times and see that if specific rows of information on my source sheet don't change, then the date modified on the target sheet doesn't change when data uploader runs.

This is a big problem because when the formula based off of the Modified date runs, it checks the box to have it archived!

Any suggestions?