Hi everyone, I’m a new airtable user who needs some advice how to perform the following task efficiently. I want to track some subscriptions like this:

The renewal date column should auto increase under this circumstances:

If interval monthly:

And {Renewal Date} <= Today()

{Renewal Date} = DATEADD({Renewal Date}, 1, ‘months’)

If interval yearly:

And {Renewal Date} <= Today()

{Renewal Date} = DATEADD({Renewal Date}, 1, ‘year’)

I have already tried several ways, but I am not very satisfied with them. Thank you