Formula error at ENDIF. Can use some help.

Having an issue with this formula looking for some help on what I'm doing wrong. I'm still a novice but not a beginner. Tried a few solutions.

IF IsNull([Ship from Location]) then DateTimeAdd([Commited Ship Date],7,"days") ELSEIF
IF [Ship from Location]="Air" THEN DateTimeAdd([Commited Ship Date],7,"days") ELSEIF
IF [Ship from Location]="Ocean" THEN DateTimeAdd([Commited Ship Date],45,"days") ENDIF

Formula (26) Parse Error at char(254): Malformed If Statement (Expression #1)

As always this group is top notch for helping out users.

Thank You in Advance

Ted Jillett

Workflow

Accepted answers

Thableaus

Hi @Tjillett

IF IsNull([Ship from Location]) then DateTimeAdd([Commited Ship Date],7,"days") ELSEIF
[Ship from Location]="Air" THEN DateTimeAdd([Commited Ship Date],7,"days") ELSE
DateTimeAdd([Commited Ship Date],45,"days") ENDIF

No IF's after ELSEIF's. Also, you need to add an ELSE Clause.

See if this works out well.

Cheers,

All comments

Thableaus

Hi @Tjillett

No IF's after ELSEIF's. Also, you need to add an ELSE Clause.

See if this works out well.

Cheers,

Tjillett

Thank you for the very quick solution.

Have a great weekend

DBourke19841

Having a similar issue with an if formula. I'm sure it's something silly I'm missing

Any guidance would be appreciated.

Thanks,

Donal

Alt_eryx22

Ok so I've read this whole chain and I'm still having the same issue. Everything looks fine until I add "endif". If I do, it grays out parts of my code. Any idea how to fix?

IF [Effective year]=[User.Current Year] THEN [Cash received and 12-month projection for T-Initial polices]+[2020 Cash Received]
ELSEIF [Effective year]=[User.Prior Year] THEN [Cash received and 12-month projection for T-Initial polices]+[2019 Cash Received]
ELSE 0
ENDIF

Mchappell67

Hi, @Alt_eryx22 -

Could it be a mismatched data type issue? Are you sure that [User.Prior Year] exists? Can you post the workflow?

Mark

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703