Linking four tables to one column

[Zachariasz_Nerc]

Is it possible to nest dates from 4 different tables in one column? I would need something like that:

snipboard.io

Upload and share screenshots and images - print screen online | Snipboard.io

Easy and free screenshot and image sharing - upload images online with print screen and paste, or drag and drop.

I have already rolled up dates and linked to other records but I can’t link to more than one table. Anyone knows formula for that or could help me with ideal how to solve this?

[Kamille_Parks]

There is no way to use one column to link to four tables. You’ll need four Link to A Record fields.

If you want to display the value of all four fields in one additional field you can do that with a formula:

{Field 1} & ", " & {Field 2} & ", " & {Field 3} & ", " & {Field 4}

[Zachariasz_Nerc]

Kamille_Parks:

you want to display the value of all four fields in one additional fi

I want to be able to show date for each milestone completition in one column. You formula is just aggregating 4 different values. Thank You for Your help tho.

[ScottWorld]

Except that she gave you the exact answer. :man_shrugging:

[Zachariasz_Nerc]

Okay, any hint how can I do it? Tried using the formulabut field returned is blank. Didnt want to sound like douche but its really depressing. Im working on it since 3 days and nothingcomes to min, AirTable can be challenging :frowning:

[Zachariasz_Nerc]

I have made 4 linked to four tables in four separate coulms but I cant get dates out of it

[Zachariasz_Nerc]

Ok I came up with different soulution, that so far is not working. What if I nest if forumals? I have rolled up dates from four differetn tables in my summary table and it looks like this:

Now I want to make forumla that will go through each of the column and ignore blank spaces, so far I came up with this

IF({ETAP 1 HARM (AUT)} = BLANK(), BLANK(), DATETIME_FORMAT({ETAP 1 HARM (AUT)}, “DD.MM.YYYY”),
IF {ETAP 2 HARM (AUT)} = BLANK(), BLANK(), DATETIME_FORMAT({ETAP 2 HARM (AUT)},“DD.MM.YYYY”),
IF {ETAP 3 HARM (AUT)} = BLANK(), BLANK(), DATETIME_FORMAT({ETAP 3 HARM (AUT)}, “DD.MM.YYYY”),
IF {ETAP 4 HARM (AUT)} = BLANK(), BLANK(), DATETIME_FORMAT({ETAP 4 HARM (AUT)}, “DD.MM.YYYY”))

but it failed :frowning:

[Kamille_Parks]

You’re missing several end parenthesis at the end of your formula if you were trying to nest several IF()s, and you’re missing the starting parenthesis for each IF() after the first one.

A simplified, nested version of your formula:

IF({ETAP 1 HARM (AUT)}, DATETIME_FORMAT({ETAP 1 HARM (AUT)}, "DD.MM.YYYY"),
IF({ETAP 2 HARM (AUT)}, DATETIME_FORMAT({ETAP 2 HARM (AUT)}, "DD.MM.YYYY"),
IF({ETAP 3 HARM (AUT)}, DATETIME_FORMAT({ETAP 3 HARM (AUT)}, "DD.MM.YYYY"),
IF({ETAP 4 HARM (AUT)}, DATETIME_FORMAT({ETAP 4 HARM (AUT)}, "DD.MM.YYYY")))))