Using a form, I am trying to score the responses and add up the scores of the responses.
Shajan
✭✭
I am trying to use a form to allow the submitter to make predefined selections and to score their responses bases on predefined numbers within their selection. Below is an example of how I formatted the selections the form has for one of the columns. The numbers in "quotes" are the score for the response. I'm hoping to use a formula to capture the value within the quotes and sum them together - for final score.
This is a formula I was able to put together but it doesn't work. Not sure if I am on the right track at all.
=SUMIFS([Project Cost]@row:[Solution Complexity]@row, [Project Cost]@row:[Solution Complexity]@row, <=3,])
Answers
-
I reformulated my sheet and formula and will post a different question.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 396 Global Discussions
- 213 Industry Talk
- 448 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 133 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 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!