Help with checkbox formula

I am trying to make a checkbox on one sheet change depending on two criteria on a separate sheet. The first sheet has data showing drills submitted by location and date. My goal is to show completion on a monthly basis. ex: 10/12 sites completed drill in January

I need the other sheet to show completion for each location and each month.

If sheet a says "this location" and the month equals "1", checkbox should be marked.

This is the formula I have been trying and changing with no luck.

=IF({Site 3}, "RSOC-Fremont, California",{Month}@row,"1", 1, 0)



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!