How to Sum if field contains the same text

Jen K. ✭

08/03/23 inSmartsheet Basics

Sum.JPG

Hello,

Could you please assist me in developing a formula that will display a grand total if a certain criteria is met? What I'm looking for is highlighted in the table's Sum field.

Thank you

0 ·

Best Answer

Carson Penticuff ✭✭✭✭✭

08/03/23 Answer ✓

Are you attempting to replicate your screenshot? If so, using this as a column formula in your SUM column will do so.

=SUMIF([Color]:[Color], @cell = [Color]@row, [# of Hours]:[# of Hours])

0 · Share on Facebook Share on Twitter

Answers

Carson Penticuff ✭✭✭✭✭

08/03/23 Answer ✓

Are you attempting to replicate your screenshot? If so, using this as a column formula in your SUM column will do so.

=SUMIF([Color]:[Color], @cell = [Color]@row, [# of Hours]:[# of Hours])

0 · Share on Facebook Share on Twitter
Jen K. ✭

08/03/23

This worked! Thank you for your help!

0 · Share on Facebook Share on Twitter

Categories

Are you attempting to replicate your screenshot? If so, using this as a column formula in your SUM column will do so.<\/p>

=SUMIF([Color]:[Color], @cell = [Color]@row, [# of Hours]:[# of Hours])<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":108472,"type":"question","name":"DataMesh","excerpt":"I have two worksheets (A & B). Both worksheets contain rows of individual store data. Worksheet A has a check column that indicates whether or not a 'spin off' scope of work needs to take place. If the column is checked the row is copied to Worksheet B where we track the 'spin off' scope of work. There are some common…","snippet":"I have two worksheets (A & B). Both worksheets contain rows of individual store data. Worksheet A has a check column that indicates whether or not a 'spin off' scope of work needs…","categoryID":321,"dateInserted":"2023-08-03T13:50:16+00:00","dateUpdated":null,"dateLastComment":"2023-08-03T13:53:19+00:00","insertUserID":147369,"insertUser":{"userID":147369,"name":"PeggyLang","url":"https:\/\/community.smartsheet.com\/profile\/PeggyLang","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-03T22:06:35+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-08-03T18:02:41+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":18,"score":null,"hot":3382142015,"url":"https:\/\/community.smartsheet.com\/discussion\/108472\/datamesh","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108472\/datamesh","format":"Rich","lastPost":{"discussionID":108472,"commentID":388702,"name":"Re: DataMesh","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/388702#Comment_388702","dateInserted":"2023-08-03T13:53:19+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-08-03T18:02:41+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":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-03T13:55:57+00:00","dateAnswered":"2023-08-03T13:53:19+00:00","acceptedAnswers":[{"commentID":388702,"body":"

My suggestion would be to just hide the unwanted columns.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":108465,"type":"question","name":"Auto number column giving duplicated numbers","excerpt":"Hi All, I have an auto number column that I use in a formula to get row# but that auto number column is producing duplicate numbers and therefore messing up the formula. Does anyone know why it is giving duplicate numbers? Thanks.","snippet":"Hi All, I have an auto number column that I use in a formula to get row# but that auto number column is producing duplicate numbers and therefore messing up the formula. Does…","categoryID":321,"dateInserted":"2023-08-03T12:12:56+00:00","dateUpdated":null,"dateLastComment":"2023-08-03T13:29:36+00:00","insertUserID":154030,"insertUser":{"userID":154030,"name":"Carmen W","url":"https:\/\/community.smartsheet.com\/profile\/Carmen%20W","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-03T13:28:19+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":154030,"lastUser":{"userID":154030,"name":"Carmen W","url":"https:\/\/community.smartsheet.com\/profile\/Carmen%20W","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-03T13:28:19+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":36,"score":null,"hot":3382137752,"url":"https:\/\/community.smartsheet.com\/discussion\/108465\/auto-number-column-giving-duplicated-numbers","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108465\/auto-number-column-giving-duplicated-numbers","format":"Rich","lastPost":{"discussionID":108465,"commentID":388692,"name":"Re: Auto number column giving duplicated numbers","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/388692#Comment_388692","dateInserted":"2023-08-03T13:29:36+00:00","insertUserID":154030,"insertUser":{"userID":154030,"name":"Carmen W","url":"https:\/\/community.smartsheet.com\/profile\/Carmen%20W","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-03T13:28:19+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":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-03T13:29:48+00:00","dateAnswered":"2023-08-03T13:15:41+00:00","acceptedAnswers":[{"commentID":388687,"body":"

I got it. Change the Starting number to the number you want for a new row. Hope this works.<\/p>

\n \n $\"Screenshot_20230803-201230.png\"$ <\/img><\/a>\n <\/div>\n<\/div>\n

<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=321&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":4912,"limit":3},"title":"Trending in Smartsheet Basics","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Help shape the future of Smartsheet.
Share your ideas and feature requests.

Watch video