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?


Best Answer

  • Ray Lindstrom
    Ray Lindstrom ✭✭✭✭✭✭
    Answer ✓

    @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,



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!