Access a Sheet Summary field from a different sheet?

I have 2 sheets and want to be able to pull the value from a sheet summary field on Sheet A into a cell in the grid of Sheet B. Is there a way to directly reference this? I know how to cell link from a grid cell of Sheet A into Sheet B but not summary field.

I guess I could set up a helper column in Sheet A to pull in the Summary field into the grid, and reference this, but there are several Summary Fields in Sheet A I need to access in Sheet B and therefore wanted to avoid this 'workaround' if possible?

Thanks!!

Find more posts tagged with

Sheet Summary

Cell linking

Accepted answers

Ray Lindstrom

@Harvey E,

Unfortunately no, you cannot link a Sheet Summary field into another sheet's cell.

The only thing I'm aware of that you can use the Sheet Summary for, outside of use within the same sheet, is for creating reports.

All the best,

-Ray

All comments

Ray Lindstrom

@Harvey E,

Unfortunately no, you cannot link a Sheet Summary field into another sheet's cell.

The only thing I'm aware of that you can use the Sheet Summary for, outside of use within the same sheet, is for creating reports.

All the best,

-Ray

Harvey E

Thanks - a shame but I have a workaround I guess :)

JonHowse_GEHC

https://community.smartsheet.com/discussion/comment/362764#Comment_362764

Care to share your workaround…? 😬

Harvey E

https://community.smartsheet.com/discussion/comment/427650#Comment_427650

It was to add helper columns into the main sheet, unfortuantely.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.