Check box if multiple conditions are met across 2 sheets


Good morning,

I have 2 sheets

Sheet A: Job #, complete(Checkbox)

Sheet B: Job #, Reason, complete(Checkbox)

The goal is to have a formula that will check the box in the complete column on Sheet A if the Job # matches between the 2 sheets, the Reason column on Sheet B is "Screens", and the complete column on Sheet B is checked.

This is my current formula

=IF(AND(MATCH([Job #]@row, {Sheet A Job #}), {Sheet B Reason} = "Screens", {Sheet B Complete} = 1), 1)

This is the result I'm getting


I feel like I'm missing something obvious, or maybe there is a completely different way to do this. Any help is appreciated, Thanks!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!