Sum Formula when a Formula is used to Generate a number
I am trying to sum Cells that contain a number that is generated from another formula. However, the sum is not generating. These are the steps I have followed. Does anyone know how I can fix this?
- I have a series of cells that are populated through a form as Yes or No questions.
- If a question is answered yes it is assigned a number 1-12. Each question is weighted differently. So if the question is not that important it may get a rating of 3 and if it is very important it would get a 12.
- I created a cell that has this formula to make the Yes equal to a numeric value. =IF([Item 7: Will this Project require AV?]@row = "Yes", "11", "0")
- Then the last column I want to sum all of the weighted questions. This is the formula used: =SUM([Item 1 Score]@row + [Item 2 Score]@row + [Item 3 Score]@row + [Item 4 Score]@row + [Item 5 Score]@row + [Item 6 Score]@row + [Item 7 Score]@row + [Item 8 Score]@row + [Item 10 Score]@row + [Item 11 Score]@row + [Item 12 Score]@row + [Item 13 Score]@row)
However the sum comes up as 0.
Any help to fix this is appreciated.
Tags:
Best Answer
-
Within your first formula, remove the quotes from around the eleven and the zero. Placing quotes around a number can make the number behave as text rather than a value.
Answers
-
Within your first formula, remove the quotes from around the eleven and the zero. Placing quotes around a number can make the number behave as text rather than a value.
-
That worked! Thank you so much!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 68K Get Help
- 474 Global Discussions
- 208 Use Cases
- 517 Announcements
- 5.6K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 85 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!