Parse error at char 121: Unmatched Expression
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I keep getting an error message " Parse error at char 121: Unmatched Expression and I am not sure why. The error is right before the 2nd "Then" and I am not sure what is wrong with the syntax, can someone point out what I am doing wrong?
Solved! Go to Solution.
- Labels:
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Looks like a missing ")" before the THEN and an extra "(" before the ISEMPTY. You have 3 open Parenthesis but only 1 closing in that ELSEIF line.
Putting two ")" after the (ISEMPTY([2nd GI]) should fix it.
IF [1st GI]>"2022-12-31" AND [2nd GI]>"2022-12-31"
THEN "Delivered"
ELSEIF ([1st GI] > "2022-12-31" AND (ISEMPTY([2nd GI])))
THEN "In Transit"
elseif
contains([1st GI],"ESD") AND (ISEMPTY([2nd GI]) OR Contains([2nd GI],"ETA"))
THEN "Planning TBD"
ELSE "NA"
ENDIF
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I tried adding the ")" before the THEN and still issue and then removed the "(" before the ISEMPTY and still did not work, still not sure where to go with this!
Mike
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Copy the code pasted above and replace it. I was able to get the workflow to work by adding the two Parenthesis before the THEN.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This code works, you shouldn't need to have the IsEmpty section within parenthesis;
IF [1st GI]>"2022-12-31" AND [2nd GI]>"2022-12-31"
THEN "Delivered"
ELSEIF ([1st GI] > "2022-12-31" AND ISEMPTY([2nd GI]))
THEN "In Transit"
elseif
contains([1st GI],"ESD") AND (ISEMPTY([2nd GI]) OR Contains([2nd GI],"ETA"))
THEN "Planning TBD"
ELSE "NA"
ENDIF
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@MikeFrancis1959 Try the below formula
IF [1st GI] > "2022-12-31" AND [2nd GI] > "2022-12-31"
THEN "Delivered"
ELSEIF [1st GI] > "2022-12-31" AND isEmpty([2nd GI])
THEN "In Transit"
elseif
(contains([1st GI],"ESD") AND ISEMPTY([2nd GI])) OR Contains([2nd GI],"ETA")
THEN "Planning TBD"
ELSE "NA"
ENDIF
