Please correct me if i’m wrong. I don’t see a CASE statement in Airtable.

It’s a classical one but still very useful if you can avoid unreadable nested IF statements :

CASE (

condition1; Statement if condition1 is TRUE; statement if condition1 is FALSE;

Condition2; Statement if condition2 is TRUE; statement if condition2 is FALSE; …

DEFAULT VALUE when nothing else matched )

Advantage: The evaluation ends with the first condition that matches