Is there a way that I can have some fields move from one Google worksheet to another worksheet in the same Spreadsheet after 6 months have passed since the date in the field?
To give context, I want to create a zap to help me track inactivity from Meetup groups. So far, I’ve created a zap to put the Meetup event and date in a Google Spreadsheet, in the worksheet called active 6 months. After 6 months have passed, I would like to move the fields taken from Meetup to another worksheet called active 1 year, after that year has passed, I’d like to move the fields into a final worksheet called inactive.
I’m having issues using time as a trigger for the zaps. Is this even possible?
Best answer by WillBMTPView original