There are certain dates that I want to estimate, but as I get closer to the date I want to visualize and edit further on Airtable’s Calendar View or Gantt Chart. The Calendar View and Gantt Charts Block only accept date fields or formula fields that calculate dates. However, I still want to retain the ability to move these dates around on the calendar/Gantt if something comes up.
First I want to structure my table correctly so that I can actually calculate my fuzzy date. I also have a field in my tasks table for “Months Out,” which basically is asking how many months out a certain task is from the launch date. The script will calculate the Start and End dates of each of these tasks, based on how many months out they are from the launch date.
See the original post for a great written walkthrough with visuals as well as a link to an example base.