IF auto generated number in Row matches anywhere in 2 sheet columns then checkbox checked

Paul Newcome

Ah. Ok. No worries. I wrote the formula to look for "Declined" in a single cell as opposed to a range.

 

Try this one...

 

=IF(OR(IFERROR(MATCH([Lead ID]1, {Construction/Enhancements Estimate Workshe Range 1}, 0), 0) > 0, IFERROR(MATCH([Lead ID]1, {Maintenance Estimate Worksheet Range 1}, 0), 0) > 0, AND(ISDATE([Connected with on:]@row), FIND("Declined", JOIN([Dave approval]@row:[Wes Shelley approval]@row)) > 0)), 1)

Wes S

Success! Thanks Paul. 

Paul Newcome

Happy to help!