Formulas and Functions

0, YEAR(Date3) = \"2021\", MONTH(Date3), IF([Team Number]28 = 0, YEAR($Date$2) = \"2021\", (1 + (MONTH(Date3) - MONTH(Date2))), 0), 0) Thank you! AE","categoryID":322,"dateInserted":"2020-06-26T21:37:44+00:00","dateUpdated":null,"dateLastComment":"2020-07-02T09:43:20+00:00","insertUserID":120627,"insertUser":{"userID":120627,"name":"Amy Evans","url":"https:\/\/community.smartsheet.com\/profile\/Amy%20Evans","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!w7NUtxNmBvw!pENV6QdfoXo!06xFD7vZJJC","dateLastActive":"2023-07-10T13:21:36+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-08-25T20:36:29+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":92,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/69456\/nested-if-statement","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69456\/nested-if-statement","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/T0BY8B519ZIE\/screenshot.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"SCREENSHOT.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2020-07-02T09:41:10+00:00","dateAnswered":"2020-06-29T14:29:57+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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}]},{"discussionID":69554,"type":"question","name":"Calculating the average of a column based on specific criteria in another group of cells","excerpt":"Hello everyone, I am trying to calculate the average of a column based on criteria found in another. The catch is that I don't want to specify the specific text of the other criteria as it is going to be based off of an ever expanding drop down\/list of different values and I want to minimize constant manual intervention.…","categoryID":322,"dateInserted":"2020-07-01T20:55:32+00:00","dateUpdated":null,"dateLastComment":"2020-07-02T09:20:13+00:00","insertUserID":123219,"insertUser":{"userID":123219,"name":"Matt Foss","url":"https:\/\/community.smartsheet.com\/profile\/Matt%20Foss","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!bCFRG7SgS_o!w6Nev-KRhHQ!jkKTibQm-FP","dateLastActive":"2023-08-14T22:31:29+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-08-25T20:36:29+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":472,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/69554\/calculating-the-average-of-a-column-based-on-specific-criteria-in-another-group-of-cells","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69554\/calculating-the-average-of-a-column-based-on-specific-criteria-in-another-group-of-cells","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-07-01T21:47:51+00:00","dateAnswered":"2020-07-01T21:47:47+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"formulas","name":"Formulas"}],"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}]},{"discussionID":69498,"type":"question","name":"Sheet Summary - countif","excerpt":"Hi there - What is the best way to do a 'count' on a drop down field located at the \"summary sheet\"? For example: I have a drop down field on summary sheet called \"Alignment\". It has drop down values such as cost reduction, revenue, risk\/fraud. Each sheets has one of those alignment category. I would like to have a summary…","categoryID":322,"dateInserted":"2020-06-29T22:51:04+00:00","dateUpdated":null,"dateLastComment":"2020-07-01T21:26:03+00:00","insertUserID":123032,"insertUser":{"userID":123032,"name":"Vickie Lim","url":"https:\/\/community.smartsheet.com\/profile\/Vickie%20Lim","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AOh14Gg6wpjK2hLmQ2GCgV1V55bhOwB3UaCsLlbB2dAm","dateLastActive":"2020-07-02T01:38:42+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":123032,"lastUser":{"userID":123032,"name":"Vickie Lim","url":"https:\/\/community.smartsheet.com\/profile\/Vickie%20Lim","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AOh14Gg6wpjK2hLmQ2GCgV1V55bhOwB3UaCsLlbB2dAm","dateLastActive":"2020-07-02T01:38:42+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":102,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/69498\/sheet-summary-countif","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69498\/sheet-summary-countif","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/48B2AUEWBUT5\/screen-shot-2020-06-29-at-3-46-33-pm.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screen Shot 2020-06-29 at 3.46.33 PM.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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}]},{"discussionID":69552,"type":"question","name":"Countifs and past due formula help","excerpt":"I am trying to count the items that have a particular workstream, multiple status (blank, In progress) and Due date in the past. here is my formula: =COUNTIFS([Workstream]:[Workstream], @row \"QBR\", [Status]:[Status], @row \"In Progress\", [Due Date]:[Due Date], @row <= TODAY()) the error I get is #unparseable. any ideas on…","categoryID":322,"dateInserted":"2020-07-01T20:19:48+00:00","dateUpdated":null,"dateLastComment":"2020-07-01T20:32:41+00:00","insertUserID":89801,"insertUser":{"userID":89801,"name":"Kiera3","url":"https:\/\/community.smartsheet.com\/profile\/Kiera3","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-08-03T16:49:36+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":114021,"lastUser":{"userID":114021,"name":"Chris Rea","url":"https:\/\/community.smartsheet.com\/profile\/Chris%20Rea","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!3FFXP-dgiXo!be9Um9NQUXw!-vLkliQWhRL","dateLastActive":"2020-07-14T22:26:22+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":75,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/69552\/countifs-and-past-due-formula-help","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69552\/countifs-and-past-due-formula-help","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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}]},{"discussionID":69520,"type":"question","name":"Forms and Blank Rows","excerpt":"Hi, We using a Smartsheet form to capture Covid19 Screening Questions. Once submitted the person has their temperature recorded which is manually captured against the record. The problem I am experiencing is that the person capturing the temperature sometimes accidentally inserts a blank row into the sheet which results in…","categoryID":322,"dateInserted":"2020-06-30T17:55:38+00:00","dateUpdated":null,"dateLastComment":"2020-07-01T20:30:14+00:00","insertUserID":70941,"insertUser":{"userID":70941,"name":"Lyn Pringle","url":"https:\/\/community.smartsheet.com\/profile\/Lyn%20Pringle","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xEHfsdxB4P4!pB_Y6Xm-pvw!Y_JywSiFRfq","dateLastActive":"2023-05-22T13:10:03+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":80301,"lastUser":{"userID":80301,"name":"Debbie Sawyer","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Debbie%20Sawyer","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-02\/6f\/d1\/n6fd11e91b71000f2b152e84c8f072631.jpg","dateLastActive":"2023-08-24T14:07:47+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":134,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/69520\/forms-and-blank-rows","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69520\/forms-and-blank-rows","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/Y780GN0J9A8R\/annotation-2020-06-30-195645.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Annotation 2020-06-30 195645.jpg"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":204,"urlcode":"forms","name":"Forms"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":510,"urlcode":"email-notifications","name":"Email Notifications"}],"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}]},{"discussionID":69543,"type":"question","name":"Create a sub task from a task","excerpt":"I need to start using sub tasks. I already have hierarchies built into my input sheet. Much of the information on the parent must also be included in the child tasks Is it possible to systemically copy data from a parent task into a sub task? Or Add a link to the parent record onto the child? I'm not sure a formula will…","categoryID":322,"dateInserted":"2020-07-01T15:55:55+00:00","dateUpdated":null,"dateLastComment":"2020-07-01T20:23:30+00:00","insertUserID":104631,"insertUser":{"userID":104631,"name":"Detrie Zacharias","url":"https:\/\/community.smartsheet.com\/profile\/Detrie%20Zacharias","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nQtXn4Wtj_o!wSnUcJnZ0Dw!lFH98PKZDWF","dateLastActive":"2023-01-27T16:30:35+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":80301,"lastUser":{"userID":80301,"name":"Debbie Sawyer","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Debbie%20Sawyer","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-02\/6f\/d1\/n6fd11e91b71000f2b152e84c8f072631.jpg","dateLastActive":"2023-08-24T14:07:47+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":850,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/69543\/create-a-sub-task-from-a-task","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69543\/create-a-sub-task-from-a-task","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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}]},{"discussionID":69452,"type":"question","name":"Auto-populate a value in the cell of a column, based on previous values","excerpt":"Hi, Appreciate your help! I have a sheet, where Auto-number is taken up for the first column. I have a Priority Column, which I want to auto-populate based on if the number already exists. Item # | Item Requested | Priority 21 | Test 1 | 1 23 | Test 2 | 2 24 | Test | 3 25 | Test | ---here the number should auto-populate as…","categoryID":322,"dateInserted":"2020-06-26T21:05:26+00:00","dateUpdated":null,"dateLastComment":"2020-07-01T19:16:10+00:00","insertUserID":99556,"insertUser":{"userID":99556,"name":"dsmartsheetuser","url":"https:\/\/community.smartsheet.com\/profile\/dsmartsheetuser","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-21T20:30:03+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-08-25T20:36:29+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":982,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/69452\/auto-populate-a-value-in-the-cell-of-a-column-based-on-previous-values","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69452\/auto-populate-a-value-in-the-cell-of-a-column-based-on-previous-values","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":281,"urlcode":"support","name":"Support"},{"tagID":285,"urlcode":"solution-center","name":"Solution Center"}],"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}]},{"discussionID":69468,"type":"question","name":"RYG Column based on % Complete and Date","excerpt":"This discussion was created from comments split from: Working with Symbol Formulas.","categoryID":322,"dateInserted":"2020-06-28T13:38:23+00:00","dateUpdated":null,"dateLastComment":"2020-07-01T19:08:43+00:00","insertUserID":113652,"insertUser":{"userID":113652,"name":"System","title":"","url":"https:\/\/community.smartsheet.com\/profile\/System","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/650\/n67RVONBT7K0D.png","dateLastActive":"2023-08-24T15:55:34+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-08-25T20:36:29+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":73,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/69468\/ryg-column-based-on-complete-and-date","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69468\/ryg-column-based-on-complete-and-date","format":"Html","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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}]},{"discussionID":69523,"type":"question","name":"How can I use a formula to track total minutes\/hours between Start and End time ?","excerpt":"Hello, I am looking to see if there is a way to set up a formula that reads the difference of two columns (start time and end time) and converts to \"total hours and minutes\". What I am trying to do, is set up a sheet where we can use for our employees to track their total start and end times on specific tasks they are…","categoryID":322,"dateInserted":"2020-06-30T20:09:15+00:00","dateUpdated":"2020-06-30T20:42:49+00:00","dateLastComment":"2020-07-01T19:04:32+00:00","insertUserID":123177,"insertUser":{"userID":123177,"name":"Allan Kelsch","url":"https:\/\/community.smartsheet.com\/profile\/Allan%20Kelsch","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AOh14GgUROb3QxrFFk1wV_t28r6oo8pOscumTRQzsqPr=s96-c","dateLastActive":"2022-03-17T02:00:23+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":123177,"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-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":183,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/69523\/how-can-i-use-a-formula-to-track-total-minutes-hours-between-start-and-end-time","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69523\/how-can-i-use-a-formula-to-track-total-minutes-hours-between-start-and-end-time","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-12-16T23:19:49+00:00","dateAnswered":"2020-07-01T19:04:32+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">

Help Article Resources