Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Sep 03, 2017 11:23 AM
Is it possible to display results from 2 different IF Formula fields in one field-I tried using an ARRAYJOIN formula…
Feb 14, 2019 05:44 PM
Let me see if I understand you correctly. You have two fields with IF formulas, each generating some output. Let’s say that Field 1’s IF output is “First”, and Field 2’s IF output is “Second.” In another field you want to combine them both so that it displays something like “First Second”. Is that correct?
The in-app annotation help for ARRAYJOIN says that it “Joins the array of rollup items,” which doesn’t apply to this case. However, this works:
{Field 1} & " " & {Field 2}
Obviously change the " " contents depending on how you want the two pieces joined.