Feb 15, 2023 05:49 PM - edited Jul 08, 2024 06:12 PM
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
Feb 16, 2023 12:17 AM - edited Feb 16, 2023 12:19 AM
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'
)
Feb 16, 2023 12:50 AM
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
Feb 16, 2023 12:54 AM
Hm, that shouldn't affect anything:
Could you provide a screenshot of the error you're seeing when you try to use the formula?
Feb 16, 2023 01:01 AM
Feb 16, 2023 01:30 AM - edited Feb 16, 2023 01:31 AM
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?
Feb 16, 2023 07:23 AM
Feb 17, 2023 01:10 AM