Help

Auto increasing date column

Topic Labels: Formulas
480 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Florian_Wolf
4 - Data Explorer
4 - Data Explorer

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:
Screenshot 2021-02-08 at 13.16.18

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 :slightly_smiling_face:

0 Replies 0