Hey ​@Kim_Trager1,

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 ​​​​​​​

Hi ​@Kim_Trager1, 

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.

The 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...

​@Kim_Trager1, Ok that is a good clue that nothing shows up in the formula field when you just enter “Material supplier address”. What is that lookup field looking up? What field type? Also are they only looking up one record or multiple? 

Just looking up another lookup, which is looking up a synced field that is set to Long text, so pretty standard, I would think.

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.

Ahhh thank you. Did it with a rollup and a Arrayjoin(Arrayunique(values))… That did the the trick