Cell linking a sheet to a summary field in another sheet

rjw
rjw ✭✭
edited 01/11/21 in Smartsheet Basics

Does anybody know if there's a way to cross-sheet cell link (1 sheet to another sheet) to a field defined in the summary section of a sheet? I looked everywhere in the "link from other sheet" pop up screen and couldn't find anything.

Thanks,

Rich

Best Answer

Answers

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Answer ✓

    Hi Rich,

    I don't think you can reference a summary field across sheets. Summary sheet help info is below. Summary references have to be in same sheet.

    https://help.smartsheet.com/learning-track/smartsheet-intermediate/sheet-summary

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi @rjw

    A workaround could be to use a cross-sheet formula to collect the information.

    Would that work/help?

    I hope that helps!

    Be safe and have a fantastic weekend!

    Best,

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

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

    SMARTSHEET EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • Newman33
    Newman33 ✭✭✭

    [email protected]

    I'd like to do the opposite here - Can I reference the data in another sheet to fill in a summary field?

    Example: I have a Master sheet with Job codes in a primary column; each job code is hyperlinked to an individual task sheet pertinent to that job. I'd like a summary field of the individual project page to pull in the job code from the master, as well as the fields: Street Address #1 , City , State , Postal Code , Superintendent Contact , Superintendent Phone ETC ETC.

    so that's my dilemma. Can you can help me?

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi @Newman33

    I hope you're well and safe!

    Yes, you can.

    You'd 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, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • Newman33
    Newman33 ✭✭✭

    Hello @Andrée Starå

    So that's a relief to know it's possible. Can you help me fix my formula? I keep getting #unparseable.

    Currently, the layout is such: Master sheet with Job Codes in Column 2. in that column, each job code is hyperlinked to an individual task sheet. Because the task sheet does not recognize it's own sheet name as a value, I've elected to try and pull in the Job Code from the Master sheet to a summary field for further use.

    in a summary field, I've written the following: =VLOOKUP([NewCo ID]@row, {DBC Master - Test Range}, 2, false)

    [NewCo ID] is the name of the job code column

    {DBC Master - Test Range} is the name of the range I've selected, that being the first two columns from the master sheet, working from the left.

    I've selected the second column, which is the NewCo ID column mentioned above

    and I've asked for an exact match, with "False"

    What am I doing wrong?

  • Newman33
    Newman33 ✭✭✭

    [email protected]

    Did you get a chance to review my follow up question above? Please let me know if there is any additional information I can provide to better help in getting this question answered.

  • Newman33
    Newman33 ✭✭✭

    @Andrée Starå


    Hello - Can you please advise on this question? I'm trying to complete some pretty imperative items for my data management.

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    @Newman33

    I'd be happy to take a quick look.

    Can you maybe share the sheet(s)/copies of the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])

    SMARTSHEET EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.