how to consolidate linked dates to create a timeline view

[stephaniecarra]

Hi, I have a few tables for different marketing teams, and each team has their own campaigns and dates. Some campaigns have more than one date. I created a master integrated marketing plan where i pull in information from each marketing teams table. The dates end up living across multiple columns in each record, making it impossible to create a timeline view. I've tried formulas, rolling up dates, flattening, but nothing has enabled me to create a timeline view based off one date field the way airtable requires. Any suggestions or workarounds out there?

[DisraeliGears01]

Probably need more information to provide a true workaround (how many fields/columns are you trying to consolidate?) but right off the bat it sounds like a nested IF formula is what you need. IF A_field is empty, B_field. IF A_field and B_field are empty, C_field. Repeat ad nauseum. You could also use automations to copy the date information into a single timeline field

[TheTimeSavingCo]

Does this look right?

Link to base

The formula field is:

DATETIME_PARSE(
  {Date (from Table 2)} & {Date (from Table 3)}
)