Combing IF AND CONTAINS question
Hi, I have two sheets that I am working with.
Both Sheets have a "Sales Order" Column. The Master Sheet has additional letters typed into the Sales Order Column, while the second sheet is missing those letters. The Master Sheet also has a checkbox.
For the Second Sheet, I am trying to get this checkbox working as well, except I am using the CONTAINS formula.
I have been doing:
=IF(AND(CONTAINS(SO@row, {Sales Order}), {Clonal?} = 1), 1)
My thought for the second sheet is if the Sales Order column contains the same text that is in the Master Sheet Column, and the Checkbox in the Master Sheet is checked, then the second sheet Sales Order row will also be checked. I can't figure out what I am doing wrong with my formula. Could someone please help? Thanks!!!
Best Answer
-
Ah never mind I figured it out with:
=COUNTIFS({Sales Order}, CONTAINS(SO@row, @cell), {Clonal?}, =1)
Answers
-
Ah never mind I figured it out with:
=COUNTIFS({Sales Order}, CONTAINS(SO@row, @cell), {Clonal?}, =1)
-
Thanks for sharing your solution with us! 🙂
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 430 Global Discussions
- 150 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 500 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!