Check a box on one sheet based on a checked box of another
Hi,
I'm stumped and have tried several things based on other posts with still no resolution.
My source sheet has 3 columns:
Booking Post As (text), Client Email (contact), and Declined Offer (checkbox).
My target sheet is the checkbox column "Declined Credit App?"
I need to look at source sheet, match Booking Post As column with the Booking Post As @row and check the box on the target sheet IF the box is checked on the source.
I've tried Index/Match but I don't want it to return #NO MATCH. I've tried the COUNTIFS solution, but it returns the text "Yes" or "No" instead of checkbox.
Any ideas?
Darla Brown
What you meditate on, you empower!
Overachiever - Core Product Certified - Mobilizer - EAP
Best Answer
-
Double check your [Booking Post As] column name. It looks like it is not recognizing it. Instead fo typing it in when typing the formula, click on the cell in that column.
Answers
-
Hi Darla,
Try the following formula
=IFERROR(INDEX({SOURCE SHEET Declined Credit App}, MATCH([Booking Post As]@row, {SOURCE SHEET Booking Post As}, 0)), "")
Make sure both the "Declined Credit App" column on both the source sheet and the target sheet are the same column type (checkbox).
The added IFERROR formula will remove the #NO MATCH error.
-
Sorry for the delayed response. I was out of the country.
I tried this and received the Unparsable error. Both columns are checkbox type. This was one of the formulas I tried originally which left me stumped.
Darla Brown
What you meditate on, you empower!
Overachiever - Core Product Certified - Mobilizer - EAP
-
Hi @Darla Brown
Would you be able to post a screen capture of the formula open in a cell? Unparseable can sometimes be from an extra comma or parentheses 🙂
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Here you go:
Darla Brown
What you meditate on, you empower!
Overachiever - Core Product Certified - Mobilizer - EAP
-
Double check your [Booking Post As] column name. It looks like it is not recognizing it. Instead fo typing it in when typing the formula, click on the cell in that column.
-
That's it! Someone changed the name of the column while I was working on the formula. I didn't notice it wasn't recognizing it.
As always, thanks @Paul Newcome
Darla Brown
What you meditate on, you empower!
Overachiever - Core Product Certified - Mobilizer - EAP
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!