Hey there, I’m working my way through connecting and testing a Twilio Glide Zap connection. Can someone tell me why I am getting the #N/A error and how to fix it please. And when I replace with #N/A with an actual phone number (with an international code), the column heading turns to REF! Nonetheless, it’s an error message.
@ThinhDinh did an excellent tutorial on using arrayformulas. It’s almost a year old, but I think most of it is still relevant.
Arrayformulas are very useful, but as the capabilities of Glide are being extended, they are becoming less necessary. Many things that used to require an arrayformula can now be done natively in Glide using computed columns. This is much preferable, as calculations happen on a user device instantly, and delays caused by syncing with the Google Sheet are eliminated.
My general rule of thumb when it comes to formulas is to first look for a way to do it in Glide, and only turn to a spreadsheet formula (or script) as a last resort.
Applying the above to your scenario, you could have achieved the same thing using a relation and a lookup column