Sum of column values that come from function formula
I have created a formulation of a drop down with prices associated with each selection that population on a different column:
=IF([Repairs Needed]@row = "Tuck Point", "125", IF([Repairs Needed]@row = "Tuck Point Panel", "450", IF([Repairs Needed]@row = "Tuck Point Column", "150", IF([Repairs Needed]@row = "Tuck Point Major Column", "225", IF([Repairs Needed]@row = "Repair", "200", IF([Repairs Needed]@row = "Repair Panel", "225", IF([Repairs Needed]@row = "Repair Column", "125", IF([Repairs Needed]@row = "Repair Major Column", "450", IF([Repairs Needed]@row = "Replace Panel", "950", IF([Repairs Needed]@row = "Replace Column", "550", IF([Repairs Needed]@row = "Replace Major Column", "1125", IF([Repairs Needed]@row = "Mow Strip", "350", IF([Repairs Needed]@row = "Soldier Course", "125", IF([Repairs Needed]@row = "Rowlock Course", "150"))))))))))))))
But now when I try to sum up the column with my values after selection has been made I get "0"
I'm using =SUM([WO Value of Repairs]3:[WO Value of Repairs]1105)
What am I doing wrong, can it be because some rows don't have a selection?
Answers
-
Hello Victorugo,
If you remove the quotes from the values, it should work (e.g., use 125 instead of "125"). With the quotes, the values are text; without the quotes, they will be numbers.
Hope this helps!
-
You are a life saver @Kelly P. !!!! Thank you so much!!
-
You are very welcome! 😊
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K 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
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!