Different approvals

Mario Rocco

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?

Heather Duff

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

Heather Duff

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

Mario Rocco

Thank you so much :)

Heather Duff

Happy to help!