Different approvals

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?

Find more posts tagged with

Accepted answers

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

All comments

Heather Duff

Hi Mario,

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

Let me know if it works!

Best,

Heather

Mario Rocco

Thank you so much :)

Heather Duff

Happy to help!

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.