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!
