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.

After linking cells between sheets, text disappears




I'm linking a cell between two sheets, and as soon as I create the link, the text in my cell disappears. The blue arrow indicating the linkage remains, but my text is gone. Any suggestions? Thank you!




  • Bob Lee
    Bob Lee ✭✭

    Which side is it disappearing on? The original sheet or the destination sheet? And are you only talking about 2 sheets where you're the user? Or is it disappearing for someone else?


    I believe info will disappear on a destination sheet if that user doesn't have shared rights to the original sheet. (Correct me if I'm wrong!)

  • Hi, Bob, thank you ... I am the owner of both sheets, and the text is disappearing on the destination side. Appreciate your help!

  • Francesco Puliafito

    Hi Ashley

    That's true, this happen also in between my sheets. I'm the owner and the text disappear from the destination side

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    That's odd.

    I was playing with linking half the day without problems.


    You can always email support@smartsheet.com



  • Travis
    Travis Employee

    Cell linking is not a two way sync. The source cell will populate the destination cell. If you are linking to a cell that contains data, the data will be removed and replaced with the data in the source cell. If the source cell is blank, the destination cell will be blank. 



  • JennS_
    JennS_ ✭✭✭

    I have an issue where I am linking to a sheet that I want to call "Change Orders". But when I select the sheet, and link to the cell, it changes the text to a date format. The column is set up to receive text or numbers. Is there a way to override this so it will display my text?

This discussion has been closed.