Sum using symbols

Jamie Bachman

Can I sum the columns where I used a symbol to show the value?

for example - if I use the Stars Symbol for 'Size of effort' - Empty stars = 0, 1 Star = 1...

and the Faces for 'level of urgency' - No Pain = 0; to Extreme Pain = 5

the total Size + Urgency should be ~ 1 star + Extreme pain = 6

If I use the basic sum formula =sum([Size of Effort]1+[Level of Urgency]1)

It totals to 0.

I do not want a simple 0-5 number dropdown option for everything because it does not tell the same story as the symbols. ButI need the functional numberic math to work in the formula.

 

Brett Evans

Jamie,

You can do that.  Here is one way.

https://app.smartsheet.com/b/publish?EQBCT=4a3d9aa0f00e4c2c9ca4015000d0be63

 

I locked my lookup rows and hid the lookup columns so that users do not change the sorting or the values.  Also I grouped the lookup rows so that users cannotm move them around.