Access a Sheet Summary field from a different sheet?

Harvey E

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!!

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

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.