How to create Formula IF rule for dates, when Status is DIFFERENT [free(30days) and pay(365 days)]
I have a software and I have a 30-day and paid 365-day trial plan.
I need 3 columns:
- start date
- status
30 days
365 days
when it ends (formula)
I need to do the following:
I put the start date, for example 01/01/2023
status 30 days
automatically in the column when it ends will be 02/01/2023
and if I change the status to 365 days, automatically the field when it ends changes to 01/01/2024
this is without if
I'm trying this
and i need to put another status and dates
tks to help
Thanks for answering @kuovonne 😎
I've renamed the columns and statuses for easier communication. Now it's all in English on my airtable.
I tried your formula and it didn't work, I tried to make an update and it still doesn't work.
my columns, bellow
my status, bellow
"test" + 2 days
"repayment period" + 7 days
"Free" + 365 days
"customer" + 365 days
"customer" this dont exchange nothing, because the customer cancel :(, rsrs
Bellow, I exchance a little your formula. But not working 😞
IF(
AND( {first_day}, {Status1}),
DATEADD(
{first_day},
SWITCH( {Status1},
"test", 2,
"repayment period", 7,
"Free", 365,
"customer", 365
),
'days'
)
Could you help 🙂
