Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Help with a formula
First time posting because I'm not well versed with formulas and I'm hoping that someone smarter than me can offer some guidance.
I would like to create a form that assigns a point value to specific activities (e.g. JTA, IDW, SS, TR and so on) identified in different columns and sums the total value of all activities in the last column. The use case is to calculate points for a rewards program. See attached image for reference.
I've tried several of the Smartsheet formulas and I cannot seem to get it right so I'm calling in the calvary for help.
Can anyone offer some insights on what I'm missing?