Help with getting the SUM of multiple columns
I am trying to figure out the function to get the sum of multiple columns. I also want to be able to apply the function the every row in my sheet. So, when the form dumps a new response it auto finds the sum of all the points in the function.
Here are some screenshots to help with my explanation. Thanks.
Answers
-
Hey @Ty Werven,
Maybe try wrapping each cell in an INT() function? That would convert the text to an integer (assuming it is a number).
Then to convert the formula to a column function by right clicking on the cell the formula is in, then hit "Convert to Column Formula" on the popup menu:
If my response was helpful in any way (or answered your question) please be sure to upvote it, mark it as awesome, or mark it as the accepted answer!
I'm always looking to connect with other industry professionals, feel free to connect with me on LinkedIn as well!
-
Hello.
What would I put in the parenthesis for each column that will possible have points in them? Some columns will have nothing in them since the responses from participants vary from doing many things that get them points to very little. So, I just want to be sure that whatever method used will be able to calculate the sum of all of the columns that include possible points, and i will put them in a sum column with total points if that makes sense? Thanks.
-
Hey @Ty Werven,
Actually I would wrap each cell reference in the SUM formula with the INT function, so something like this:
=SUM(INT([Preceptor total points]@row), INT([Committee Chair total points]@row), INT(etc.)….
Hope that makes sense!
If my response was helpful in any way (or answered your question) please be sure to upvote it, mark it as awesome, or mark it as the accepted answer!
I'm always looking to connect with other industry professionals, feel free to connect with me on LinkedIn as well!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.2K Get Help
- 358 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 135 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!