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

Vance Banks
edited 12/09/19 in Archived 2017 Posts

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!

Tags:

Comments

  • Brett Evans
    Brett Evans ✭✭✭✭✭✭
    edited 01/04/17

    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
    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

This discussion has been closed.