Formula based on two column values

Hi, I am looking at doing a formula that looks at two columns and provides a # value based on what on the values that are in the two columns

This is a simple formula that I am looking at, but it will only go two levels down and then stops.

=IF([Urgency Rating]@row = 1, IF([Importance Rating]@row = 1, "1", IF([Urgency Rating]@row = 1, IF([Importance Rating]@row = 2, "2", IF([Urgency Rating]@row = 2, IF([Importance Rating]@row = 1, "3", IF([Urgency Rating]@row = 3, IF([Importance Rating]@row = 1, "4", IF([Urgency Rating]@row = 2, IF([Importance Rating]@row = 2, "5", IF([Urgency Rating]@row = 1, IF([Importance Rating]@row = 3, "6", IF([Urgency Rating]@row = 2, IF([Importance Rating]@row = 3, "7", IF([Urgency Rating]@row = 3, IF([Importance Rating]@row = 2, "8", IF([Urgency Rating]@row = 3, IF([Importance Rating]@row = 3, "9"))))))))))))))))))

Not sure what I am doing wrong?

I really appreciate any help you can provide.

Find more posts tagged with

Formulas

Accepted answers

All comments

Cathy Fraser

All good, worked it out went with Index and collect and used a help sheet

=INDEX(COLLECT({Priority Scale Master Range 1}, {Priority Scale Master Range 2}, [Urgency Rating]@row, {Priority Scale Master Range 3}, [Importance Rating]@row), 1)

Thought I would add the outcome, just incase it helps anyone else :-)

Genevieve P.

Hey @Cathy Fraser

I'm glad you figured it out! Thanks for posting your solution 🙂

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.