Adding Max Sums in a Report

Options
Jason800
Jason800 ✭
in Formulas and Functions

Is it possible to get a total at top of the sheets max sums added together in a report?

image.png


Tags:
· Share on FacebookShare on Twitter

Answers

  • Genevieve P.
    Genevieve P. Employee Admin
    Options

    Hi @Jason800

    Currently the Summary feature in Reports can only complete one action for the column, in this case displaying the MAX number. There isn't a way to Sum all the Max summaries below, but please provide your feedback to the Product team through this form, here!

    As an alternative, you could build a Metric Sheet with cross-sheet formulas to find the Max for each group, then have a SUM formula at the top. If you'd like to go down that route I'd be happy to help build the formulas.

    Cheers,

    Genevieve

    · Share on FacebookShare on Twitter

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!