Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, pleaseVisit the Current Forums.

Archived 2017 Posts

Discussion List

). Unless this is not a generall webhook standard that bodes get echoes back,…","categoryID":319,"dateInserted":"2017-01-06T13:01:30+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-01-09T15:17:53+00:00","insertUserID":10193,"insertUser":{"userID":10193,"name":"joer00","url":"https:\/\/community.smartsheet.com\/profile\/joer00","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-01-06T12:51:15+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":603,"lastUser":{"userID":603,"name":"dAVE Inden","url":"https:\/\/community.smartsheet.com\/profile\/dAVE%20Inden","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/2f\/a6\/n2fa68b66b9aff39a6e105069eb3e7cfc.jpg","dateLastActive":"2019-07-15T14:06:22+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":112,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/6900\/issues-with-smarthooks-verification","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/6900\/issues-with-smarthooks-verification","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":319,"name":"Archived 2017 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2017","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":227,"urlcode":"api-and-developers","name":"API and Developers"}],"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":6906,"type":"discussion","name":"Previous and Next month buttons not appearing in IE","excerpt":"We are asking team members to enter future delivery dates using a Date column. Unfortunately, the previous and next month arrows are not appearing in Internet Explorer. Nobody had complained about this issue until today. Is this a known issue? Other than switching browsers, is there a solution?","categoryID":319,"dateInserted":"2017-01-09T07:06:12+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-01-09T12:35:00+00:00","insertUserID":7257,"insertUser":{"userID":7257,"name":"Todd Mazurick","url":"https:\/\/community.smartsheet.com\/profile\/Todd%20Mazurick","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-01-09T07:01:45+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":195,"lastUser":{"userID":195,"name":"Shaine Greenwood","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Shaine%20Greenwood","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/198\/nBSBY6VR571R7.jpg","dateLastActive":"2021-08-30T16:03:52+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":11,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/6906\/previous-and-next-month-buttons-not-appearing-in-ie","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/6906\/previous-and-next-month-buttons-not-appearing-in-ie","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":319,"name":"Archived 2017 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2017","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":234,"urlcode":"Health-care","name":"Healthcare"},{"tagID":241,"urlcode":"Calendar","name":"Calendar View"}],"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":6908,"type":"discussion","name":"Sharing and Limiting Report Information","excerpt":"Scenerio - I have a MASTER sheet that I am using to communicate with different contractors via individualized reports. The contractors are required to make updates to several fields. Once I assign a line or job to a contractor - it shows up on their individual report. Each line\/job has contract specific details in the form…","categoryID":319,"dateInserted":"2017-01-09T11:54:37+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-01-09T12:15:08+00:00","insertUserID":8628,"insertUser":{"userID":8628,"name":"Roger Varner","url":"https:\/\/community.smartsheet.com\/profile\/Roger%20Varner","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-12-29T10:30:56+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":4374,"lastUser":{"userID":4374,"name":"J. Craig Williams","title":"","url":"https:\/\/community.smartsheet.com\/profile\/J.%20Craig%20Williams","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/74\/da\/n74da5fe4ff9c5b38c13d6409a3c883a3.jpg","dateLastActive":"2023-05-13T18:07:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":3,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/6908\/sharing-and-limiting-report-information","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/6908\/sharing-and-limiting-report-information","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":319,"name":"Archived 2017 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2017","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":218,"urlcode":"Construction","name":"Construction"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"}],"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":6905,"type":"discussion","name":"Change Request - Remove ability to edit filters.....","excerpt":"For users of level permission, turn off their ability to modify \/ duplicate filters on sheets that have been shared to them. The filters I give them with a sheet are the filters I want them to use, no other! The minute they see that they can duplicate \/ change filters our workflow is hosed. You are on…","categoryID":319,"dateInserted":"2017-01-07T10:14:45+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-01-09T12:04:01+00:00","insertUserID":3399,"insertUser":{"userID":3399,"name":"Jeremy Myers","url":"https:\/\/community.smartsheet.com\/profile\/Jeremy%20Myers","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-03-23T12:16:40+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":195,"lastUser":{"userID":195,"name":"Shaine Greenwood","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Shaine%20Greenwood","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/198\/nBSBY6VR571R7.jpg","dateLastActive":"2021-08-30T16:03:52+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":213,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/6905\/change-request-remove-ability-to-edit-filters","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/6905\/change-request-remove-ability-to-edit-filters","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/community.smartsheet.com\/sites\/all\/libraries\/tinymce\/jscripts\/tiny_mce\/plugins\/emotions\/img\/smiley-tongue-out.gif","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Tongue Out"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":319,"name":"Archived 2017 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2017","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":245,"urlcode":"Sharing","name":"Sharing and Collaboration"},{"tagID":391,"urlcode":"product-development","name":"Product Development"}],"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":6904,"type":"discussion","name":"Timesaving Features - Please!","excerpt":"1. When in Admin mode, ability to actually lock rows and columns on the sheet you are working on. Lackcing this, we throw away one seat on the three user system as we use Admin exclusively for programming, building filters and administrating the Workspaces. 2. Double click on format painter holdls the sample in memory…","categoryID":319,"dateInserted":"2017-01-07T10:04:56+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-01-09T11:54:49+00:00","insertUserID":3399,"insertUser":{"userID":3399,"name":"Jeremy Myers","url":"https:\/\/community.smartsheet.com\/profile\/Jeremy%20Myers","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-03-23T12:16:40+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":195,"lastUser":{"userID":195,"name":"Shaine Greenwood","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Shaine%20Greenwood","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/198\/nBSBY6VR571R7.jpg","dateLastActive":"2021-08-30T16:03:52+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":11,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/6904\/timesaving-features-please","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/6904\/timesaving-features-please","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":319,"name":"Archived 2017 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2017","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":391,"urlcode":"product-development","name":"Product Development"}],"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":6903,"type":"discussion","name":"Totals by Month using a date column","excerpt":"Is there a formula to count the # of entries for each month, using a system created date column? It seems like this doesn't exist unless you create a new column that says either 12 or December by looking at the date column.. thanks!","categoryID":319,"dateInserted":"2017-01-07T00:08:24+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-01-07T04:04:25+00:00","insertUserID":3026,"insertUser":{"userID":3026,"name":"Olga N Barabash","url":"https:\/\/community.smartsheet.com\/profile\/Olga%20N%20Barabash","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-03-09T12:53:55+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":4374,"lastUser":{"userID":4374,"name":"J. Craig Williams","title":"","url":"https:\/\/community.smartsheet.com\/profile\/J.%20Craig%20Williams","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/74\/da\/n74da5fe4ff9c5b38c13d6409a3c883a3.jpg","dateLastActive":"2023-05-13T18:07:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":302,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/6903\/totals-by-month-using-a-date-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/6903\/totals-by-month-using-a-date-column","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":319,"name":"Archived 2017 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2017","allowedDiscussionTypes":["discussion","question"]},"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":6902,"type":"discussion","name":"Return 1st Day of Month for a Date","excerpt":"I am trying to avoid complex formulas however have not found a better work around. Objective: Column\/Cell includes a Date, I would like a second column cell to return the Month for that cell Example: Column: Invoice | Column: SchedMos May 15, 2016 | May 1, 2016 =Mos(Invoice1) June 22, 2017 | June 1, 2017 I am familiar with…","categoryID":319,"dateInserted":"2017-01-06T18:07:48+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-01-07T03:51:01+00:00","insertUserID":4864,"insertUser":{"userID":4864,"name":"Wanda T","url":"https:\/\/community.smartsheet.com\/profile\/Wanda%20T","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-01-06T17:52:42+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":4374,"lastUser":{"userID":4374,"name":"J. Craig Williams","title":"","url":"https:\/\/community.smartsheet.com\/profile\/J.%20Craig%20Williams","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/74\/da\/n74da5fe4ff9c5b38c13d6409a3c883a3.jpg","dateLastActive":"2023-05-13T18:07:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":1738,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/6902\/return-1st-day-of-month-for-a-date","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/6902\/return-1st-day-of-month-for-a-date","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":319,"name":"Archived 2017 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2017","allowedDiscussionTypes":["discussion","question"]},"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":6895,"type":"discussion","name":"Conditional formatting across multiple sheets","excerpt":"Is it possible to set conditional formatting to move an item from one sheet to another once it is completed?","categoryID":319,"dateInserted":"2017-01-05T20:32:43+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-01-06T19:56:15+00:00","insertUserID":10186,"insertUser":{"userID":10186,"name":"Elysse Goddard","url":"https:\/\/community.smartsheet.com\/profile\/Elysse%20Goddard","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-01-05T20:30:13+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":10199,"lastUser":{"userID":10199,"name":"Kaylin Aarts","url":"https:\/\/community.smartsheet.com\/profile\/Kaylin%20Aarts","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-03-09T21:53:02+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":2,"countViews":31,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/6895\/conditional-formatting-across-multiple-sheets","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/6895\/conditional-formatting-across-multiple-sheets","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":319,"name":"Archived 2017 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2017","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":261,"urlcode":"Account and User Management","name":"Account and User 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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">
Hi @Neil Watson<\/a> <\/p>

Great idea! Yes, this is definitely possible, and I would do it exactly as you said. <\/p>

\"List Columns\"<\/p>

\n
\n \n \"Screenshot<\/img><\/a>\n <\/div>\n<\/div>\n

<\/p>


<\/p>

Then you can use the Array from the List Columns output as the Number of Runs in your Child Workflow Module:<\/p>


<\/p>


<\/p>


<\/p>

<\/p>

\n
\n \n \"Screenshot<\/img><\/a>\n <\/div>\n<\/div>\n


<\/p>

In your Child Workflow, all you would need to do is include the {{runtime.data.column_id}} as both the Column ID and the Column Description in an Update Column module.<\/p>


<\/p>


<\/p>


<\/p>


<\/p>

I've hard-coded the sheet ID in there but you can make that dynamic as well depending on how you're passing that through the Parent workflow. <\/p>

\n
\n \n \"Screenshot<\/img><\/a>\n <\/div>\n<\/div>\n

Cheers,<\/p>

Genevieve<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":["discussion","question"]},"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}],"tags":[]},{"discussionID":107335,"type":"question","name":"SUMIFS - Stumped on calculation to figure out if within a month","excerpt":"Hi All, I am using SUMIFS to calculate if a part is in the Spend Formulas Range sheet and then if that same part has a Date that is within the month of January. The formula seems to break when the dates come in. =SUMIFS({2023 Spend Formulas Range 1}, {2023 Spend Formulas Range 2}, [Original Material #]@row,…","snippet":"Hi All, I am using SUMIFS to calculate if a part is in the Spend Formulas Range sheet and then if that same part has a Date that is within the month of January. The formula seems…","categoryID":322,"dateInserted":"2023-07-07T12:42:16+00:00","dateUpdated":null,"dateLastComment":"2023-07-07T18:51:25+00:00","insertUserID":151347,"insertUser":{"userID":151347,"name":"MegBurns23","url":"https:\/\/community.smartsheet.com\/profile\/MegBurns23","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!3JFev2akC_o!bRNeG5LETzw!9HYHhXoqNPO","dateLastActive":"2023-07-07T19:28:35+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":151347,"lastUser":{"userID":151347,"name":"MegBurns23","url":"https:\/\/community.smartsheet.com\/profile\/MegBurns23","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!3JFev2akC_o!bRNeG5LETzw!9HYHhXoqNPO","dateLastActive":"2023-07-07T19:28:35+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":58,"score":null,"hot":3377493221,"url":"https:\/\/community.smartsheet.com\/discussion\/107335\/sumifs-stumped-on-calculation-to-figure-out-if-within-a-month","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107335\/sumifs-stumped-on-calculation-to-figure-out-if-within-a-month","format":"Rich","lastPost":{"discussionID":107335,"commentID":384224,"name":"Re: SUMIFS - Stumped on calculation to figure out if within a month","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/384224#Comment_384224","dateInserted":"2023-07-07T18:51:25+00:00","insertUserID":151347,"insertUser":{"userID":151347,"name":"MegBurns23","url":"https:\/\/community.smartsheet.com\/profile\/MegBurns23","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!3JFev2akC_o!bRNeG5LETzw!9HYHhXoqNPO","dateLastActive":"2023-07-07T19:28:35+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-07T18:12:06+00:00","dateAnswered":"2023-07-07T13:19:00+00:00","acceptedAnswers":[{"commentID":384153,"body":"

You need something more like this:<\/p>

=SUMIFS({2023 Spend Formulas Range 1}, {2023 Spend Formulas Range 2}, [Original Material #]@row, {Date Range}, AND(IFERROR(MONTH(@cell), 0) = 1, IFERROR(YEAR(@cell), 0) = 2023)<\/strong>)<\/p>


<\/p>

Then yes. You can drop them all inside of a SUM function or you can add them all together.<\/p>

=SUM(SUMIFS(.....), SUMIFS(.....), SUMIFS(.....))<\/p>

or<\/p>

=SUMIFS(.....) + SUMIFS(.....) + SUMIFS(.....)<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"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}],"tags":[]},{"discussionID":107333,"type":"question","name":"Previous Month formula","excerpt":"Hi I'm in the process of creating MTD and Previous MTD helper columns. If the Create Date is current month, I want to check a box. I have this formula working perfectly. What I'm struggling with is previous MTD. If the Create Date is the previous month, then check a box. If the Create Date is older than previous month,…","snippet":"Hi I'm in the process of creating MTD and Previous MTD helper columns. If the Create Date is current month, I want to check a box. I have this formula working perfectly. What I'm…","categoryID":322,"dateInserted":"2023-07-07T12:17:35+00:00","dateUpdated":null,"dateLastComment":"2023-07-07T13:34:08+00:00","insertUserID":127983,"insertUser":{"userID":127983,"name":"Carol-Anne Cerbone","url":"https:\/\/community.smartsheet.com\/profile\/Carol-Anne%20Cerbone","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!h1jY4Qxc4TY!prNYaQRZvvo!a6wiwaB2GsY","dateLastActive":"2023-07-07T13:35:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":151203,"lastUser":{"userID":151203,"name":"Nick Korna","url":"https:\/\/community.smartsheet.com\/profile\/Nick%20Korna","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-07T16:06:46+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":33,"score":null,"hot":3377470903,"url":"https:\/\/community.smartsheet.com\/discussion\/107333\/previous-month-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107333\/previous-month-formula","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":107333,"commentID":384162,"name":"Re: Previous Month formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/384162#Comment_384162","dateInserted":"2023-07-07T13:34:08+00:00","insertUserID":151203,"insertUser":{"userID":151203,"name":"Nick Korna","url":"https:\/\/community.smartsheet.com\/profile\/Nick%20Korna","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-07T16:06:46+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-07T13:23:44+00:00","dateAnswered":"2023-07-07T13:06:50+00:00","acceptedAnswers":[{"commentID":384144,"body":"

Hi @Carol-Anne Cerbone<\/a>,<\/p>

If you're just wanting the month to compare to last (e.g. July today vs. June last), then this will do what you're after:<\/p>

=IF(AND(YEAR(Created@row) = YEAR(TODAY()), MONTH(Created@row) = (MONTH(TODAY())) - 1), 1)<\/p>

Hope this helps! 😊<\/span><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"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}],"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&siteSectionID=0&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":10000,"limit":3},"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending Posts