Hi!
My team has used Asana to create templates for different categories of events that auto-populate tasks with due dates (e.g. 45 days before event date). What is the best method to creating similar templates in Airtable?
Below is a screenshot from the Asana template.
I’m looking to get each Due Date cell to auto to x days before the event date, excluding weekends. I tried using DATEADD, but this does not work on individual cells.
Thanks!
What if you used Record Templates for this (https://support.airtable.com/docs/using-record-templates-in-airtable)? I’ve set it up here for you to check out, and they let you set relative dates like so:
You can apply it using automations, and also apply it manually:
This is amazing, thank you! Would you be able to explain how you setup the record template to look like this:
Ah I don’t understand the question, so sorry!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.