In other words, 1 row per company, with lots of start/end date columns for multiple phases of a large project.
I now want to plot those phases with some kind of timeline view but am struggling to achieve this with Timeline or Gantt. Calendar view at least allows me to specify multiple input dates per row, but the view isn’t really appropriate for managing a project.
I can see one potential solution which is to create multiple rows in my data per company and then group the various rows by company in my timeline. But I really want to avoid doing this and dramatically messing up the structure of my initial base.
Has anyone else successfully plotted multiple phases of a project for a given row with a timeline view? Or even any other view that works well on project management? Thanks for any thought!
Thanks so much for sharing this. It does indeed enable me to construct the timeline or gantt view I was hoping for, although the one issue I see is that each time a new pair of start/end columns are added (I might have 20 of them), I’ll need to extend the formulas which will become messy and difficult to read pretty quickly.
I don’t mind the fact so much that I need a new table or automations though - it’s just the maintainability of this solution that worries me a little (even though it seems to be the only way to achieve the desired result so I’m accepting as the answer!) Thanks again
Yeah…not to mention the lookup fields that have to be created.
Hmm, I can imagine a script that could handle this for you without you needing to mess with formula fields or lookup fields. It would create new records as needed depending on the number of date fields were filled in and handle the updates etc
The downside would be that you’d have to get someone to write it for you / make changes in the future for you if you don’t know scripting yourself of course
oh interesting, when you say script, you mean your own custom/offline build that pushes data via the Airtable API? Or you mean the “extensions->build a custom extension” option and writing your own script?
Actually, based on your suggestion I just went through the standard scripts and found one that looks like a pretty good fit…