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