Enable Cross Sheet References to work with Sheet Summary (2024)

Sign in to submit new ideas and vote

Get Started

Options

James Fischer ✭✭✭

10/12/23 edited 05/16/24 in

I check with Smartsheet to see if this was possible and it is not. I've submitted an enhancement request. Support suggested I post the idea to the Community so folks could "like/vote for" the idea.

If by chance someone knows how to do this...reference sheet summary values from another grid, or between sheet summaries on different grids, or from a sheet summary to a grid, then please let me know.

Thanks!

Jim

Tags:

Sheet Summary

15Share on FacebookShare on Twitter

15 votes

Idea Submitted ·Last Updated 10/12/23

Michelle Choate 2 ✭✭✭✭✭
10/12/23

Options
Yes! I would love to be able to use cross sheet references in Sheet Summaries! There are many calculations that I have to create a separate Metrics sheet for when using sheet summary would be so much simpler!
0 · Share on FacebookShare on Twitter
Carson Penticuff ✭✭✭✭✭✭
10/13/23

Options
This would eliminate so many workaround I am currently utilizing. Definitely needed.
0 · Share on FacebookShare on Twitter
Adrian Mandile CHESS ✭✭✭✭✭
10/24/23

Options
Hi @James Fischer,
The main 'workaround' for this is within the 'source' sheet with the Summary Sheet field, create a hidden helper column that simply references the Sheet Summary field as an "=[Summary Field]#" column formula. Then in the destination sheet, create a cross-sheet reference to the first row of the source sheet hidden helper column.

0 · Share on FacebookShare on Twitter
See Also
Sheet Summary | Smartsheet Learning Center

James Fischer ✭✭✭
10/24/23

Options
That is certainly roundabout, but I can see how it would work. Was hoping for something a bit more "direct", but this would certainly work. Thanks for the suggestion! ~ Jim
0 · Share on FacebookShare on Twitter
Pauline J ✭✭✭✭✭
05/07/24

Options
I just hit this wall … building dashboards and calculating metrics, trying to keep sheets "clean" so that rows are complete records without additional columns that don't belong in the record. Would LOVE the ability to create a formula in Sheet A that pulls the Sheet Summary field calculations in Sheet B.
I'm glad for the suggestion and confirmation that there is not a way to do this at this time.
Pauline

1 · Share on FacebookShare on Twitter
SahinOzgur ✭
05/15/24

Options
We are just able to refer from other sheet cells, when we click to reference from other sheet, there would be an option like cell/sheet reference or summary field reference from other sheets,
we are able to use summary field reports but we can't use formulas on the reports. with this enhancement we will be capable to use formulas on sheet which is collected summary fields from other sheets

1 · Share on FacebookShare on Twitter
Tim C ✭✭✭✭✭
05/15/24 edited 05/15/24

Options
here is a bit Of a work around Rich from Prodactive devised. Might work in your case!
https://youtu.be/FFSU4lNIqAQ?si=XcoMn2cqUwbvipv5

0 · Share on FacebookShare on Twitter
SahinOzgur ✭
05/15/24 edited 05/15/24

Options
https://community.smartsheet.com/discussion/comment/436000#Comment_436000
thank you but that is not what I ment. of course, you can use "references another sheet" in summary field. but you can't bring a summary field from another sheet to your sheet. when you transfer your summary field value to the column or cell in your sheet, in that case you can transfer that value to another sheet. But it is not efficient.

1 · Share on FacebookShare on Twitter
Tim C ✭✭✭✭✭
05/15/24

Options
AAh Darn! Definitely a great one for s product enhancement, I would love that capability as well 😀
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 ); }); }); });