Check a box on one sheet based on a checked box of another



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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!