Help

Updating formula - Nested IF statements

Topic Labels: Formulas
299 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Sean_Lake1
8 - Airtable Astronomer
8 - Airtable Astronomer

Hey all!

I've got a long formula, that currently has just one IF statement, however, I need to update to add another alternate IF.

Here is the existing formula, that works:
IF({Course Status}='Retired',"RET-"&CONCATENATE(LEFT({Course Level},1),{Course Type Coding (from Course Type)},".",{Sequence Number})&"-"&{Course Name},CONCATENATE(LEFT({Course Level},1),{Course Type Coding (from Course Type)},".",{Sequence Number})&"-"&{Course Name})&" "&{Engine Version}

Here is what I was attempting to add:

IF({Course Status}='Retired',"RET-"&CONCATENATE(LEFT({Course Level},1),

IF({Course Status}='Archived(DO NOT DELETE)', “ARC-”&CONCATENATE(LEFT({Course Level},1),

{Course Type Coding (from Course Type)},".",{Sequence Number})&"-"&{Course Name},

CONCATENATE(LEFT({Course Level},1),

{Course Type Coding (from Course Type)},".",{Sequence Number})&"-"&{Course Name})&" "&{Engine Version}

Any ideas how to fix?


Thanks!

0 Replies 0