Circular Linking within Smartsheet

Shauna Brotz

Can anyone tell me how to create a link in one cell on a sheet1 to a cell in sheet2 (I know how to do this part), but then allow the same cell in Sheet2 to populate sheet1 if a change has been made in sheet two? In other words, I want one cell to be changed in the opposite sheet if someone in one of the sheets updates the cell it populates the cell on the opposite sheet.

Mark Cronk

Hi @Shauna Brotz ,

What you're asking can't be done. Are reports a possible solution for you? Using reports allows different people to have different views but share edits. Reports can pull data from multiple sheets. Changes made to the report change the source sheet.

Mark