Shortcut link

=ROUNDDOWN([Total Down in Minutes]@row \/ 60, 0) + \":\" + IF(MOD([Total Down in Minutes]@row, 60) < 10, \"0\" + MOD([Total Down in Minutes]@row, 60), MOD([Total Down in Minutes]@row, 60))<\/p>"},{"commentID":387876,"body":"

Carson, thank you. This makes complete sense and hate I didn't think of the last part of that formula. Thank you again!<\/p>"},{"commentID":387877,"body":"

Happy to help!<\/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":108250,"type":"question","name":"formula help - using two cells","excerpt":"looking to fill in answer to the question - if \"Cell\" is less than one then put 1 in formula cell. in our case - we fill in the acreage of the lot. if this is less than 1 acre we need to put a \"1\" in the upgrade septic line Still learning formulas and this one is too advance for me!","snippet":"looking to fill in answer to the question - if \"Cell\" is less than one then put 1 in formula cell. in our case - we fill in the acreage of the lot. if this is less than 1 acre we…","categoryID":322,"dateInserted":"2023-07-28T14:49:49+00:00","dateUpdated":null,"dateLastComment":"2023-07-28T17:55:24+00:00","insertUserID":164264,"insertUser":{"userID":164264,"name":"cris3","title":"Office Admin","url":"https:\/\/community.smartsheet.com\/profile\/cris3","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-28T17:55:49+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-07-28T17:54:59+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":18,"score":null,"hot":3381125113,"url":"https:\/\/community.smartsheet.com\/discussion\/108250\/formula-help-using-two-cells","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108250\/formula-help-using-two-cells","format":"Rich","lastPost":{"discussionID":108250,"commentID":387874,"name":"Re: formula help - using two cells","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/387874#Comment_387874","dateInserted":"2023-07-28T17:55:24+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-07-28T17:54:59+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-07-28T17:48:00+00:00","dateAnswered":"2023-07-28T17:21:03+00:00","acceptedAnswers":[{"commentID":387863,"body":"

Hi @cris3<\/a> <\/p>

I hope you're well and safe!<\/p>

Try something like this.<\/p>

=IF(Acreage@row <> \"//www.santa-greenland.com/community/discussion/comment/\", IF(Acreage@row < 1, 1))<\/p>

Did that work\/help? <\/p>

I hope that helps!<\/p>

Be safe, and have a fantastic weekend!<\/p>

Best,<\/p>

Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p>

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/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":108252,"type":"question","name":"I would like to count the total values from a multi select column, based on another columns criteria","excerpt":"I apologize but I cannot seem to wrap my head around this. My goal is to count the total values in a multi select column based on another columns criteria. I figured I could combine the use of CountM and CountIFS but I have not been successful. Here is an example. The goal is for me to determine the total # of Reps Per…","snippet":"I apologize but I cannot seem to wrap my head around this. My goal is to count the total values in a multi select column based on another columns criteria. I figured I could…","categoryID":322,"dateInserted":"2023-07-28T15:05:34+00:00","dateUpdated":"2023-07-28T15:25:29+00:00","dateLastComment":"2023-07-28T15:56:23+00:00","insertUserID":164265,"insertUser":{"userID":164265,"name":"Jeremy J.","title":"Specialist","url":"https:\/\/community.smartsheet.com\/profile\/Jeremy%20J.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-28T15:56:41+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":164265,"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-07-28T15:52:49+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":25,"score":null,"hot":3381118317,"url":"https:\/\/community.smartsheet.com\/discussion\/108252\/i-would-like-to-count-the-total-values-from-a-multi-select-column-based-on-another-columns-criteria","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108252\/i-would-like-to-count-the-total-values-from-a-multi-select-column-based-on-another-columns-criteria","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":108252,"commentID":387843,"name":"Re: I would like to count the total values from a multi select column, based on another columns criteria","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/387843#Comment_387843","dateInserted":"2023-07-28T15:56:23+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-07-28T15:52:49+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/DN3IR3WTNK71\/for-smartsheet-png.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"For SmartSheet.PNG"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-28T15:50:27+00:00","dateAnswered":"2023-07-28T15:47:11+00:00","acceptedAnswers":[{"commentID":387835,"body":"

You would use a COUNTM\/COLLECT combo.<\/p>

=COUNTM(COLLECT(Rep:Rep, Manager:Manager, @cell = [Manager (For Formula)]@row))<\/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":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&siteSectionID=0&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":10000,"limit":3},"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">