Can I add the totals of two or more Summary Fields to create a Grand Total Summary Field?

Answers

  • mcullen
    mcullen ✭✭✭✭✭✭
    edited 07/17/24

    Hi Tom! You sure can! Create the new Summary field. Use =SUM then click on the Summary fields you want counted (separated by commas). In the attached example it's counting the totals from 3 of my summary fields.

    SUM.PNG

    Michelle Cullen

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