Explore. Ask. Answer

Find peer-to-peer information about everything Smartsheet related – from project management best practices to invaluable how-to guidance from fellow users and Smartsheet experts.

Discussion List

= DATE(2023, 1, 1), @cell <= DATE(2023, 3, 31))) The formulas aren't working. I think it's…","categoryID":322,"dateInserted":"2023-07-30T02:50:59+00:00","dateUpdated":null,"dateLastComment":"2023-08-18T12:52:46+00:00","insertUserID":164324,"insertUser":{"userID":164324,"name":"katie.mcelroy","title":"Program Manager","url":"https:\/\/community.smartsheet.com\/profile\/katie.mcelroy","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-18T17:07:19+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-20T03:23:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":16,"countViews":163,"score":null,"hot":3383058225,"url":"https:\/\/community.smartsheet.com\/discussion\/108294\/date-format-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108294\/date-format-formula","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/WAEGW888FJPS\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-07-31T13:28:58+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}">