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.

View sheets side-by-side & be able to paste special (cell link)?

William Warsinski
William Warsinski โœญโœญ
edited 12/09/19 in Archived 2016 Posts

I've become a huge fan of cell linking as i have multiple spreadsheets that are 600+ tasks where i focus a lot of my time on about 10-30 cells so i like to link them to a new sheet to allow myself a sort of "Overview".

ย 

However this has become tedious because for each project i have to link 24 cells, so when i add a new project i have to either go through the cell link process or I can copy and then paste special (cell link) but both ways are time consuming because of how slow smart sheet is.

ย 

I've tried to open two seperate Smart sheet windows to try and copy/paste special but the paste special option is grayed out - i'm assuming this doesn't work across windows.

ย 

Is there a way to view two sheets at the same time in the same window?

Comments

  • Richard Rymill SBP
    Richard Rymill SBP โœญโœญโœญโœญโœญโœญ

    William

    if Smartsheet is very slow then you have too much going on in that sheet, so I suggest a redesign of how you are doing this process. It should be making your life easier, not harder, and i thing you are wrestling with the Symptom not the Cause.ย 

    ย 

    That said the princiople of cell limking the KPi's to a Portfolio or Master Roll Up sheet is a good one and very useful, its just how you go about creating those links.ย 

    ย 

    If it helps I can offer you a Free initial consultation where I can show you a simple way to do this that is not onerous.ย 

    ย 

    Let us know if you want to know more.ย 

    Hope that Helps

    RichardRย 

    ย 

This discussion has been closed.