
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 02, 2023 11:15 AM
Hi,
I'm trying to set up an automation that generates tasks with due dates. For example, when I create a project with an overall due date in a "projects" table, I plan to create a record in the "tasks" table with individual tasks and due dates calculated from the project due date.
So, I'm trying to get the task to calculate its own due date based on the "Send Date" field in my Projects table. I have the following formula that isn't working.
I have also tried -21, "days", and a few other solutions others have seen, but I continue to get an error that says "Could not convert string to date" -- any ideas?
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 05, 2023 03:47 AM
We can't use formulas within automations I'm afraid. You're going to need to create a formula field to hold that value and use that field in your automation instead
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 05, 2023 03:47 AM
We can't use formulas within automations I'm afraid. You're going to need to create a formula field to hold that value and use that field in your automation instead

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 05, 2023 09:08 AM
Dang - that is a bit frustrating. Thank you!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 03, 2024 03:24 AM
This is a big frustration in Airtable especially around dates. I created an useful video on how I get around this, can easily be adapted to use inputs and add/subtract time too
Hope it helps
https://www.youtube.com/watch?v=n2eTUFvyGY0
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 07, 2024 11:19 AM
Worked pretty well! tx!
