Calculate Points of Symbols?
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?
Comments

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!

Fantastic, thanks!
Help Article Resources
Categories
Check out the Formula Handbook template!