I’m guessing there’s a syntax error here… I can get the formula to save if I copy a sample formula that includes 3 or 4 arguments, but as soon as I add more, I get an error when trying to save. PLEASE HELP! IF( {Ticket Total} > 0, SWITCH( {ShowDate4F...

OK… straight to the point… I’m importing order data using Zapier and the data source from which I am importing only provides comma-separated order data. For example, if a customer buys a qty of 3 of item 1, and a qty of 2 of item 2, I get a record l...

Hi… First post here… I’m trying to simply search a lookup field for a certain Order ID number (397147) and have the formula field display “VIP” if it is found, and “NON-VIP” if it is not found. The formula is only showing “VIP” in those records where...

Hi all! I just started using Airtable today, and my mind is spinning with all of the automation possibilities! I am stuck at the moment and could use some guidance- any help is greatly appreciated- thank you in advance! I’ve created a base that I am ...