Nested if formula

[PrashantJP]

Hi Community,

Could you please help me with the following nested if statement for formula function? I am getting error when I run the below

if [Approval Status Code (Prop)]="Approved" then "Proposal in Approved state"

else

if [Approval Status Code (Prop)]= "Draft" then "Proposal in draft state"

else

IF [Approval Status Code (Prop)]= "Pending Approval" then "Proposal pending for approval"

else

IF [Approval Status Code (Prop)]= "Complete" then "Proposal complete"

else

"Need to raise proposal"

endif

[atcodedog05 · Accepted solution]

Hi @PrashantJP 

Change like below, it should work.

if [Approval Status Code (Prop)]="Approved" then "Proposal in Approved state"

elseif [Approval Status Code (Prop)]= "Draft" then "Proposal in draft state"

elseif [Approval Status Code (Prop)]= "Pending Approval" then "Proposal pending for approval"

elseif [Approval Status Code (Prop)]= "Complete" then "Proposal complete"

else "Need to raise proposal"

endif

Workflow:

Hope this helps : )

[Jean-Balteryx · Accepted solution]

Hi @PrashantJP ,

You have to write "ELSEIF" instead of having "else" on one row and "if" on another row.

[PrashantJP]

Thanks a ton 🙂