Check box if multiple conditions are met across 2 sheets

Options

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

#INVALID DATA TYPE

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

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!