Check a Checkbox in one Sheet based on Checkbox Checked in another Sheet


I am trying to make checkboxes check in a multiple entry sheet when a checkbox in a core data sheet is checked.

The core data sheet holds employee information that is referenced in the multiple entry sheet. When the employee leaves I have a checkbox to check in a column 'Employee left business' and this column is replicated in the multiple entry sheet.

In the multiple entry sheet the employee can appear multiple times. If they leave I want to be able to check the box in the core data sheet and that action then automatically checks the boxes against that employees name in the multiple entry sheet.

Is this possible?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!