IFERROR Formula Help

Claire Graves
Claire Graves โœญโœญโœญ
edited 06/01/23 in Formulas and Functions

Hi All -

I'm working through an IFERROR formula to keep the status column updated on one of my Smartsheets. My syntax is off, and I thought someone in the community might be able to idenitfy the issue(s) before I can. Would you take a look at the below and let me know how I can correct to overcome the dreaded #UNPARSEABLE?

Providing both the color version and the same thing in a format that's easy to copy paste.

Thanks!

Smartsheet IFERROR Formula.PNG

=IFERROR(IF(AND([Applicant Still Interested?]@row = "Yes", [All Docs Received from Candidate?]@row = ""), "Pending Candidate Action", IF(AND([Date Offer Letter Sent]@row = <>"", [Date Offer Letter Returned]@row = ""), "Pending Candidate Action", IF(AND([Date of Drug Test]@row = <>"", [Drug Test Result]@row = ""), "Pending Candidate Action", IF(AND([Date of Background Check]@row = <>"", [Background Check Result]@row = ""), "Pending Candidate Action", IF(AND([Date HR Director Approved in NeoG]@row = <>"", [MSPB Approved in NeoGov]@row = ""), "Pending SPB Action", IF(AND([Date Entered in MAGIC EC]@row = <>"", [Date Response Received from SPB]@row = ""), "Pending SPB Action", IF(AND([Date Response Received from SPB]@row = <>"", [SPB Response]@row = "Approved"), "Approved by SPB", IF([Date Cancelled]@row = <>"", "Cancelled"))), "Pending HR Action"))))))

Best Answer

  • Paul Newcome
    Paul Newcome Community Champion
    Answer โœ“

    Your closing parenthesis at the end are off. You should have 8 closing parenthesis to close out all IFs then comma then "output if error" then finally a single closing parenthesis.

    =IFERROR(IF(AND([Applicant Still Interested?]@row = "Yes", [All Docs Received from Candidate?]@row = ""), "Pending Candidate Action", IF(AND([Date Offer Letter Sent]@row = <>"", [Date Offer Letter Returned]@row = ""), "Pending Candidate Action", IF(AND([Date of Drug Test]@row = <>"", [Drug Test Result]@row = ""), "Pending Candidate Action", IF(AND([Date of Background Check]@row = <>"", [Background Check Result]@row = ""), "Pending Candidate Action", IF(AND([Date HR Director Approved in NeoG]@row = <>"", [MSPB Approved in NeoGov]@row = ""), "Pending SPB Action", IF(AND([Date Entered in MAGIC EC]@row = <>"", [Date Response Received from SPB]@row = ""), "Pending SPB Action", IF(AND([Date Response Received from SPB]@row = <>"", [SPB Response]@row = "Approved"), "Approved by SPB", IF([Date Cancelled]@row = <>"", "Cancelled")))))))), "Pending HR Action")

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!