Adding Numbers for Each Resource Formula

Good Day Smartsheet Community:

I am trying to reference Each Resource and the total number of Points they have in Each Sprint. For Example:

Ron has several tickets with various Points. I would like to add those in a another sheet for him using a formula with the following criteria:


Name is Ron

Sprint is 5

Collect his total Story Points

The Problem is I don't if I Use Count, Collect, or Sum to get this number for each resource.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!