Help

I need help with a formula to indicate a 21 day reminder before renewal

Topic Labels: Formulas
735 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Tiaan_Terblanch
6 - Interface Innovator
6 - Interface Innovator

What I need:

For a field to update automatically with a status change if there is 21 days remaining before the clients renewal date.

For example, if the next renewal date is 21 days away I would want a “Status of Renewal” field to say ‘Close To Renewal’, but I would also want to know if the member is still ‘Active’ or if they are past the ‘Next Renewal’ date then it has to say ‘Needs Renewal’.

1 Reply 1
Russell_Findlay
8 - Airtable Astronomer
8 - Airtable Astronomer

Hi

I will give this to you as a two part formula for ease and clarity but obviously can be nested one inside the other

so to get the days between now and renewal - Calculation of days to renewal is defined as

DATETIME_DIFF(Notes,TODAY(),‘days’)

then you can have a second formula

IF(Calculation<0,“Needs Renewal”,IF(Calculation<21,“Close to Renewal”,“OK”))

This obviously gives your field as a formula - if you want it to be anything else (e.g. single select field) - then you will need to use automations based on the results of those formulae and potentially views to trigger