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

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 : )

approved.yxmd