I have the below if formula but it is giving an error about a malformed if statement. can't see anything wrong with it?
if [E Flag]="Yes" then "E Customer"
else if [M Portal]="Yes" then "M Customer"
else if [A Flag]="Yes" then "A Customer"
else if [C Customer]="Yes" then "C Customer"
else if ([Current Price]="d11" or [Current Price]="Urgent") then "D"
else "Other" endif
Solved! Go to Solution.
Hey there @Usamah22
Try getting rid of the space between all of your "else if" bits (i.e. change them all to elseif).
Hi @Usamah22,
I believe you need to do small amendment:
if [E Flag]="Yes" then "E Customer"
elseif [M Portal]="Yes" then "M Customer"
elseif [A Flag]="Yes" then "A Customer"
elseif [C Customer]="Yes" then "C Customer"
elseif ([Current Price]="d11" or [Current Price]="Urgent") then "D"
else "Other" endif
I have aded a workflow for you as well.
Please mark my post as a solution if it was helpful!