How do I add a formula to update the status of a row based on 2 approvals?

Hi! I would like to incorporate a status update for a row based on COO and CEO approvals. The following formula is returning an unparseable error. Can someone help? Thanks so much.

=IF([COO APPROVAL]1=SUBMITTED),"YELLOW"),([COO APPROVAL]1=APPROVED),"GREEN"),([COO APPROVAL]1=DECLINED),"RED"),([CEO APPROVAL]1=SUBMITTED),"YELLOW"),([CEO APPROVAL]1=APPROVED),"GREEN"),([CEO APPROVAL]1=DECLINED),"RED")

Find more posts tagged with

Accepted answers

All comments

Dan W

So I assumed both Need to be approved to show green and if only one is denied you want Red

=IF(AND([Coo Approval]@row = "Approved", CEO@row = "Approved"), "Green", IF(OR([Coo Approval]@row = "Denied", CEO@row = "Denied"), "Red", "Yellow"))

This will make its stay yellow until both are Approved or if one is denied.

mrebottini

Yes, thank you so much! I will try it now!

mrebottini

I used the following, but the field is still showing an unparseable error.

=IF(AND([COO APPROVAL]1 = "Approved", ([CEO APPROVAL]1 = "Approved"), "Green", IF(OR([COO APPROVAL]1 = "DECLINED", CEO APPROVAL]1 = "DECLINED"), "Red", "Yellow"))

Dan W

If you need all the cells to reference the first cell in Ceo, and Coo

use this

=IF(AND([coo approval]1 = "Approved", [coo approval]1 = "Approved"), "Green", IF(OR([ceo approval]1 = "Declined", [ceo approval]1 = "Declined"), "Red", "Yellow"))

You were missing some [

mrebottini

Thank you so much! It worked!!

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.