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

Automations 1
Automations 1 ✭✭✭✭✭
edited 06/14/22 in Add Ons and Integrations

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?

Best Answer

Answers

  • Kelly Drake
    Kelly Drake Overachievers Alumni

    There was an error rendering this rich post.

    Kelly Drake (she/her/hers)

    STARBUCKS COFFEE COMPANY| business optimization product manager

  • Automations 1
    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
    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?