Below formula was working fine since last 6 months but I did a version upgrade and getting the below error in EM. Could you please help me reconstruct the formula with correct syntax?
Error if( and ([Team]=“Dormant”,
or ([Status]=“Not Prepared”,[Status]=“System Decertified”)
),“TBA”,
if([Team]="",“TBA”,if([Team]=“TBA”,“TBA”,“ok”))
)
if( [Team]="Dormant" and
([Status]="Not Prepared" or [Status]="System Decertified")
,"TBA",
if([Team]="","TBA", if([Team]="TBA","TBA","ok"))
)
I highly recommend using the new IF/THEN/ELSE operator - it’s better for readability:
IF [Team]="Dormant" and ([Status]="Not Prepared" or [Status]="System Decertified")
THEN "TBA"
ELSE
IF [Team]="" THEN "TBA"
ELSE
IF [Team]="TBA" THEN "TBA" ELSE "ok"
The Rule action is even a better fit for complex nested conditions.