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.
Linking Cells from a Vertical Orientation to a Horizontal Orientation
Hello everyone,
I am creating a Project Pipeline which consists of many linked cells from many different individual project sheets. The individual project sheets are designed in a way that the information I am accessing is vertical. But in my pipeline, these same values need to be horizontally displayed. I need to link around 20 cells from each project sheet, and it is tedious and a waste of time to individually link each cell from many different projects.
Is there a way I can link these cells and transpose them at the same time, so that I only have to copy-paste a single time from each project sheet?
Any help is greatly appreciated. Thank you!
Max
Comments
-
Hi Max,
My suggestion would be to link it to another section/column on the project sheet and then link that area to the project pipeline.
Would that work for you?!
I hope this helps you!
Best,
Andrée
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
I wrote this today to document a way I have solved this:
http://ronin-global.com/2017/11/29/smartsheet-transposing-project-schedule/
Craig
-
What if it isn't dates that you are trying to transpose?
For example, I have a request form w/ 4 entries that refer back to columns that need to be filled in:
Column 1 Date Requested
Column 2 Requester
Column 3 Project Type
Column 4 Product
As the form is entered these results are filled in 1 Sheet housed in our Workspaces folder.
We then have a workspace folder that is project specific and I would like to see these 4 columns transposed and entered as "task" results. For Example:
Column 1 - Task
Row 1 - Date Requested
Row 2 - Requester
Row 3 - Project Type
Row 4 - Product
Then I would have my project timeline listed below w/ hierarchy & predecessors.
Row 5 - Contact AM
Row 6 - Prepare internal documentation
etc.
Categories
- All Categories
- 14 Welcome to the Community
- 10.7K Get Help
- 63 Global Discussions
- 68 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
