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?
how to consolidate linked dates to create a timeline view
+1
+21Probably 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
+31Does this look right?
The formula field is:
DATETIME_PARSE(
{Date (from Table 2)} & {Date (from Table 3)}
)Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.