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.

Why?

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...

Find more posts tagged with

Workspaces

Templates

Sheets

Formulas

Reports

Dashboards

Cell linking

Enhancement Request

Comments

JamesR

Dietrich,

Nice Idea and I would like that as well. I am currently trying to redesign one of my customers system to see if we an greatly reduce the overhead when we create new systems from the old.

The problem is that the sheets are unique by thier sheet ID rather than thier name and address(Path), that is why you can have sheets with the same name in the same folder(possibly not recommended).

Even in Excel and MS project are identified by Name and Address, any links are still absolute by thier original path.

I smartsheet can find a way to do this it would make both our lives easier.

James

Dietrich Koch

Thats it!

...and I'm absolutely sure it's not limited to our lives only ;-)

J. Craig Williams

This might be possible with the API using the celllink object.

When people start using words like "save a lot of time", that's when the API becomes a viable option to investigate ROI.

I haven't used the API for cell links, yet.

Craig

Dietrich Koch

No API no testing...

Best

Dietrich

JamesR

To add to this I believe a Paste Special ~ Transpose ~ Cell linking would be vert useful, and would save my customers a lot of time ad money. They often have data vertical in Months and want to be able to see it Horizontal in Month but to name one case.