Checkbox Formula

tkearney64301 ✭✭
edited 12/09/19 in Smartsheet Basics


I am wondering if anyone can help me with a formula build. I have two sheets that have checkbox columns and unique codes. What I want to do is on one sheet, when all checkboxes are checked that have a unique code in the row to automatically check a checkbox with the same code on a different sheet.

The accounting team is checking off invoices that they book all at once together when an asset is live. After checking all the boxes that have a unique code (xx123) [there could be ten of them], I would like the one checkbox in the master sheet that has the same (xx123) code to check automatically.

It seems very simple in theory, but I am unsure if an IF formula or VLookup will work or if I have to use AND within a formula. I tried many different versions and can not seem to get this figured out.