- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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
 
 
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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'
)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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? 
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 16, 2023 01:01 AM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 16, 2023 07:23 AM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 17, 2023 01:10 AM
