Formula to check a box if it meets multiple criteria in another sheet



I have two sheets:

Sheet A: ID#, Date, and a checkbox

Sheet B: ID#, Date

Can someone please tell me what should the formula be if I want to Sheet A checkbox to check if Sheet A's ID# and Date match with Sheet B's ID# and Date.

I tried a few different formula and it seems like it doesn't work:

=IF(AND(MATCH([ID #]@row, {Health Care Survey ID #}), MATCH(Date@row, {Health Care Survey Date}, 0)), 1)

=IF(INDEX(COLLECT({Health Care Survey ID #}, {Health Care Survey People #}, [ID #]@row, {Health Care Survey Date}, Date@row), 1), 1)

Thank you!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!