Circular Linking within Smartsheet

Options

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.

Answers

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Options

    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


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!