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

Sunil Sharma

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.