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.