is there a way to show total values in forms sheet?

A department within our organization needs to see total values for items filled out in forms. Is there a way to see an accumulation of values as the managers complete certain questions in forms? For example, within each of these items are four options, and each option is worth a certain value. The managers need to be able to see the value as they enter a drop down item. Is this possible? If not, it needs to be. Thanks!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!