I’ve got a very simple IF statement
Facon is a check box, and it’s clearly empty.
Material Supplier address is a lookup and is filled in in most instances.
However, I can’t get this basic thing to work?
Am I doing something wrong?
Solved
Simple IF() does not work, is it a bug?
+23Best answer by airvues
I see, sometimes these look ups of look ups create these sort of nested arrays which Airtable doesn’t really properly shows. I think if you just slap it with CONCATENATE({Material supplier address}) it should turn that nested array into just a string, and that should show up in your formula. If that doesn’t work, you can create a formula with the concatenate in the table you’re looking up the sync values and then look up that string value into your other table with the checkbox.
+28Hey
This seems to be working on my side. See screenshots below.
If Facon is not checked:
If Facon is checked:
What issue are you having? Error shown as output? blank shown as output? Different issue?
Would you mind sharing a screenshot with some dummy data on it?
Feel free to grab a slot using this link and we can get it solved in 2 minutes probably!
Mike, Consultant @ Automatic Nation
+7Hi
What do you mean when you say it doesn’t work? Does nothing change when you click on the checkbox? The formula syntax looks right. I would try deleting that formula field and create a new one, might be an Airtable bug.
Enrique | Airvues Consulting, Enterprise‑grade Airtable solutions for any business use case—scalable, robust, and uncompromising. A blend of no‑code agility with custom‑code rigor and architectural excellence | consulting.airvues.com
+23The Facon address shows when the checkbox is clicked; however, the Material supplier address does not show when it’s not clicked, even though it is present.
I tried to delete and redo the fields. I attempted to enter just “Material supplier address” into a formula field; however, nothing shows.
Tried to delete “Material supplier address” and make another lookup, but still the same...
+7
Enrique | Airvues Consulting, Enterprise‑grade Airtable solutions for any business use case—scalable, robust, and uncompromising. A blend of no‑code agility with custom‑code rigor and architectural excellence | consulting.airvues.com
+23Just looking up another lookup, which is looking up a synced field that is set to Long text, so pretty standard, I would think.
+7I see, sometimes these look ups of look ups create these sort of nested arrays which Airtable doesn’t really properly shows. I think if you just slap it with CONCATENATE({Material supplier address}) it should turn that nested array into just a string, and that should show up in your formula. If that doesn’t work, you can create a formula with the concatenate in the table you’re looking up the sync values and then look up that string value into your other table with the checkbox.
Enrique | Airvues Consulting, Enterprise‑grade Airtable solutions for any business use case—scalable, robust, and uncompromising. A blend of no‑code agility with custom‑code rigor and architectural excellence | consulting.airvues.com
+23Ahhh thank you. Did it with a rollup and a Arrayjoin(Arrayunique(values))… That did the the trick
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.