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 in the Same Sheet

Blair blair9398
Blair blair9398 ✭✭
edited 12/09/19 in Archived 2016 Posts

For large sheets, is there a way to link from rows to other rows within the same sheet. Β For example, I have developed a lirbary of sorts with files that fall into different categories. Β There are several categories and lots of files in each category. Β I was thinking I could have each of the categories at the top of the sheet and link to where they are within the sheet. Β Anyhelp is appreciated.

Comments

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    Blair,

    Β 

    You can equate or pull values from one cell to another

    Β 

    =[columnname]23

    Β 

    for row 23 and the columnname column.

    Β 

    You can use that in more complicated formulas

    Β 

    =IF([columnname]23="Bob","Will be late","Will be early")

    Β 

    Here's the help article on functions

    Β 

    https://help.smartsheet.com/articles/775363-using-formulas

    Β 

    Lots of useful info there.

    Β 

    Hope that helps.

    Β 

    Craig

    Β 

    Β 

  • Charles DESCOTES
    Charles DESCOTES ✭✭
    edited 12/02/16

    I am not sure to understand you well.

    Are all data in one category grouped together? Maybe as children under the aprent holding the category name?

    Β 

    . In this case, a "collapse all" action (only available in the header of the primary column) will provide a summarized view than can help you flying to the right category.

    . However you said you have many categories and this trouble could actually be your solution: make one smartsheet per category. Then create a brand new smartsheet that will actually become yourΒ turning platform: it will only hold category names with hyperlinks to the related category-smartsheet.

    . When you need to consolidate data from difeerent smartsheets, i.e. gathering data from all category for instance. Work with the report engine. Easy to use, seeΒ https://help.smartsheet.com/articles/522214-creating-reportsΒ 

  • Blair blair9398
    Blair blair9398 ✭✭

    I think I have confused people - or am not understanding your suggestions. Β Below is a screen shot Β of the sections/buckets. Β Underneath each section is a bunch of different files all linked elsewhere. Β Since it has become a big sheet and continues to grow I am wondering if at the top of the sheet I can list all the different categories on the sheet and link to them - all within the same sheet. Β Here is the screen shot example.

    Β 

    Buckets.jpeg

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    Link them where?

    Β 

    I'm still not getting it.

    Β 

    Craig

  • Blair blair9398
    Blair blair9398 ✭✭

    Sorry - At the top of the sheet I want to have a row with the name of each section. Β So think of it like a table of contents. Β At the top of the sheet is the different sections that are linked to lower in the sheet where the section is. Β Otherwise there is a lot of scrolling. That is linking - going from a row at the top of the sheet to a row lower in the sheet.

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    Ah ... nope.

    Β 

    Have your tried indenting the items under the sections and collapsing them until they are needed?

    Unfortunately, there is no keyboard shortcut for expand / collapse all.

    Β 

    Here's another feature that might help ease the pain:Β 

    Ctrl+Shift+F will bring up the Search dialog defaulting to the Current Sheet.

    Using your table of contents, at least you'd know what to search for.

    Β 

    Note to Smartsheet: This shortcut is not listed here:

    https://help.smartsheet.com/articles/522200-keyboard-shortcuts

    Β 

    Craig

    Β 

  • Blair blair9398
    Blair blair9398 ✭✭
    edited 12/03/16

    Great suggestions. Β Thanks.

This discussion has been closed.