Formula to calculate Due Date

Forum|Forum|2 years ago
February 16, 2023
7 replies
29 views

Francoloco23
Known Participant
11 replies

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

+31

TheTimeSavingCo
Brainy
6416 replies
Forum|Forum|2 years ago
February 16, 2023

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

Adam, Airtable Consultant - thetimesaving.company

Francoloco23
Author
Known Participant
11 replies
Forum|Forum|2 years ago
February 16, 2023

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

+31