Different approvals

Options

Hello All

I have a question, i have a sheet and approval workflow is triggered when a new item is created.

There are two approvals that are needed coming from two cell, and i want to see to overal Status of the approval. I am using formual: =IFERROR(IF(OR([BSS approval]@row = "Rejected" , [Function Head Decision]@row = "Rejected",), "Rejected", (IF(OR([BSS approval]@row = "Submitted" , [Function Head Decision]@row = "Submitted",), "Waiting For Approval", (IF(OR([BSS approval]@row = "Approved" , [Function Head Decision]@row = "Approved",), "Approved")),"")


But i always receive the error message #UNPARSEABLE


Can someone help me?

Best Answer

  • Heather Duff
    Heather Duff ✭✭✭✭✭✭
    Answer ✓
    Options

    Hi Mario,


    At first glance, I see what may be an issue with some parenthesis and commas. Try this:

    =IFERROR(IF(OR([BSS approval]@row = "Rejected" , [Function Head Decision]@row = "Rejected"), "Rejected", IF(OR([BSS approval]@row = "Submitted" , [Function Head Decision]@row = "Submitted"), "Waiting For Approval", IF(OR([BSS approval]@row = "Approved" , [Function Head Decision]@row = "Approved"), "Approved"))),"")

    Let me know if it works!


    Best,

    Heather

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!