Help

How to create Formula IF rule for dates, when Status is DIFFERENT [free(30days) and pay(365 days)]

1259 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Alex_Donega
5 - Automation Enthusiast
5 - Automation Enthusiast

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

download.png

this is without if

Captura de tela 2023-01-14 133514.png

I'm trying this

Captura de tela 2023-01-14 133737.png

 

and i need to put another status and dates

 

tks to help

 

 

 

 

2 Replies 2

IF(

  AND( {quando_inicia}, {Status}),

  DATEADD(

    {quando_inicia},

    SWITCH( {Status},

      "free", 4,

      "30 days", 30,

      "365 days", 365 

    ),

    'days'

)

Alex_Donega
5 - Automation Enthusiast
5 - Automation Enthusiast

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

Alex_Donega_0-1673744053136.png

my status, bellow

Alex_Donega_1-1673744128452.png

 

"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 🙂