Use relative links between sheets restricted to a single workspace

Hi,

I have 1 sheet (sheet1) that takes a value into another one (sheet2). I would like the link between both to be relative and restricted to a single workspace so when I copy both in a new workspace (w2), they remain linked to each other but can't access original workspace (w1). Result would be sheet1w2 linked to sheet2w2

Curently, it is doing sheet1w2 linked to sheet2w1

Thanks a lot

Answers

  • SSFeatures
    SSFeatures ✭✭✭✭✭

    Hi @B_Bernard_D,

    If you are trying to copy each sheet individually and move them into a new workspace then the links will be absolute instead of relative.

    However, if you duplicate the entire workspace or folder then the new copied sheets will be relative to each other.

    Is it possible for you to put sheet1 and sheet2 into their own workspace, and then copy that workspace whenever you want to copy the sheets?

    Best!

    SSFeatures - The browser extension that adds more features into SmartSheet.

    • Automatic sorting, sorting with filters, saving sort settings
    • Spell checking
    • Report PDF generator that supports grouped and summarized reports

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!