Access a Sheet Summary field from a different sheet?

Harvey E
Harvey E ✭✭✭✭
in Formulas and Functions

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

Tags:
· Share on FacebookShare on Twitter

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,

    -Ray

    · Share on FacebookShare on Twitter

Answers

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!