Nested IFs and various ranges changing other column cell

Hi team - I have a column called Risk Reduction &/or Opportunity Enablement that has specific numbers in a drop down [1, 2, 3, 5, 8, 13, or 20].

Second column is called Risk Reduction &/or Opportunity Enablement Size and has Small, Medium, Large as drop down options.

What I need is if the Risk Reduction &/or Opportunity Enablement selection is 1, 2 or 3 then Small in the second column; if 5 or 8 then Medium and if 13 or 20 then Large.

Any best practices to make that happen?

Thanks.

Find more posts tagged with

Accepted answers

All comments

Heather Duff

Hi @jmo ,

This won't be pretty, but try this:

=if(OR([Risk Reduction &/or Opportunity Enablement]@row=1,[Risk Reduction &/or Opportunity Enablement]@row=2,[Risk Reduction &/or Opportunity Enablement]@row=3,"Small",if(OR([Risk Reduction &/or Opportunity Enablement]@row=5,[Risk Reduction &/or Opportunity Enablement]@row=8,"Medium",if(OR([Risk Reduction &/or Opportunity Enablement]@row=13,[Risk Reduction &/or Opportunity Enablement]@row=20,"Large","")))

Let me know if it works!

Best,

Heather

jmo

@Heather D - when I copy/paste your formula I get the following:

#INCORRECT ARGUMENT SET

Heather Duff

@jmo My apologies - I'm missing some parenthesis. Let me know if the below formula works for you.

=if(OR([Risk Reduction &/or Opportunity Enablement]@row=1,[Risk Reduction &/or Opportunity Enablement]@row=2,[Risk Reduction &/or Opportunity Enablement]@row=3),"Small",if(OR([Risk Reduction &/or Opportunity Enablement]@row=5,[Risk Reduction &/or Opportunity Enablement]@row=8),"Medium",if(OR([Risk Reduction &/or Opportunity Enablement]@row=13,[Risk Reduction &/or Opportunity Enablement]@row=20),"Large","")))

jmo

That's the stuff, @Heather D !!!!

Thanks for your speedy reply!

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.