Move to another sheet when date is x months old?

Kimbh · 03/02/22

Hi, is it possible with an automation or set up a formula to move a row to another sheet after it three months old? I have a date column, but I can't find a way to move it by date.

Thank you

Jeff Reisman · 03/02/22

If you're using the system column "Created" for your start date, add a date column:

=Created@row + 90

Alternatively, just use this formula to add 90 days to whatever date field you are using.

That will set the date field to 90 days after it was created, roughly 3 months old.

Then create your automation rule:

Kimbh · 03/09/22

I created this automation saying if the form date field is not within the next 90 days to remove older rows, but it removes everything. What do I have set wrong in the condition? Thanks