linked sheet - Switch from column to row

Anne Toronto

Dear users, i'm looking for a function to link 2 sheets with a special link to move some of the column in my sheet 1 becoming a row in my sheet 2. Purpose : I would like to use smartsheet to record my process change. one sheet (#1) to capture the assessment of my change and the list of task that needs to be done and another sheet ( #2) to list the tasks and check on their advancement. My 2 sheets will be linked by a unique change number. Thanks!

Andrée Starå

Hi @Anne Toronto

I hope you're well and safe!

You could use cross-sheet formulas combined with either a VLOOKUP or INDEX/MATCH structure to connect the sheets, and when you update the source sheet, it will reflect on the destination sheet.

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!