Get our *FREE AIRTABLE CRASH COURSE* here 👉👉 garethpronovost.com/airtable-crash-course ⚡⚡ Follow along in Airtable here 😍😍 airtable.com/invite/r/v0eI3ASY 🤓🤓
Love this, thanks. Do you think there is a way to have an event that is pinned to a certain start and end date and have other things shift around it? For example, if there is a deadline or client meeting that cannot be moved, but tasks can be pushed before or after that one event? If I figure it out, I'll let you know! Thanks for all your vids!
Hey Nancy! There isn't exactly a PIN function in Airtable I'm afraid. I can imagine a scenario where you build your interface in Softr or Noloco (3rd party tools) and then set conditions that state the dates are no longer editable if you (check a box, change event status, etc.) - this would get the functionality you seek, but it's a big lift to build this for simply this feature... Hope this helps!
This is excellent, thank you! One note - this doesn't work with a Gantt Chart extension; for some reason, the Gantt Chart adds an extra day onto a task, so all of my dependencies state they 'start before the predecessor end date.' Do you have a video where you integrate something like this with a Gantt Chart? Also - do you have a video to recreate this where, instead of creating tasks with a "Start Date" and auto-generating an "End Date," you start with an "End Date" and work backwards to generate a "Start Date" - where the dependencies formulas and 'Trigger' Automation still work? Thank you for your time!
Thanks for watching! Regarding the date, you may want to check timezone settings for your dates. Often a date will bump up if the settings are GMT and not local time. We don't have a video showing how to do this in reverse, but the same logic shown here can still be applied! You'll just swap your formulas to count back instead of forward... Hope this helps!
What if the task was completed before the calculated end date, is there a way to make the dependent task Start date to be based of the completed date of the dependent task? I don’t want to wait to the due date
Absolutely. You can create a field that displays the date that a task was completed. Explore the "last modified date" field type for this. Then use this field in your automations.
Get our *FREE AIRTABLE CRASH COURSE* here 👉👉 garethpronovost.com/airtable-crash-course ⚡⚡
Follow along in Airtable here 😍😍 airtable.com/invite/r/v0eI3ASY 🤓🤓
Nice job. Very smart.
Thanks!
Love this, thanks. Do you think there is a way to have an event that is pinned to a certain start and end date and have other things shift around it? For example, if there is a deadline or client meeting that cannot be moved, but tasks can be pushed before or after that one event? If I figure it out, I'll let you know! Thanks for all your vids!
Hey Nancy! There isn't exactly a PIN function in Airtable I'm afraid. I can imagine a scenario where you build your interface in Softr or Noloco (3rd party tools) and then set conditions that state the dates are no longer editable if you (check a box, change event status, etc.) - this would get the functionality you seek, but it's a big lift to build this for simply this feature...
Hope this helps!
This is excellent, thank you! One note - this doesn't work with a Gantt Chart extension; for some reason, the Gantt Chart adds an extra day onto a task, so all of my dependencies state they 'start before the predecessor end date.' Do you have a video where you integrate something like this with a Gantt Chart? Also - do you have a video to recreate this where, instead of creating tasks with a "Start Date" and auto-generating an "End Date," you start with an "End Date" and work backwards to generate a "Start Date" - where the dependencies formulas and 'Trigger' Automation still work? Thank you for your time!
Thanks for watching!
Regarding the date, you may want to check timezone settings for your dates. Often a date will bump up if the settings are GMT and not local time.
We don't have a video showing how to do this in reverse, but the same logic shown here can still be applied! You'll just swap your formulas to count back instead of forward... Hope this helps!
@@GarethPronovost Thanks, I will try this!
How do you make it so the dates are only counting work days?
How would you avoid scheduling work on weekends with this method?
There's a weekday formula that excludes weekends. Use this for your calculation prior to automation
What if the task was completed before the calculated end date, is there a way to make the dependent task Start date to be based of the completed date of the dependent task? I don’t want to wait to the due date
Absolutely. You can create a field that displays the date that a task was completed. Explore the "last modified date" field type for this. Then use this field in your automations.
Is this the Nrittany video? 😆
She inspired a lot! 😂
@@GarethPronovost 😆