Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Is there a formula to check one checkbox for a row that will check other checkboxes throughout the s
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!
Comments
-
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. Β Β
-
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
