Formula is #UNPARSEABLE

John- Michael Diedrich · 06/20/23

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")), "")

Kleerfyre · 06/20/23

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 · 06/20/23

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 · 06/20/23

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 · 06/20/23

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 · 06/20/23

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.

Formula is #UNPARSEABLE

Answers

Help Article Resources

Categories