I'm new to formulas but have learned quite a bit from these forums. I have arrays of Hardiness Zones for plants, which are written like this: 4a, 4b, 5a, 5b, 6a, 6b and so on. I need to put them into ranges like this "Zone 4-8". So far I have it this...
Hi, I am pretty new to this and not a developer. We are using Airtable for our product database for our Shopify store, and have Airpower as the sync between them. This works pretty good, but there is one major thing we need that Airpower does not sup...
Sorry to double reply but I found the solution for my first problem! Apparently Airtable doesn't like to use LEN on a lookup field, but I found someone's comment saying to use &'' after the field name and it would solve the problem. So this new formu...
Thanks, but when I do the First or Last values, it still gives 10 and 10 for example, if 10 is the only Value in that field. I'm looking for something that would say like, If there is only one Value in the cell, don't do the Left and Right arrayjoin ...
Thanks for your input! I actually just solved it myself with a really easy fix The committed inventory is already being brought through to Airtable in our "Order Line Items" table, as order quantity. So I just linked the order quantity field back i...
