QUESTION --> IF c THEN t ELSE f ENDIF

[PedroPerdomo]

Hi There,

good morning,

I am stuck trying to get a Workflow done, this is my issue: in a table I have different customers under [consignee names] but each customer goes to a different terminal (new column that i would like to create with that terminal, so I did a formula using IF for the first customer, but I don't know how to create it for the next customers.

Ex (everything ok through here). 

IF [Consignee Name]="Customer1" THEN "Column AA" ELSE "" ENDIF

So I need to continue the formula adding

Customer 2 to Column AB

Customer 3 to Column CD 

etc etc.

Any help I will appreciate it.

Thanks in advance,

[SahadhKuruniyan]

I am facing same issue

When I try to put ENDIF everything become black

[ChrisTX · Accepted solution]

@SahadhKuruniyan can you post your workflow? 

Is your field name spelled correctly?

"Differeces" versus "Differences"

Chris

[olsenprime]

Thanks @SamDesk! I had an ENDIF problem and had no idea about adding the last ELSE statement!