Adding Max Sums in a Report

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



  • Genevieve P.
    Genevieve P. Employee Admin

    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.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!