Linking rows

Fernando

I would like to know how can I do to link 2 or more rows (primary and secondares) in such a way that when I click on the check box of the primary row, it checks in the secondary boxes automatically

Shaine Greenwood

Hi Fernando,

If you're wanting to do this on the same sheet, place a formula in your child row/secondary row cells, for example:

=[Completed]1

More information on how formulas work in Smartsheet can be found in our help article: https://help.smartsheet.com/articles/2476171-create-and-edit-formulas-in-smartsheet

Otherwise, if you're wanting a cell on a different sheet to be checked automatically when you check a box on your source sheet, you'll want to use the Cell Linking functionality. Details on this are available here: https://help.smartsheet.com/articles/861579-cell-linking 

mahendran.p36056

Hi @shaine,

Can you please share more details about linking two rows in smart sheet? I tried =[Completed]1 but not works for me

Andrée Starå

Hi Mahendran,

The first checkbox [Completed]1 (located on the first row in the column named "Completed")

The second checkbox located elsewhere on the sheet where you put the formula =[Completed]1 will link the value in the first checkbox to the second so if the first is checked it will check the second also.

I hope this helps you!

Best,

Andrée Starå - Workflow Consultant @ Get Done