How to Write Difficult Formulas in Airtable

Formulas are arguably one of the most difficult skills to master - so in this video I break down the steps I take when writing a complicated formula. Specifically, I walk through two important steps: (1) Breaking your long formula down into smaller formulas, before putting them together (2) Using variable outputs like "X" and "Y" to test the logic before making things more complicated Let me be perfectly honest - this video goes deep and gets complicated. If you're new to formulas, you might not want to start here. In this video, I go into detail on the following formulas: -DATEADD (use this to add an amount of time to a date) -LEFT (use this to return a number of characters from the left) -FIND (use this to find what character number some text appears) -IF (use this to write logic statements that result in one option if true, and another option if false) _________________________________________ Learn more at these links: 🔗 👇 Join us for our next live training! https://www.garethpronovost.com/webin... Take our free Airtable Crash Course! https://garethpronovost.com/airtable-... Getting Stuck? See how we can help! https://garethpronovost.com Get our Airtable Field Type download! https://www.gapconsulting.io/airtable... _________________________________________ Software Resources (may contain affiliate links): 💻 👇 Airtable - https://airtable.com/invite/r/v0eI3ASY _________________________________________ #GAPConsulting #GarethPronovost #Airtable