Is there a formula to check one checkbox for a row that will check other checkboxes throughout the s

Vance Banks

I am creating a sheet that contains the same item on multiple rows and need a way to link the checkboxes, so if one is checked all are checked. Please help!

Brett Evans

The simplest way I could think of achieving this is with cell linking.    There would be one cell that could be checked by the user and the other cells would read that cell.  this approach would not work if you wanted users to choose any o the linked cells.

 

You could acheive this with the MATCH and/or the LOOKUP formula, possibly, depending on your the specifics of your sheet.   

J. Craig Williams

Vance,

 

There are no formulas that will update another cell.

In addition, all cells with a formulas can be overwritten by the user which results in the formula being lost. Look at locking rows/columns for some ways to prevent this - in some cases.

 

You'll need to look at your work flow and determine if you can modify that to allow Smartsheet to give you the functionality you are looking for.

 

Craig