Examples of advanced formulas in AirTable:

Parsing Text

Getting width and height from this string: 1200x1600.jpg

Width:

IF(
    NOT(ISERROR(LEFT(LEFT({Type},FIND('.',{Type})-1),FIND('x',LEFT({Type},FIND('.',{Type})-1))-1))),
    LEFT(LEFT({Type},FIND('.',{Type})-1),FIND('x',LEFT({Type},FIND('.',{Type})-1))-1)
)

Height

IF(
    NOT(ISERROR(RIGHT(LEFT({Type},FIND('.',{Type})-1),FIND('x',LEFT({Type},FIND('.',{Type})-1))-1))),
    RIGHT(LEFT({Type},FIND('.',{Type})-1),FIND('x',LEFT({Type},FIND('.',{Type})-1))-1)
)

ArrayDiff

In a field I have the next array ({Family Children}): Olivia Ballard,Rhys Ballard,Georgia Ballard,Hank Ballard

In other field I have ({Full Name}): Rhys Ballard

I want the difference: Olivia Ballard,Georgia Ballard,Hank Ballard

SUBSTITUTE(
    SUBSTITUTE(
        SUBSTITUTE({Family Children},{Full Name}&",","")
        ,","&{Full Name}
        ,""
    )
    ,{Full Name}
    ,""
)

Parsing Dates

Displaying children name with age in years or in months if the age of the children is less than 3

{First Name} & " " &{Last Name}&
IF(DATETIME_DIFF(TODAY(), {Child's DOB}, 'years')< 3,
 " ("& DATETIME_DIFF(TODAY(), {Child's DOB}, 'months')&" months)",
 " ("& DATETIME_DIFF(TODAY(), {Child's DOB}, 'years')&" years)"
)

Displaying a friendly date for events with a schedule on specific hours or full days