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 WillBMTP
I think I’ve worked it out.
I’ve used IF and AND formulas to help organise my fields in the sheets. I’ve also filtered out FALSE fields so that I don’t see all of the events that are not in the right sheets.
For example, an event that has happened within the last 6 months would appear in the active within the last 6 months sheet, but it would also appear in the active within the last year and inactive fields as “FALSE”
I’ve set the sheets to hide all FALSE fields so I only see the fields with actual values in them