# Calculate Points of Symbols?

Options
edited 12/09/19

I have three symbol fields Priority (uses Priority High, Low), Impact (uses Measure One, Two, Three, Four, Five), and Size (uses Measure One, Two, Three, Four, Five)

I would like to roll up points in a column for this.  Impact and Size would convert to integers, High Priority would add +5, Low Priority -2.

Can I do this all in one column?  Do I have to manually convert to INT the symbols or is there an easier way?

Tags:

• edited 02/28/19
Options

Hey John,

This can be done using a series of nested IF statements to specify the number values of each text option.

Try out this formula and see if it accomplishes what you had in mind:

=IF(Size@row = "One", 1, IF(Size@row = "Two", 2, IF(Size@row = "Three", 3, IF(Size@row = "Four", 4, IF(Size@row = "Five", 5))))) + IF(Impact@row = "One", 1, IF(Impact@row = "Two", 2, IF(Impact@row = "Three", 3, IF(Impact@row = "Four", 4, IF(Impact@row = "Five", 5))))) + IF(Priority@row = "High", 5, IF(Priority@row = "Low", -2, ""))

It is lengthy, but should accomplish your request! If you have any questions let me know!

• Options

Fantastic, thanks!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!