Options
rjw ✭✭
01/11/21 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
Tags:
- Sheet Summary
0 · Share on FacebookShare on Twitter
Mark Cronk ✭✭✭✭✭✭
01/11/21 Answer ✓
Options
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.
1 · Share on FacebookShare on Twitter
Answers
Mark Cronk ✭✭✭✭✭✭
01/11/21 Answer ✓
Options
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.
1 · Share on FacebookShare on Twitter
Andrée Starå ✭✭✭✭✭✭
01/16/21
Options
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: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.
0 · Share on FacebookShare on Twitter
Newman33 ✭✭✭
09/20/22
Options
andree@workbold.com
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?
0 · Share on FacebookShare on Twitter
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: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.
1 · Share on FacebookShare on Twitter
Newman33 ✭✭✭
09/20/22
Options
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?
0 · Share on FacebookShare on Twitter
Newman33 ✭✭✭
09/20/22
Options
andree@workbold.com
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.
0 · Share on FacebookShare on Twitter
Newman33 ✭✭✭
09/21/22
Options
@Andrée Starå
Hello - Can you please advise on this question? I'm trying to complete some pretty imperative items for my data management.
0 · Share on FacebookShare on Twitter
Andrée Starå ✭✭✭✭✭✭
09/21/22
Options
@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,andree@workbold.com)
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.
0 · Share on FacebookShare on Twitter
Adam Messersmith ✭✭
04/22/24
Options
@Newman33
I am way late to the party, but for reference to future users I have been able to do Vlookups and Index/Match from a Summary Cell to return a value from another sheet. In my case it was pulling actual hours charged to date for a particular charge code.
Your Vlookup formula is referencing the lookup value "@Row" which is the wrong format for a summary cell. I think of a Summary slide out as it's own island of info, so the lookup value has to be singular, as it can only return one result, not show a different result for each row in the sheet.
I suggest changing your formula from =VLOOKUP([NewCo ID]@row... to =VLOOKUP([NewCo ID]#... as long as [NewCo ID] is a field in the summary cell pane. The # sign tells the system that it is a summary cell.
This reference can also be used when you want a summary cell (i.e. effort name, or manager of the sheet) to appear on every row when the rows are in a report. You just need to make new column, reference the field name with # sign, and convert to column formula. I then hide the column so its selectable from report builder but not visible in sheet to confuse users. This is helpful when you want to know what a row belongs to (sheet name, parent section name, etc.).
0 · Share on FacebookShare on Twitter
'); $(this).css('min-height', '20px'); const searchBoxRoot = document.getElementById("searchbox"+index); Coveo.initSearchbox( searchBoxRoot, "https://search.smartsheet.com/community/" ); }); $('#titleBar .CoveoSearchbox').hide(); $('.coveoSearchButton').on("click",function(){ $('#titleBar .CoveoSearchbox').toggle(); }); // ====== Front Page Search Box ====== $('#Form_search').remove(); var boxes = ["#search-0", "#search-1", "#search-2", "#search-3", "#search-4", "#search-5"]; console.log("PT: Before search box replacement"); $(boxes).each(function(i, val) { // ====== Front Page Search Box ====== $(val).each(function( index ) { console.log(this); $('#searchbox' + i).remove(); $(this).find('form').remove(); $(this).addClass('fpsearchbox'); $(this).attr('id', 'fpsearchbox' + index); $(this).append('
'); $(this).css('min-height', '20px'); const searchBoxRoot = document.getElementById("fpsearchbox"+index); var action = "https://search.smartsheet.com/community/"; if ( $('body').hasClass('Categories')) { var category=$('h1.heading-1').text(); if (category === "Smartsheet Product Feedback & Ideas") { category = encodeURIComponent(category); Coveo.$(searchBoxRoot).on('buildingQuery', function(e, args) { args.queryBuilder.advancedExpression.addFieldExpression('@communitycategory', '==', [category]); }); action = action + '#&f:@communitycategory=['+category+']'; } } Coveo.initSearchbox( searchBoxRoot, action ); }); }); });
Categories
- All Categories
- 14 Welcome to the Community
- 59K Get Help
- 85 Global Discussions
- 87 Industry Talk
- 396 Announcements
- 11 Community Corner Newsletter
- 68 Brandfolder
- 120 Just for fun
- 41 Community Job Board
- 22 Member Spotlight
- 1 SmartStories
- 235 Events
- 7.3K Forum Archives
Watch video
