Formulas and Functions

N\/A\" formula in smartsheet Date column","excerpt":"hi, using countif() formula for count total count of \"<>N\/A\" cells. when use formula =COUNTIF({Master Tax Calendar Range 3}, \"<>N\/A\") and my count is zero. my column format is Date. same formula count correctly in excel but not working in smartsheet. please suggest formula for how to count total, if my date column contain…","categoryID":322,"dateInserted":"2020-07-09T09:31:05+00:00","dateUpdated":"2020-07-09T09:31:35+00:00","dateLastComment":"2020-07-13T05:12:47+00:00","insertUserID":119414,"insertUser":{"userID":119414,"name":"Yashwant Singh","url":"https:\/\/community.smartsheet.com\/profile\/Yashwant%20Singh","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xUHUsZ9hKP4!hRNW4WMc77Q!UkcZ7X7Sevw","dateLastActive":"2021-10-11T08:51:54+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":119414,"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":23,"countViews":427,"score":null,"hot":23,"url":"https:\/\/community.smartsheet.com\/discussion\/69714\/how-to-use-n-a-formula-in-smartsheet-date-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69714\/how-to-use-n-a-formula-in-smartsheet-date-column","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":69777,"type":"question","name":"Weighted Sum of Checkboxes","excerpt":"I'm looking for a method of creating a \"score\" based off the sum of checkboxes in a row. Various columns ideally would have different weights, creating either a numerical sum or a percentage out of 100. I'm stuck at having a checkbox generating a value to sum. Thanks.","categoryID":322,"dateInserted":"2020-07-10T20:57:44+00:00","dateUpdated":null,"dateLastComment":"2020-07-12T17:52:19+00:00","insertUserID":124062,"insertUser":{"userID":124062,"name":"Nick VanHouten","url":"https:\/\/community.smartsheet.com\/profile\/Nick%20VanHouten","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-07-14T23:30:31+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":94,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/69777\/weighted-sum-of-checkboxes","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69777\/weighted-sum-of-checkboxes","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":69757,"type":"question","name":"How can generate a weekly report using formula and without using a Column Helper?","excerpt":"Hi, Please help me on writing a formula to calculate the weekly sales data. Please see the attached screenshot of my example data.","categoryID":322,"dateInserted":"2020-07-10T12:53:50+00:00","dateUpdated":null,"dateLastComment":"2020-07-12T01:00:09+00:00","insertUserID":120531,"insertUser":{"userID":120531,"name":"Benjo09","url":"https:\/\/community.smartsheet.com\/profile\/Benjo09","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-09-08T07:29:20+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":120531,"lastUser":{"userID":120531,"name":"Benjo09","url":"https:\/\/community.smartsheet.com\/profile\/Benjo09","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-09-08T07:29:20+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":270,"score":null,"hot":7,"url":"https:\/\/community.smartsheet.com\/discussion\/69757\/how-can-generate-a-weekly-report-using-formula-and-without-using-a-column-helper","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69757\/how-can-generate-a-weekly-report-using-formula-and-without-using-a-column-helper","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/H95BC59D6W3N\/smartsheet-question-jpg.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"smartsheet question.JPG"},"attributes":{"question":{"status":"accepted","dateAccepted":"2020-07-11T00:40:29+00:00","dateAnswered":"2020-07-10T13:25:36+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"},{"tagID":335,"urlcode":"sheet-summary","name":"Sheet Summary"}],"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":69771,"type":"question","name":"Update Request Results showing data that was deleted from Update Req. Form","excerpt":"I am sending an Update Request (UR) form to employees to have them tell me how many hours they worked each day. The smartsheet is prefilled with 8 hours each day. So when the UR form get to the employee, they just make adjustments as needed. In the image below, the employee received the UR form. Deleted 8 from the Hours…","categoryID":322,"dateInserted":"2020-07-10T17:19:18+00:00","dateUpdated":null,"dateLastComment":"2020-07-10T18:24:51+00:00","insertUserID":122725,"insertUser":{"userID":122725,"name":"Tori Isbell","url":"https:\/\/community.smartsheet.com\/profile\/Tori%20Isbell","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!25HDv90w43w!xZnCMRlHMz4!zBBm2Azke3a","dateLastActive":"2021-04-07T17:20: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":3,"countViews":133,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/69771\/update-request-results-showing-data-that-was-deleted-from-update-req-form","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69771\/update-request-results-showing-data-that-was-deleted-from-update-req-form","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/OHW918AKZY5Z\/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":210,"urlcode":"human-resources","name":"Human Resources"},{"tagID":446,"urlcode":"update-requests","name":"Update Requests"}],"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":69749,"type":"question","name":"formula answer from decimal to year, month","excerpt":"Hi I need to a formula to convert an answer that i get from a formula to a year, month format Formula I am using =(TODAY() - DATEONLY([Appointment Start Date]2)) \/ 365 = 2.27397 Convert the 2.27397 to Year, Month","categoryID":322,"dateInserted":"2020-07-10T00:20:45+00:00","dateUpdated":null,"dateLastComment":"2020-07-10T18:22:40+00:00","insertUserID":124027,"insertUser":{"userID":124027,"name":"Lisbeth Fuentes-Fernandez","url":"https:\/\/community.smartsheet.com\/profile\/Lisbeth%20Fuentes-Fernandez","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-01-06T19:23: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":7,"countViews":219,"score":null,"hot":7,"url":"https:\/\/community.smartsheet.com\/discussion\/69749\/formula-answer-from-decimal-to-year-month","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69749\/formula-answer-from-decimal-to-year-month","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":69759,"type":"question","name":"Average If formula","excerpt":"Looking for help with an average function if anyone can help, we have a column with a company name (SI Team) and a column for response time (this gives number of days). Looking help with a formula to count up and average all the response times IF the company name is ABC. Help is greatly appreciated. I think it might need…","categoryID":322,"dateInserted":"2020-07-10T13:38:59+00:00","dateUpdated":null,"dateLastComment":"2020-07-10T17:43:45+00:00","insertUserID":123062,"insertUser":{"userID":123062,"name":"Gillian Pritchard","url":"https:\/\/community.smartsheet.com\/profile\/Gillian%20Pritchard","photoUrl":"https:\/\/lh5.googleusercontent.com\/-5FnI85CmOLI\/AAAAAAAAAAI\/AAAAAAAAAAA\/AMZuucl8mwPnVDtMGgJoAPWXR02vSo_Eww\/photo.jpg","dateLastActive":"2020-08-07T16:30:26+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":4,"countViews":72,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/69759\/average-if-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69759\/average-if-formula","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":69766,"type":"question","name":"Help with Countifs - Summary Sheet","excerpt":"I am wanting to have a shared user be able to input a Startdate and EndDate which is then calculated using Countifs. Is this possible in a Summary Sheet? I get an unparseable error for the code below. Any suggestions? Thanks. c","categoryID":322,"dateInserted":"2020-07-10T15:42:35+00:00","dateUpdated":null,"dateLastComment":"2020-07-10T17:03:09+00:00","insertUserID":100191,"insertUser":{"userID":100191,"name":"Doyle54","url":"https:\/\/community.smartsheet.com\/profile\/Doyle54","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!x8FFMecnnPo!bOjCm8kQSFY!5coFfTEIyy9","dateLastActive":"2020-10-30T14:29:40+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":72,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/69766\/help-with-countifs-summary-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69766\/help-with-countifs-summary-sheet","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/FMEXFGYRIF2M\/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":[],"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":69745,"type":"question","name":"I can't figure out what's wrong with my formula. I keep getting an \"#Unparseable\" Error. Help?","excerpt":"Can someone help me figure out why my formula keeps giving me an error? I can't for the life of me figure it out: =IF(AND([8p LTC Peak]2 < $[8p LTC Peak]$1 + Green#, [8p LTC Peak]2 > 0), \"Green\", IF(AND([8p LTC Peak]2 < $[8p LTC Peak]$1 + [Blue]#, [8p LTC Peak]2 > $[8p LTC Peak]$1), \"Blue”))","categoryID":322,"dateInserted":"2020-07-09T22:51:31+00:00","dateUpdated":"2020-07-09T22:53:51+00:00","dateLastComment":"2020-07-10T15:59:14+00:00","insertUserID":124026,"insertUser":{"userID":124026,"name":"Thomas Lince","url":"https:\/\/community.smartsheet.com\/profile\/Thomas%20Lince","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!htfdYX7s_b4!xP_Q8XirIfw!zfBBUaNKu_E","dateLastActive":"2022-08-26T14:10:52+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":124026,"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":7,"countViews":82,"score":null,"hot":7,"url":"https:\/\/community.smartsheet.com\/discussion\/69745\/i-cant-figure-out-whats-wrong-with-my-formula-i-keep-getting-an-unparseable-error-help","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69745\/i-cant-figure-out-whats-wrong-with-my-formula-i-keep-getting-an-unparseable-error-help","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-07-10T15:53:49+00:00","dateAnswered":"2020-07-10T11:54:00+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":69022,"type":"question","name":"RYG Stoplight Formula Looking at Dates, Status and % Complete","excerpt":"Hi there SS Community! So I tried to see if I could find something to help me with my formula for having the RYG stoplights populate based on data captured in both the Status and % Complete columns. I started with a basic formula but I wanted to try to also include the Start and End Dates. Here are my outcomes: (1) If the…","categoryID":322,"dateInserted":"2020-06-10T17:58:48+00:00","dateUpdated":null,"dateLastComment":"2020-07-10T14:19:10+00:00","insertUserID":121176,"insertUser":{"userID":121176,"name":"Sandra Guzman","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Sandra%20Guzman","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/VZV1Z4RR19KP\/nNAQ24KKIG4YS.jpg","dateLastActive":"2023-08-09T13:34:59+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":9,"countViews":471,"score":null,"hot":9,"url":"https:\/\/community.smartsheet.com\/discussion\/69022\/ryg-stoplight-formula-looking-at-dates-status-and-complete","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69022\/ryg-stoplight-formula-looking-at-dates-status-and-complete","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-07-09T22:10:30+00:00","dateAnswered":"2020-06-10T18:41:33+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