My SUM formula yields a maximum of 56, but I want to cap it at 40.

I have a form where various answers to questions will give the applicant 2 points. If the applicant answers all questions, they would get 56, however, we are capping it at 40. How can I stop the counting after 40?

Thank you!

Best Answer

  • steven.nienaber105336
    steven.nienaber105336 ✭✭✭✭✭
    Answer ✓

    Many thanks for your response! I actually found a way to do this in addition to the way you cited. Here's what worked on my end:

    =MIN(40, (SUM([Formula - Honor Society 2018-2019]@row:[Formula Volunteer Activities 21-22]@row)))

    Thanks again!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!