Formulas and Functions

20, COUNT(ANCESTORS(ID@row)) = 0), AssigneeEmails@row,…","categoryID":322,"dateInserted":"2020-11-11T18:22:20+00:00","dateUpdated":null,"dateLastComment":"2020-11-19T18:42:43+00:00","insertUserID":31866,"insertUser":{"userID":31866,"name":"aaboueid","url":"https:\/\/community.smartsheet.com\/profile\/aaboueid","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!kvFef2Qedvo!p_Hd6ZxI3n4!BRZh6a6R2Z4","dateLastActive":"2021-04-14T15:49:19+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-07-14T04:19:01+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":142,"score":null,"hot":6,"url":"https:\/\/community.smartsheet.com\/discussion\/73082\/struggling-to-send-automated-approval-requests-to-multiple-contacts-generated-by-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/73082\/struggling-to-send-automated-approval-requests-to-multiple-contacts-generated-by-formula","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2021-03-16T16:45:50+00:00","dateAnswered":"2020-11-12T16:50:40+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":73303,"type":"question","name":"SUMIFS between specific cells","excerpt":"Hi! I want to sum the values in a column only if the values are between cells 2 to 729 and only if \"Nina Gallagher\" is in the \"Who\" column I've gotten this far -- =SUMIFS([10\/5\/20]:[10\/5\/20], Who:Who, =\"Nina Gallagher\") When I try this, I get #INCORRECT ARGUMENT -- =SUMIFS([10\/5\/20]2:[10\/5\/20]729, Who:Who, =\"Nina…","categoryID":322,"dateInserted":"2020-11-19T00:16:22+00:00","dateUpdated":null,"dateLastComment":"2020-11-19T16:47:05+00:00","insertUserID":42221,"insertUser":{"userID":42221,"name":"clairee42221","url":"https:\/\/community.smartsheet.com\/profile\/clairee42221","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-01-05T16:32:37+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":11072,"lastUser":{"userID":11072,"name":"Mike Wilday","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20Wilday","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/749H48MC3045\/nF9FQYPTX0X7D.jpg","dateLastActive":"2023-07-13T20:11:34+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":61,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/73303\/sumifs-between-specific-cells","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/73303\/sumifs-between-specific-cells","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/3Y6YT541128O\/screen-shot-2020-11-18-at-7-13-27-pm.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screen Shot 2020-11-18 at 7.13.27 PM.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":73327,"type":"question","name":"Add a column for todays date automation","excerpt":"Can I insert a column that will automatically update today's date? I want to use it to compare today's date and contract date and the number of days between the two.","categoryID":322,"dateInserted":"2020-11-19T15:46:30+00:00","dateUpdated":null,"dateLastComment":"2020-11-19T16:32:43+00:00","insertUserID":119617,"insertUser":{"userID":119617,"name":"Lori Cross","url":"https:\/\/community.smartsheet.com\/profile\/Lori%20Cross","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!CSFVgud28_o!cznV59tI-rw!EebRnd7YrNT","dateLastActive":"2023-07-06T21:39:16+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-07-14T04:19:01+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":81,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/73327\/add-a-column-for-todays-date-automation","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/73327\/add-a-column-for-todays-date-automation","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":73247,"type":"question","name":"Vlookup from a Report","excerpt":"Is it possible to do a vlookup off a SmartSheet Report, i recall at the SmartSheet summit a few months ago this was going to be a new feature? When is it available?","categoryID":322,"dateInserted":"2020-11-18T01:25:59+00:00","dateUpdated":null,"dateLastComment":"2020-11-19T16:31:40+00:00","insertUserID":127104,"insertUser":{"userID":127104,"name":"Daniel Sullivan","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Daniel%20Sullivan","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!AxjPByi1PyQ!acNPmhCwbXw!zc9EuNVtjQU","dateLastActive":"2021-01-20T13:05:24+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-07-14T04:19:01+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":536,"score":1,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/73247\/vlookup-from-a-report","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/73247\/vlookup-from-a-report","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":73293,"type":"question","name":"Return Sundays Numbers as Friday","excerpt":"Pulling production numbers and am currently using the following formula to pull numbers from the previous day =SUMIFS({GF}, {Date}, TODAY(-1), {MN}, \"344\") GF = Good Footage being calculated Date = Date Submitted MN = Machine Number This formula works for Tuesday - Friday but come Monday morning I need to have the data…","categoryID":322,"dateInserted":"2020-11-18T20:19:38+00:00","dateUpdated":null,"dateLastComment":"2020-11-19T15:48:42+00:00","insertUserID":128936,"insertUser":{"userID":128936,"name":"Kevin Shirey","url":"https:\/\/community.smartsheet.com\/profile\/Kevin%20Shirey","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-12-07T18:24:42+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":128936,"lastUser":{"userID":128936,"name":"Kevin Shirey","url":"https:\/\/community.smartsheet.com\/profile\/Kevin%20Shirey","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-12-07T18:24:42+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":71,"score":null,"hot":9,"url":"https:\/\/community.smartsheet.com\/discussion\/73293\/return-sundays-numbers-as-friday","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/73293\/return-sundays-numbers-as-friday","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-11-23T13:11:31+00:00","dateAnswered":"2020-11-18T21:49:32+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":73323,"type":"question","name":"Lookup and fill in information based on another sheet","excerpt":"I have a large database of about 600 records. I created another sheet that comes off our institution's learning mgmt system showing several columns of information. In my database, I would like to put a formula in that would fill in several of my columns information, based on what course numbers are chosen. Can someone help…","categoryID":322,"dateInserted":"2020-11-19T14:51:30+00:00","dateUpdated":null,"dateLastComment":"2020-11-19T15:19:04+00:00","insertUserID":121230,"insertUser":{"userID":121230,"name":"Kris Peeters","url":"https:\/\/community.smartsheet.com\/profile\/Kris%20Peeters","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!zzjX8w2dwDY!5FVWucGjaaQ!-sgJ3Uz0EeO","dateLastActive":"2023-07-13T20:29:10+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-07-14T04:19:01+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":71,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/73323\/lookup-and-fill-in-information-based-on-another-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/73323\/lookup-and-fill-in-information-based-on-another-sheet","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":73298,"type":"question","name":"Recurring Date to Fall on Specific Day","excerpt":"Hi - I've set up two columns \"Cadence\" and \"Launch Date\". For the top row of my sheet, I've listed the start date of the month (i.e. November 2) under the Launch Date for formula purposes. From there, on another row, I have a task where it should be completed 3 weeks after the start date of the month, but fall on a Friday.…","categoryID":322,"dateInserted":"2020-11-18T22:03:52+00:00","dateUpdated":null,"dateLastComment":"2020-11-19T15:07:46+00:00","insertUserID":128940,"insertUser":{"userID":128940,"name":"Jessica Zell","url":"https:\/\/community.smartsheet.com\/profile\/Jessica%20Zell","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!ZHnTGZzkYr4!adtTGgSNbjo!YTbM9hAPEt9","dateLastActive":"2021-07-30T18:29:13+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":128940,"lastUser":{"userID":128940,"name":"Jessica Zell","url":"https:\/\/community.smartsheet.com\/profile\/Jessica%20Zell","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!ZHnTGZzkYr4!adtTGgSNbjo!YTbM9hAPEt9","dateLastActive":"2021-07-30T18:29:13+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":250,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/73298\/recurring-date-to-fall-on-specific-day","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/73298\/recurring-date-to-fall-on-specific-day","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-11-19T15:07:20+00:00","dateAnswered":"2020-11-19T01:59:17+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":73317,"type":"question","name":"If function for children rows","excerpt":"Hi all, I don't know how to build a formula for the following: I want the parent row to show ''Pass'' when ''Pass'' is filled in for ALL children rows. If one or more of the children rows has ''Fail'' or ''Suspend'', I want the parent row to show ''Fail''. The children rows refer to the children rows of the parent cell.…","categoryID":322,"dateInserted":"2020-11-19T12:04:19+00:00","dateUpdated":null,"dateLastComment":"2020-11-19T13:18:18+00:00","insertUserID":128957,"insertUser":{"userID":128957,"name":"Bas Hoogeveen","url":"https:\/\/community.smartsheet.com\/profile\/Bas%20Hoogeveen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-12-02T15:19:25+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":128957,"lastUser":{"userID":128957,"name":"Bas Hoogeveen","url":"https:\/\/community.smartsheet.com\/profile\/Bas%20Hoogeveen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-12-02T15:19:25+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":133,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/73317\/if-function-for-children-rows","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/73317\/if-function-for-children-rows","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-11-19T14:13:01+00:00","dateAnswered":"2020-11-19T12:49:22+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":281,"urlcode":"Support","name":"Support"}],"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":73017,"type":"question","name":"Calculating cumulative value on dates","excerpt":"Hi, I have a sheet with a product that i produce and i have two column \"in process\" and \"moved to stock\" date type. i want to see by graph the time that each product was in fabrication. for example: item A : in Process: 01 NOV 2020 Moved to stock: 18 NOV 2020 so basically, the item was in fabrication in WW45+ WW46 + WW47…","categoryID":322,"dateInserted":"2020-11-10T13:18:14+00:00","dateUpdated":"2020-11-10T13:18:55+00:00","dateLastComment":"2020-11-19T11:08:08+00:00","insertUserID":109836,"insertUser":{"userID":109836,"name":"Netanel yosef","url":"https:\/\/community.smartsheet.com\/profile\/Netanel%20yosef","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-19T10:54:18+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":109836,"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-07-14T08:14:27+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":266,"score":null,"hot":6,"url":"https:\/\/community.smartsheet.com\/discussion\/73017\/calculating-cumulative-value-on-dates","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/73017\/calculating-cumulative-value-on-dates","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":73262,"type":"question","name":"how to get sum of a column to include only certain date range","excerpt":"Please could someone help me with this? We have recently upgraded to be able to use the summary sheet as well as automated workflows, but neither of these have helped, and I think it maybe a simple formula issue? Basically, we use smartsheet for customers to place preorders of different products (approx 50 different…","categoryID":322,"dateInserted":"2020-11-18T13:51:01+00:00","dateUpdated":null,"dateLastComment":"2020-11-19T10:10:07+00:00","insertUserID":128909,"insertUser":{"userID":128909,"name":"Joanne Devenish","url":"https:\/\/community.smartsheet.com\/profile\/Joanne%20Devenish","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-04-20T21:44:57+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"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-07-14T08:14:27+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":838,"score":null,"hot":8,"url":"https:\/\/community.smartsheet.com\/discussion\/73262\/how-to-get-sum-of-a-column-to-include-only-certain-date-range","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/73262\/how-to-get-sum-of-a-column-to-include-only-certain-date-range","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-11-18T17:11:21+00:00","dateAnswered":"2020-11-18T16:04:01+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":204,"urlcode":"Forms","name":"Forms"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":319,"urlcode":"functionality","name":"functionality"}],"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