Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Oct 19, 2020 10:03 AM
Is it possible to nest dates from 4 different tables in one column? I would need something like that:
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?
Oct 19, 2020 08:11 PM
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}
Oct 20, 2020 02:20 AM
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.
Oct 20, 2020 02:38 AM
Except that she gave you the exact answer. :man_shrugging:
Oct 20, 2020 02:43 AM
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:
Oct 20, 2020 02:50 AM
I have made 4 linked to four tables in four separate coulms but I cant get dates out of it
Oct 20, 2020 03:26 AM
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:
Oct 20, 2020 09:23 AM
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")))))