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
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.1K Get Help
 380 Global Discussions
 212 Industry Talk
 442 Announcements
 4.6K Ideas & Feature Requests
 140 Brandfolder
 129 Just for fun
 130 Community Job Board
 450 Show & Tell
 30 Member Spotlight
 1 SmartStories
 289 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!