Hey all! I’m a bit stuck here and hope that somebody might have an idea to share.
I have a table that lists a bunch of SaaS products that I use (such as Airtable!). Many of them have monthly recurring costs on the same date each month.
What I’m ultimately trying to do is create an automation that reminds me the day before each subscription is renewed every month, but for the life of me can’t quite work it out.
I think I need a date/time column that indicates the day of the month that each subscription gets renewed, and then I guess a formula that will trigger the automation 1 day prior to the renewal?
Hopefully that makes sense… thanks in advance for anybody that can assist!