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.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
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 🙂
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
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.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
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. 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!