Formula is #UNPARSEABLE

Hello community,

My formula below is showing #UNPARSEABLE. Can someone please help me figure out why?

Formula:

=IF([Job Complete]@row "Cancelled", "", (IFERROR(IF(ISBLANK([CIT PPO #]@row), "", IF(TODAY() > [Invoicing Status Due Date]@row, "Non Compliant", "Compliant")), "")

Find more posts tagged with

Formulas

Accepted answers

All comments

Kleerfyre

Try removing the ( in front of IFERROR. You have a lot going on in this formula so fixing that might open up more errors.

John- Michael Diedrich

https://community.smartsheet.com/discussion/comment/381381#Comment_381381

Thanks Kleerfyre. I have updated it to the below and still get #UNPARSEABLE. Please let me know if you have any other suggestions.

=IF([Job Complete]@row "Cancelled", "", IFERROR(IF(ISBLANK([CIT PPO #]@row), "", IF(TODAY() > [Invoicing Status Due Date]@row, "Non Compliant", "Compliant")), "")

Kleerfyre

You don't have enough ) for all your (. Go back through your formula and make sure you match them all up. Without anymore context, I don't know what else to look at. What are you trying to do with your formula?

John- Michael Diedrich

https://community.smartsheet.com/discussion/comment/381383#Comment_381383

Here is another way I tried rewriting it but am still getting #UNPARSEABLE. Any idea what is throwing this off?

=IF(ISBLANK([CIT PPO #]@row), "", IF(TODAY() > [Invoicing Status Due Date]@row, "Non Compliant", "Compliant")) + IF([Job Complete]@row "Cancelled", "")

Kleerfyre

Try testing out each part of your formula to see what part is throwing it off. Break it down piece by piece and you should find the issue.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.