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

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