Check out theFormula Handbook templateto view 100+ formulas, including a glossary of every function and examples of commonly used and advanced formulas.
Sign in andask it here!The community's got your back.
Wondering if there’s a problem?
Check out theStatus Pageand subscribe for notifications.
Share your knowledge!
Help others byanswering questions.
Formulas and Functions
Discussion List
Help Article Resources
Categories
Popular Tags
- Formulas10,913
- Project Management4,399
- Sheets3,770
- Reports2,650
- 形式2,437
- functionality2,184
- Automations1,945
- IT & Operations1,754
- Enhancement Request1,576
- Support1,557
- Cell linking1,550
- Email Notifications1,461
- Account and User Management1,399
- Dashboards1,277
- Integrations1,245
- Conditional Formatting1,221
- Construction1,092
- API and Developers933
- Sharing and Collaboration908
- Workflows in Smartsheet876
- Manufacturing864
- Update Requests840
- Gantt View798
- Product Development794
- 附件794
You can do this with a nested IF statement. As a basic example, if you had a dropdown with options A, B, C and wanted to assign them points values of 1, 2, 3 respectively, you would use the following formula in your points column:<\/p>
=IF([Radio selection]@row = \"A\", 1, IF([Radio selection]@row = \"B\", 2, IF([Radio selection]@row = \"C\", 3)))<\/p>
![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/8IO6V0046RPJ\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\nIf you have multiple instances of this then you could then use a SUM formula to get the total at the end.<\/p>
Hopefully this points you in the right direction, but if you've more specifics or have any problems\/questions then just post!<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":111115,"type":"question","name":"Can Smartsheet automatically push a date on to a Thursday?","excerpt":"Hello. I thought I’d found the answer to this in a forum a while back, but the answer on there didn’t work for me when I tried it – I’d like to know if there’s a code\/formula for Smartsheet to check whether an End Date (publication date) falls on a Thursday and for Smartsheet to automatically move the date along to the…","snippet":"Hello. I thought I’d found the answer to this in a forum a while back, but the answer on there didn’t work for me when I tried it – I’d like to know if there’s a code\/formula for…","categoryID":322,"dateInserted":"2023-10-03T14:07:53+00:00","dateUpdated":null,"dateLastComment":"2023-10-03T15:17:08+00:00","insertUserID":167869,"insertUser":{"userID":167869,"name":"Lee5","title":"Mr","url":"https:\/\/community.smartsheet.com\/profile\/Lee5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-03T21:08:50+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-10-03T20:18:34+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":26,"score":null,"hot":3392690701,"url":"https:\/\/community.smartsheet.com\/discussion\/111115\/can-smartsheet-automatically-push-a-date-on-to-a-thursday","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/111115\/can-smartsheet-automatically-push-a-date-on-to-a-thursday","format":"Rich","tagIDs":[254,334],"lastPost":{"discussionID":111115,"commentID":398125,"name":"Re: Can Smartsheet automatically push a date on to a Thursday?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/398125#Comment_398125","dateInserted":"2023-10-03T15:17:08+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-10-03T20:18:34+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-10-03T14:58:34+00:00","dateAnswered":"2023-10-03T14:21:50+00:00","acceptedAnswers":[{"commentID":398101,"body":"
