Formulas and Functions

= to a date referenced in a cell. I get the unparseable error. =COUNTIFS({2020-03 Monthly Complaints Range 1}, =[Manufacturing location]1), {2020-03 Monthly Complaints rec date 1}, >=[From Date]1)…","categoryID":322,"dateInserted":"2020-07-10T18:27:37+00:00","dateUpdated":null,"dateLastComment":"2020-07-14T11:59:48+00:00","insertUserID":124055,"insertUser":{"userID":124055,"name":"Stephen Paolicelli","url":"https:\/\/community.smartsheet.com\/profile\/Stephen%20Paolicelli","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!0iDbP4g1e_Q!!5nY1NkO7bVU","dateLastActive":"2020-07-22T17:24:34+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":206,"score":null,"hot":11,"url":"https:\/\/community.smartsheet.com\/discussion\/69773\/trying-to-apply-a-date-range-filter-on-a-countif-but-getting-an-unparseable-error","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69773\/trying-to-apply-a-date-range-filter-on-a-countif-but-getting-an-unparseable-error","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":69717,"type":"question","name":"Looking for a formula to check mark children, UNLESS that child has it's own (grandchildren)","excerpt":"So I'm working on a formula to check checkboxes in a column if the primary column (named \"Task Name\") is a child UNLESS that child has it's own children. Basically what I have a is a job tracker, and some jobs are simple. Some have are more complex broken into parts. For example the completion of job \"Alpha\" is a sum of 3…","categoryID":322,"dateInserted":"2020-07-09T12:47:10+00:00","dateUpdated":null,"dateLastComment":"2020-07-14T11:57:59+00:00","insertUserID":123027,"insertUser":{"userID":123027,"name":"Chris Shields","url":"https:\/\/community.smartsheet.com\/profile\/Chris%20Shields","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-11-13T17:16:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":123027,"lastUser":{"userID":123027,"name":"Chris Shields","url":"https:\/\/community.smartsheet.com\/profile\/Chris%20Shields","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-11-13T17:16:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":176,"score":null,"hot":9,"url":"https:\/\/community.smartsheet.com\/discussion\/69717\/looking-for-a-formula-to-check-mark-children-unless-that-child-has-its-own-grandchildren","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69717\/looking-for-a-formula-to-check-mark-children-unless-that-child-has-its-own-grandchildren","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-07-09T14:00:42+00:00","dateAnswered":"2020-07-09T12:51:14+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":69794,"type":"question","name":"Trying to have a checkbox \"check\" auto if a date is in the future....","excerpt":"If LEASE END is TODAY() then checkbox = 1.....","categoryID":322,"dateInserted":"2020-07-13T15:02:00+00:00","dateUpdated":null,"dateLastComment":"2020-07-13T15:24:27+00:00","insertUserID":124099,"insertUser":{"userID":124099,"name":"Steve Joyce","url":"https:\/\/community.smartsheet.com\/profile\/Steve%20Joyce","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!yVtUcpNt8Hw!BWtVwWNe7XQ!HblkRCEKG87","dateLastActive":"2020-07-22T15:24:14+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":7,"countViews":109,"score":null,"hot":7,"url":"https:\/\/community.smartsheet.com\/discussion\/69794\/trying-to-have-a-checkbox-check-auto-if-a-date-is-in-the-future","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69794\/trying-to-have-a-checkbox-check-auto-if-a-date-is-in-the-future","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-07-13T15:39:48+00:00","dateAnswered":"2020-07-13T15:24:27+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":69790,"type":"question","name":"Help needed: COUNTIFS and DOES NOT CONTAIN function","excerpt":"Hi team - so I have a formula for counting \"errors\" that occur in a specific month: =COUNTIFS([Main row]:[Main row], 1, Created:Created, IFERROR(MONTH(@cell), 0) = 5, [Incorrect format]:[Incorrect format], 1) What I'm trying to do now is do the same thing but EXCLUDE \"General Counsel\" from the counting formula:…","categoryID":322,"dateInserted":"2020-07-13T13:25:43+00:00","dateUpdated":null,"dateLastComment":"2020-07-13T13:55:44+00:00","insertUserID":118864,"insertUser":{"userID":118864,"name":"jmo","title":"","url":"https:\/\/community.smartsheet.com\/profile\/jmo","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!g0lA5zVbOLw!-wfAd_lcHz4!voKaS5U1cZv","dateLastActive":"2023-01-17T16:39:58+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":2758,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/69790\/help-needed-countifs-and-does-not-contain-function","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69790\/help-needed-countifs-and-does-not-contain-function","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-07-13T13:50:58+00:00","dateAnswered":"2020-07-13T13:48: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":69660,"type":"question","name":"my collect function doesnt work","excerpt":"I have used a collect function workaround from one fo the community boards, and it works wonders. however it doesnt seem to work when this new data lookup range. note the data lookup range has been edit with the =left function. =JOIN(COLLECT({Open Order Inquiry2020-07-07 Range 3}, {Open Order Inquiry2020-07-07 Range 2},…","categoryID":322,"dateInserted":"2020-07-07T15:42:55+00:00","dateUpdated":null,"dateLastComment":"2020-07-13T11:42:04+00:00","insertUserID":123858,"insertUser":{"userID":123858,"name":"bryanlow","url":"https:\/\/community.smartsheet.com\/profile\/bryanlow","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-07-12T23:34:52+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":8,"countViews":218,"score":null,"hot":8,"url":"https:\/\/community.smartsheet.com\/discussion\/69660\/my-collect-function-doesnt-work","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69660\/my-collect-function-doesnt-work","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/VWSRR5O79RAC\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.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":[{"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":69783,"type":"question","name":"Can you submit a document from a form and place the new row based on sheet heirarchy?","excerpt":"I have several vendors working on the same project. Each has a set of required deliverables that have to be submitted at regular intervals (weekly, twice monthly, monthly) during different project phases (concept, design, installation). I would like to use a sheet to track the submissions and create a form for them to use…","categoryID":322,"dateInserted":"2020-07-13T03:46:49+00:00","dateUpdated":null,"dateLastComment":"2020-07-13T11:40:52+00:00","insertUserID":122814,"insertUser":{"userID":122814,"name":"Michael Murphy","url":"https:\/\/community.smartsheet.com\/profile\/Michael%20Murphy","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-07-23T21:17:53+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":2,"countViews":101,"score":1,"hot":3189253961,"url":"https:\/\/community.smartsheet.com\/discussion\/69783\/can-you-submit-a-document-from-a-form-and-place-the-new-row-based-on-sheet-heirarchy","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69783\/can-you-submit-a-document-from-a-form-and-place-the-new-row-based-on-sheet-heirarchy","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/VUS0DO4MR4TI\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.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":[{"tagID":204,"urlcode":"forms","name":"Forms"},{"tagID":448,"urlcode":"workflows-in-smartsheet","name":"Workflows in Smartsheet"}],"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":69786,"type":"question","name":"Sum If","excerpt":"Hi All, I need help with a formula. I think it should be sum if. I want estimated hours 28 to show the sum of cells 29:34 but only if %complete is less then full. Thanks.","categoryID":322,"dateInserted":"2020-07-13T09:22:11+00:00","dateUpdated":null,"dateLastComment":"2020-07-13T11:37:48+00:00","insertUserID":120363,"insertUser":{"userID":120363,"name":"Lockie Stewart-Baker","url":"https:\/\/community.smartsheet.com\/profile\/Lockie%20Stewart-Baker","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-06-30T10:27:32+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":7,"countViews":83,"score":null,"hot":7,"url":"https:\/\/community.smartsheet.com\/discussion\/69786\/sum-if","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69786\/sum-if","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/VBBLB2MT25BL\/screenshot-2020-07-13-at-11-21-29.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screenshot 2020-07-13 at 11.21.29.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2020-07-13T11:39:26+00:00","dateAnswered":"2020-07-13T11:27:54+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":66487,"type":"question","name":"Summary Sheet formula to count # of rows within 30 days of today","excerpt":"Hi, I am trying to create a formula in a sheet summary that will count how many cells are within 30 days of today's date based on a date column. I can't figure it out. Can anyone help? Thanks!","categoryID":322,"dateInserted":"2020-03-04T17:25:29+00:00","dateUpdated":null,"dateLastComment":"2020-07-13T09:40:27+00:00","insertUserID":88916,"insertUser":{"userID":88916,"name":"Melanie Sanders","url":"https:\/\/community.smartsheet.com\/profile\/Melanie%20Sanders","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!j_dP49SAvro!m2jOf2yrXaY!PxpOPNHIXga","dateLastActive":"2023-07-27T20:09: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":5,"countViews":1061,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/66487\/summary-sheet-formula-to-count-of-rows-within-30-days-of-today","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/66487\/summary-sheet-formula-to-count-of-rows-within-30-days-of-today","format":"rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-03-04T21:09:28+00:00","dateAnswered":"2020-03-04T20:47:26+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":69782,"type":"question","name":"Formulas and attachments","excerpt":"We utilize SmartSheet to collect information for complex implementation projects. We have applications where our users will be attaching documents to specific items\/rows in a sheet. It would be awesome to be able to write various formulas to interact with the attachments. For example: Detect if there are any attachments…","categoryID":322,"dateInserted":"2020-07-12T23:41:50+00:00","dateUpdated":null,"dateLastComment":"2020-07-13T05:17:51+00:00","insertUserID":124076,"insertUser":{"userID":124076,"name":"Justin Peter","url":"https:\/\/community.smartsheet.com\/profile\/Justin%20Peter","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!87NWd-GrxvQ!!dIJnzOGKODn","dateLastActive":"2023-07-06T17:55:34+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":122299,"lastUser":{"userID":122299,"name":"Stefan","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Stefan","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nJVa34H1C4Q!HEtZnwWHg7o!c2eUa44FlAn","dateLastActive":"2023-08-24T06:42:15+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":371,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/69782\/formulas-and-attachments","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69782\/formulas-and-attachments","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":268,"urlcode":"attachments","name":"Attachments"}],"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