Combine 2 IF CONTAINS formulas searching 2 ranges

Needing some help.

I am running 2 sheets a master project sheet and an audit sheet populated off a form.

I have an IF CONTAINS formula that works to check a checkbox on the master project sheet when an audit is populated in the audit sheet with a unique number. =IF(CONTAINS(UN@row, {Audit Template Range 1}), 1, 0)

I want to in the master sheet check another check box when 2 criteria in that audit sheet are met on the same site. The unique number and review required. I tried the below and it check the checkbox but the second criteria does match Review Required

=IF(AND(CONTAINS(UN@row, {Audit Template Range 1}), CONTAINS("Review Required", {Audit Template Range 2})), 1, 0)

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!