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?
+27There 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}
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}
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.
+35I 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.
Except that she gave you the exact answer. :man_shrugging:
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:
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:
I have made 4 linked to four tables in four separate coulms but I cant get dates out of it
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:
+27Ok 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:
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")))))
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.