Help

Re: Formula to calculate Due Date

2047 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Francoloco23
5 - Automation Enthusiast
5 - Automation Enthusiast

Good day Airtable Team,

I would like to ask for your assistance in a formula to compute for the due date based on the following scenarios:

1. Due Date if Rush Tag is Yes: Variables to be used would be "Extracted for Ticketing" and "Rush TAT".

2. Due Date if Rush Tag is No: Variables to be used would be "Extracted for Ticketing" and "Rush TAT".

Thank you

Rush Tag.PNG

Due Date Airtable.PNG

7 Replies 7
TheTimeSavingCo
17 - Neptune
17 - Neptune

Assuming "WD" stands for a day or something, try something like:

 

DATEADD(
  DATETIME_PARSE(
    Date,
    "MM/DD/YYYY"
  ),
  VALUE(
      SUBSTITUTE(
        SWITCH(
          Rush,
          "Yes",
          {Rush Time},
          {Standard Time}
        ),
      "WD",
      ""
    )
  ),
  'days'
)

 

 Link to base

Hi @TheTimeSavingCo,

When I applied the formula, the date and time were not the values that I wanted. I believe the column "Extracted for Ticketing" has a time that is why an error would occur when the formula would be applied.

Thanks

Hm, that shouldn't affect anything:

Screenshot 2023-02-16 at 4.54.19 PM.png

Could you provide a screenshot of the error you're seeing when you try to use the formula? 

Hi @TheTimeSavingCo ,

Here

Due Date Formula Error.PNG

Rush Tag.PNG

At a glance I can't see anything wrong there.  Could you send me an invite to your table so I could troubleshoot it from there?

Hi @TheTimeSavingCo,

May I know your email address for the invite?

Thanks

Hi @TheTimeSavingCo ,

I already sent an invite.

Thanks