I am getting a parse error at chart 243 malformed if statement. What is wrong?

[Marcegon]

IF DATETIMEPARSE([End_date], "%Y-%m-%d") >= DATETIMEADD(DATETIMENOW(), -7, "days") THEN IF [Involvement] = "No Spend" OR [Involvement] = "Support only" THEN "Not required"
ELSEIF [Attachments] = "Budget" THEN "Completed" Else "Missing"
ENDIF

[NexBK · Accepted solution]

There are two IF statements, but only one "ELSE" and one "ENDIF".

As shown in the picture, I recommend you to change "THEN IF" to "ELSEIF" in the middle.

IF DATETIMEPARSE([End_date], "%Y-%m-%d") >= DATETIMEADD(DATETIMENOW(), -7, "days")
AND ([Involvement] = "No Spend" OR [Involvement] = "Support only") THEN "Not required" ELSEIF 
DATETIMEPARSE([End_date], "%Y-%m-%d") >= DATETIMEADD(DATETIMENOW(), -7, "days")
AND [Attachments] = "Budget" THEN "Completed" Else "Missing"
ENDIF

[Marcegon]

Thank you!  ELSEIF breaks the code for whatever reason.  Any other suggestion?

[NexBK]

I revised what I posted a little while ago. Would you like to try again?

[Marcegon]

It worked!  Thank you so much