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.
Enhancement Request: relative addressing for cell linking in sheets, reports and sights
It would be great to be able to use relative addressing in cell linking between sheets and links in reports and sights instead of the fixed linking as currently implemented in Smartsheet.
We use Smartsheet for project management and have a set up a standard workspace which contains set of sheets/reports and sights intensely linked to each other. For every new project we make a copy of this template set ("save as new"). The sheets always have the same name and structure.
Now, if we have to change a sheet within this template set and copy it to all existing workspaces we have to go through every (!) sheet, report and sight to correct the links to the new sheet, because all the links currently refer to a specific cell (or range of cells) in a specific sheet.
If we could use relative links in the template workspace, we could just copy the new sheet to every existing workspace and the links still would work.
It would save a lot of time in the administration of the workspaces for all the existing projects...