Combined Multiple IF CONTAINS Functions

A. Rose

Hi,

I have the following formula

=IF(CONTAINS([Column A]@row, {Sheet A Range 1}), "Sheet A", IF(CONTAINS([Column A]@row, {Sheet B Range 1}), "Sheet B")

Now I want to add if both sheets contain [Column A]@row, result: "Sheets A and B",

How do I add this last part in addition to my current formula?

Any help is appreciated,

Thank you,

Find more posts tagged with

Formulas

functionality

Accepted answers

Ryan Sides

Hi @A Rose You can add another IF statement to the front of your formula and use the AND operator to check that both ranges contain Column A's value.

=IF(AND(CONTAINS([Column A]@row, {Sheet A Range 1}), CONTAINS([Column A]@row, {Sheet B Range 1})), "Sheets A and B", IF(CONTAINS([Column A]@row, {Sheet A Range 1}), "Sheet A", IF(CONTAINS([Column A]@row, {Sheet B Range 1}), "Sheet B"))

Does that work for ya?

All comments

Ryan Sides

Hi @A Rose You can add another IF statement to the front of your formula and use the AND operator to check that both ranges contain Column A's value.

Does that work for ya?

A. Rose

Thank you so much @Ryan Sides!

that was very helpful! 😃

Ryan Sides

@A Rose You're welcome! Happy to help.

Sarita Sah

Hi,

Can someone help me with a formula to display "Yes" and "No" for multiple categories available in a column. I want to display "Yes" for Defect, Escalations, SLA Miss & CRM Issue. Display "No" for Admin Request, Project and Child ticket.

This is the formula I am trying:

=IF(OR(CONTAINS("Defect", [Issue Type]@row, CONTAINS("SLA Miss", [Issue Type]@row, CONTAINS("CRM Issue", [Issue Type]@row, CONTAINS("Escalations", [Issue Type]@row)), "Yes", "No"))))

Andrée Starå

Hi @Sarita Sah

I hope you're well and safe!

Try something like this.

=IF(OR([Issue Type]@row = "Defect", [Issue Type]@row = "SLA Miss", [Issue Type]@row = "CRM Issue"), "Yes", IF([Issue Type]@row = "Escalations", "No"))

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Sarita Sah

Thanks a lot, it worked :)

Andrée Starå

@Sarita Sah

Excellent!

Happy to help!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

A. Rose

Hi,

I have a similar formula I need help with please,

=IF(AND(CONTAINS([Client Name]@row, {Sheet A Range 1}), IF({Sheet A Range 2}, >=TODAY(-7))), "Match")

Any idea how to correct this #INVALID DATA TYPE?

Thank you!

A. Rose

Posting this as a new question since this is an old conversation.

here.

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.