Help with addition to formula

Hi, i need to make an addition to the below formula please.

I need to add if column type is issue and impact score is 4 - gray, 3 - red, 2, amber and 1 green

=IF(AND(Type@row = "Risk", ([Impact Score]@row * [Likelihood Score]@row ) >= 20), "Gray", IF(AND(Type@row = "Risk", ([Impact Score]@row * [Likelihood Score]@row ) >= 14), "Red", IF(AND(Type@row = "Risk", ([Impact Score]@row * [Likelihood Score]@row ) >= 8), "Yellow", IF(Type@row = "Risk", "Green", ""))))

Find more posts tagged with

Formulas

IF(AND

Accepted answers

All comments

jjg279

Hey @Karl86 , is this what you are after:

=IF(AND(Type@row = "Issue", [Impact Score]@row = 4), "Gray", IF(AND(Type@row = "Issue", [Impact Score]@row = 3), "Red", IF(AND(Type@row = "Issue", [Impact Score]@row = 2), "Yellow", IF(Type@row = "Issue", "Green", IF(AND(Type@row = "Risk", ([Impact Score]@row * [Likelihood Score]@row ) >= 20), "Gray", IF(AND(Type@row = "Risk", ([Impact Score]@row * [Likelihood Score]@row ) >= 14), "Red", IF(AND(Type@row = "Risk", ([Impact Score]@row * [Likelihood Score]@row ) >= 8), "Yellow", IF(Type@row = "Risk", "Green", ""))))))))

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