Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
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
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
Hi @shaine,
Can you please share more details about linking two rows in smart sheet? I tried =[Completed]1 but not works for me
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
