Formulas and Functions

0, 12) + 6","categoryID":322,"dateInserted":"2021-04-06T13:07:27+00:00","dateUpdated":null,"dateLastComment":"2021-04-19T12:30:09+00:00","insertUserID":134595,"insertUser":{"userID":134595,"name":"Alia AhmadKamal","url":"https:\/\/community.smartsheet.com\/profile\/Alia%20AhmadKamal","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-04-26T01:51:51+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-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":51,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/78039\/how-to-get-minutes-using-this-formula-the-output-only-display-14-instead-of-14-30","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/78039\/how-to-get-minutes-using-this-formula-the-output-only-display-14-instead-of-14-30","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-04-06T13:35:46+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":78493,"type":"question","name":"Formula HELP!! count the number of task assigned","excerpt":"Hi I am trying to count the number of task assigned to specific person in contact cell =IF(ISBLANK({2021 MR & MI Online Update Sheet v1 Range 2}), COUNTIF(({2021 MR & MI Online Update Sheet v1 Range 4}), FIND([Column2]@row, @cell) > 0)) the error is incorrect argument","categoryID":322,"dateInserted":"2021-04-19T04:44:45+00:00","dateUpdated":"2021-04-19T08:12:16+00:00","dateLastComment":"2021-04-19T12:12:16+00:00","insertUserID":135147,"insertUser":{"userID":135147,"name":"Smartsheet Notification","url":"https:\/\/community.smartsheet.com\/profile\/Smartsheet%20Notification","photoUrl":"https:\/\/lh5.googleusercontent.com\/-DF1ZclTNiWM\/AAAAAAAAAAI\/AAAAAAAAAAA\/AMZuuckIadxHPT6DAGrZI74f6rIUKPc2DQ\/s96-c\/photo.jpg","dateLastActive":"2021-05-19T02:43:09+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":131402,"lastUser":{"userID":131402,"name":"Heather Duff","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Heather%20Duff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nH14DQG3YON84.png","dateLastActive":"2023-05-03T21:04:15+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":74,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/78493\/formula-help-count-the-number-of-task-assigned","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/78493\/formula-help-count-the-number-of-task-assigned","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-04-19T12:12:16+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":78500,"type":"question","name":"Formulas + Text","excerpt":"Hi, I'm trying to do something in a cell. What I would like is to insert at the beginning of a cell the last 6 letters of the cell next to it, it is done with this [=RIGHT(PROJET@row; 6)]. But I would like to have the text I wrote in this cell standing next to the right of the 6 letters of the formulas. Exemple: I type…","categoryID":322,"dateInserted":"2021-04-19T09:41:45+00:00","dateUpdated":null,"dateLastComment":"2021-04-19T12:10:36+00:00","insertUserID":135150,"insertUser":{"userID":135150,"name":"hatfab","url":"https:\/\/community.smartsheet.com\/profile\/hatfab","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-04-19T09:57:47+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":135150,"lastUser":{"userID":135150,"name":"hatfab","url":"https:\/\/community.smartsheet.com\/profile\/hatfab","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-04-19T09:57:47+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":138,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/78500\/formulas-text","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/78500\/formulas-text","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-04-19T09:47:37+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":78458,"type":"question","name":"Parent Child Formulas","excerpt":"Good morning! I have child rows with column formulas to find the average from other columns. Is it possible to add a parent row formula to find the average of the child rows? Hard to explain hopefully the image will help. The parent row is in blue. Thank you for your help!","categoryID":322,"dateInserted":"2021-04-16T17:03:17+00:00","dateUpdated":null,"dateLastComment":"2021-04-19T11:33:56+00:00","insertUserID":130729,"insertUser":{"userID":130729,"name":"Autumn Montegna","url":"https:\/\/community.smartsheet.com\/profile\/Autumn%20Montegna","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xqlRMXSl_7o!A49en8aSgno!zkP-Zxhpf-i","dateLastActive":"2022-01-28T14:55:15+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-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":11,"countViews":202,"score":null,"hot":11,"url":"https:\/\/community.smartsheet.com\/discussion\/78458\/parent-child-formulas","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/78458\/parent-child-formulas","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/VTZPBAGQDJ8Q\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2021-04-16T18:16:14+00:00","dateAnswered":"2021-04-16T17:32:51+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":78415,"type":"question","name":"Calculate days between first and last instance","excerpt":"Need help calculating the number of days between an items first entry on a list to it's latest entry. List is populated via Forms with newest entries at top of list. For example below (in yellow) would return 84 days. If possible, would like to determine the second to the last entry (in green). Appreciate the help.","categoryID":322,"dateInserted":"2021-04-15T20:31:57+00:00","dateUpdated":null,"dateLastComment":"2021-04-19T11:26:39+00:00","insertUserID":129419,"insertUser":{"userID":129419,"name":"Dave Schierman","url":"https:\/\/community.smartsheet.com\/profile\/Dave%20Schierman","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-30T12:27:08+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-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":11,"countViews":137,"score":null,"hot":11,"url":"https:\/\/community.smartsheet.com\/discussion\/78415\/calculate-days-between-first-and-last-instance","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/78415\/calculate-days-between-first-and-last-instance","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/CW3ID50TVVMA\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2021-04-16T19:23:06+00:00","dateAnswered":"2021-04-16T19:15:15+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":78495,"type":"question","name":"PIC columns get auto filled","excerpt":"Hi, for some reasons the PIC columns in all of my sheets get auto filled with all the contacts I put in for the drop down menu. I tried to fill the specific PIC for each of the task and hit Save but then all cells get auto filled but all the names.","categoryID":322,"dateInserted":"2021-04-19T07:26:39+00:00","dateUpdated":"2021-04-19T08:44:39+00:00","dateLastComment":"2021-04-19T08:15:37+00:00","insertUserID":135148,"insertUser":{"userID":135148,"name":"Naphan109","url":"https:\/\/community.smartsheet.com\/profile\/Naphan109","photoUrl":"https:\/\/lh3.googleusercontent.com\/-s9oWkF8kkfY\/AAAAAAAAAAI\/AAAAAAAAAAA\/AMZuuclN389jSDmj83hAOxAoGVWYrd5pdA\/s96-c\/photo.jpg","dateLastActive":"2021-04-23T08:15:42+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"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-08-26T17:06:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":71,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/78495\/pic-columns-get-auto-filled","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/78495\/pic-columns-get-auto-filled","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2021-04-19T08:30:50+00:00","dateAnswered":"2021-04-19T08: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}]},{"discussionID":78487,"type":"question","name":"Overall response status is getting removed...","excerpt":"I am trying to provide a status on our department response time. We have 30 days to respond to another department for requests, once they are received. 1) I wanted to put a Green, Yellow, and Red status on the request, based on if the open request is: a. greater than 14 days until the due date, (Green) b. greater than 7…","categoryID":322,"dateInserted":"2021-04-18T16:46:28+00:00","dateUpdated":null,"dateLastComment":"2021-04-19T06:42:55+00:00","insertUserID":125095,"insertUser":{"userID":125095,"name":"Michael Mather","url":"https:\/\/community.smartsheet.com\/profile\/Michael%20Mather","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!X-fXX38yfj4!pRDXaUs6r1Q!GGA-t2nDpaH","dateLastActive":"2021-04-19T16:57:18+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-08-26T17:06:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":62,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/78487\/overall-response-status-is-getting-removed","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/78487\/overall-response-status-is-getting-removed","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2021-04-19T01:41:14+00:00","dateAnswered":"2021-04-19T01:41:08+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":78322,"type":"question","name":"Formula to Calculate % Complete","excerpt":"Hi there, I have created a task sheet and want to calculate the % of completed tasks. Below is a picture of part of my sheet (there are a lot more tasks below). When an item is either ticked Yes or No, the Date field is auto populated. Once the Date field is populated the Completed cell turns from Red to Green. I would…","categoryID":322,"dateInserted":"2021-04-14T03:37:29+00:00","dateUpdated":null,"dateLastComment":"2021-04-18T21:49:06+00:00","insertUserID":134906,"insertUser":{"userID":134906,"name":"Hannah McHardy","url":"https:\/\/community.smartsheet.com\/profile\/Hannah%20McHardy","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-07-13T23:29:41+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":134906,"lastUser":{"userID":134906,"name":"Hannah McHardy","url":"https:\/\/community.smartsheet.com\/profile\/Hannah%20McHardy","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-07-13T23:29:41+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":225,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/78322\/formula-to-calculate-complete","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/78322\/formula-to-calculate-complete","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/BTOBGL37GZV0\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-04-14T08:21:19+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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">

Help Article Resources