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?

Find more posts tagged with

Accepted answers

Paul Newcome

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.

All comments

NameEqualsRyan

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.

Darla Brown

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.

Genevieve P.

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 🙂

Darla Brown

Here you go:

Paul Newcome

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.

Darla Brown

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

Paul Newcome

Happy to help. 👍️

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.