Formulas and Functions

=TODAY(),[Date 2]1<=TODAY), \"True\", \"False\")…","categoryID":322,"dateInserted":"2020-07-15T09:48:26+00:00","dateUpdated":null,"dateLastComment":"2020-07-17T13:18:28+00:00","insertUserID":121716,"insertUser":{"userID":121716,"name":"Jordi de Jong","url":"https:\/\/community.smartsheet.com\/profile\/Jordi%20de%20Jong","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!H8nUXxtr_Lw!AiDVx6tZO-Q!QgoonaBEXu9","dateLastActive":"2020-07-17T13:24:16+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":10,"countViews":601,"score":null,"hot":10,"url":"https:\/\/community.smartsheet.com\/discussion\/69848\/if-formula-on-a-date-range","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69848\/if-formula-on-a-date-range","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-07-17T13:25:26+00:00","dateAnswered":"2020-07-17T13:18:28+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":69910,"type":"question","name":"Package condition vlookup","excerpt":"Hi, I'm trying to help our loading dock out by taking the cells they would normally just fill out, make it a form that is submitted per package. At the end of the day, look at the summary and send an email to the recipient based on the storage condition. The three storage conditions are 4C, -20C, and -80C, on a connected…","categoryID":322,"dateInserted":"2020-07-16T19:21:45+00:00","dateUpdated":null,"dateLastComment":"2020-07-17T13:09:26+00:00","insertUserID":124252,"insertUser":{"userID":124252,"name":"Shawn Moran","url":"https:\/\/community.smartsheet.com\/profile\/Shawn%20Moran","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-07-17T21:06:17+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":3,"countViews":63,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/69910\/package-condition-vlookup","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69910\/package-condition-vlookup","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/LUIZ55JM4I9Q\/receiving.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Receiving.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":[],"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":69761,"type":"question","name":"Counting Multiple Location Values","excerpt":"I have a metric sheet and I'm currently using a CountIF formula to count the locations in my sheet, works great. But I'd like to take it a step further and I want to group the location entries into APAC, NA, Canada, & EMEA. I'm trying to use this formula: =COUNTIF({ERG MEMBERSHIP EA Location}, \"Hyderabad, India\",…","categoryID":322,"dateInserted":"2020-07-10T14:24:35+00:00","dateUpdated":null,"dateLastComment":"2020-07-17T13:06:04+00:00","insertUserID":120154,"insertUser":{"userID":120154,"name":"Monica Gallegos","url":"https:\/\/community.smartsheet.com\/profile\/Monica%20Gallegos","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-04-26T16:01: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-20T03:23:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":72,"score":null,"hot":7,"url":"https:\/\/community.smartsheet.com\/discussion\/69761\/counting-multiple-location-values","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69761\/counting-multiple-location-values","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/WKNY7K920NEA\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2020-07-16T20:20:17+00:00","dateAnswered":"2020-07-13T11:37: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":69904,"type":"question","name":"Is it possible to divide the result of a countif formula by another?","excerpt":"I am trying to create sheet summary data that returns the % complete we are on confirming attendees at a new event. In a check box column I have the formula \"=COUNTIF([Confirmed - New Dates]3:[Confirmed - New Dates]47, 1) +\" which returns the correct value. Then in another check box column I have the total amount of people…","categoryID":322,"dateInserted":"2020-07-16T17:34:14+00:00","dateUpdated":null,"dateLastComment":"2020-07-17T13:05:17+00:00","insertUserID":124245,"insertUser":{"userID":124245,"name":"Tori Green","url":"https:\/\/community.smartsheet.com\/profile\/Tori%20Green","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!3Atfv5BEh_w!ZRHY2d24b34!tYhquaG-yIY","dateLastActive":"2023-06-22T21:15:18+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":4,"countViews":2520,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/69904\/is-it-possible-to-divide-the-result-of-a-countif-formula-by-another","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69904\/is-it-possible-to-divide-the-result-of-a-countif-formula-by-another","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":45641,"type":"discussion","name":"Gantt - Progress Ahead or Behind Schedule?","excerpt":"Hi All I'm keen to look into options to report on project progress against schedule. Generally we set a project programme, then progressively update %Complete against lines and the project progresses. The progress bar works well as visually indicating if each activity is ahead or behind the current date. I'm looking to try…","categoryID":322,"dateInserted":"2019-04-10T21:43:09+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2020-07-17T13:02:13+00:00","insertUserID":84301,"insertUser":{"userID":84301,"name":"Chris_Bick","url":"https:\/\/community.smartsheet.com\/profile\/Chris_Bick","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-07-27T23:37:25+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":5,"countViews":1355,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/45641\/gantt-progress-ahead-or-behind-schedule","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/45641\/gantt-progress-ahead-or-behind-schedule","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-04\/44\/c9\/44c94425816786907a5520a1a406db13.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Annotation 2019-04-11 114244.png"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":218,"urlcode":"Construction","name":"Construction"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":439,"urlcode":"gantt-view","name":"Gantt View"},{"tagID":440,"urlcode":"project-management","name":"Project Management"}],"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":69901,"type":"question","name":"Notification Exclusion","excerpt":"Hello, I am the owner and creator of a smartsheet, but a co-worker is the main user of the sheet, though others contribute. I have setup an automated workflow so that she is notified whenever a row is added or changed, but she doesn't need a notification if she is the one making a change. Am I missing a way to do this in…","categoryID":322,"dateInserted":"2020-07-16T16:25:02+00:00","dateUpdated":null,"dateLastComment":"2020-07-16T21:34:05+00:00","insertUserID":119383,"insertUser":{"userID":119383,"name":"Karen Plaisted","url":"https:\/\/community.smartsheet.com\/profile\/Karen%20Plaisted","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-08-23T17:22:24+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":119383,"lastUser":{"userID":119383,"name":"Karen Plaisted","url":"https:\/\/community.smartsheet.com\/profile\/Karen%20Plaisted","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-08-23T17:22:24+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":104,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/69901\/notification-exclusion","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69901\/notification-exclusion","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-07-16T21:33:22+00:00","dateAnswered":"2020-07-16T16:30: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":[],"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":69723,"type":"question","name":"Is it possible to have a column in a sheet serve as a reference to multiple other sheets?","excerpt":"Here is my scenario: I am redesigning some of my template sets and dashboards but leaving the originals up and running at the same time. I created a sandbox environment (workspace) to do this in. Some of the new sheets use the same data and formulas. Copy and pasting the formulas sometimes required me to recreate the…","categoryID":322,"dateInserted":"2020-07-09T14:28:12+00:00","dateUpdated":null,"dateLastComment":"2020-07-16T20:58:32+00:00","insertUserID":123940,"insertUser":{"userID":123940,"name":"Jamy Crum","url":"https:\/\/community.smartsheet.com\/profile\/Jamy%20Crum","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-02T18:55:48+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":123940,"lastUser":{"userID":123940,"name":"Jamy Crum","url":"https:\/\/community.smartsheet.com\/profile\/Jamy%20Crum","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-02T18:55:48+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":105,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/69723\/is-it-possible-to-have-a-column-in-a-sheet-serve-as-a-reference-to-multiple-other-sheets","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69723\/is-it-possible-to-have-a-column-in-a-sheet-serve-as-a-reference-to-multiple-other-sheets","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-07-16T20:58:56+00:00","dateAnswered":"2020-07-09T21:04:03+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":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"}],"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":69911,"type":"question","name":"Date Columns formula","excerpt":"Hello! I'm new to Smartsheet so I'm hoping you all could help me. I have three date columns and a duration (how many days between the dates) column. ColumnA - Initial baseline date ColumnB - Current EST Date ColumnC - Actual Date. Column D - Duration What I'm wondering is if there's a formula that will enable me to be able…","categoryID":322,"dateInserted":"2020-07-16T19:29:28+00:00","dateUpdated":null,"dateLastComment":"2020-07-16T20:03:28+00:00","insertUserID":124254,"insertUser":{"userID":124254,"name":"Nick Rozaklis","url":"https:\/\/community.smartsheet.com\/profile\/Nick%20Rozaklis","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-08-13T13:57:01+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":7,"countViews":71,"score":null,"hot":7,"url":"https:\/\/community.smartsheet.com\/discussion\/69911\/date-columns-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69911\/date-columns-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":69779,"type":"question","name":"Assistance with a calculation that compares the current date to month\/year","excerpt":"I am calculating labor costs based on project duration. I need to know the labor dollars only for the months greater than the current month (for example, if this month is July\/2020, then only calculate August\/2020 through February\/2021. The following formula sums hours x rate based on value in month columns 1 - xx. What I…","categoryID":322,"dateInserted":"2020-07-10T21:30:58+00:00","dateUpdated":null,"dateLastComment":"2020-07-16T19:44:26+00:00","insertUserID":124068,"insertUser":{"userID":124068,"name":"Cheryl Moon","url":"https:\/\/community.smartsheet.com\/profile\/Cheryl%20Moon","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-08-14T17:45:08+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":124068,"lastUser":{"userID":124068,"name":"Cheryl Moon","url":"https:\/\/community.smartsheet.com\/profile\/Cheryl%20Moon","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-08-14T17:45:08+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":111,"score":null,"hot":7,"url":"https:\/\/community.smartsheet.com\/discussion\/69779\/assistance-with-a-calculation-that-compares-the-current-date-to-month-year","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69779\/assistance-with-a-calculation-that-compares-the-current-date-to-month-year","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/VDW6X3PNN8ZZ\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2020-07-15T22:28:00+00:00","dateAnswered":"2020-07-13T07:41: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}">

Help Article Resources