Sign in to submit new ideas and vote
Get Started

Transpose cell links from a vertical production schedule to a row/grid sheet

We have hundreds of production schedules for individual projects, each of which share milestone dates that are uniformly named. The milestone dates vary per project and we want to create a sheet that has a row for each product and columns for the milestone dates. This will enable project tracking on a global level.

The problem is that the cell link function in sheets doesn't transpose vertical data to horizontal rows.

As a result, we have to write code that transposes the links and matches the name in the production schedule to the right column name.

Seems like there could be a function within a sheet to allow cell links to come in from a vertical schedule. Thsi woudl really unlock the power of what Smartsheet can do.

2 votes

Idea Submitted · Last Updated