functionality

=DATE(2019, 1, 7)), {GRAD Student - Support Request Time Spent Range}) Complete Date = the date range I'm trying to pull from After the \"And\"= The range I want for the dates. Time Spent = The location…","categoryID":322,"dateInserted":"2020-01-03T15:37:39+00:00","dateUpdated":"2020-01-03T16:22:46+00:00","dateLastComment":"2020-01-03T18:07:35+00:00","insertUserID":115074,"insertUser":{"userID":115074,"name":"Sye Williams","url":"https:\/\/community.smartsheet.com\/profile\/Sye%20Williams","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AAuE7mDI4XmU855YyBIfDw60CbVmbUIVVLwhYGUmdITGwg","dateLastActive":"2020-01-03T18:08:28+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":115074,"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-06-27T17:44:46+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":163,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/65014\/help-using-sumif-formula-to-calculate-the-sum-of-a-column-if-between-certain-dates","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/65014\/help-using-sumif-formula-to-calculate-the-sum-of-a-column-if-between-certain-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":[{"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}]},{"discussionID":65015,"type":"discussion","name":"Using Modified Date in a formula returns #date Expected","excerpt":"Hello, I am trying to determine whether or not a row should be added to a weekly report by trying use the modified system column to calculate the associated Friday. e.g. It's Tuesday and I make a change, I want my other column 'Report week end date' to display that upcoming Friday. =IF(WEEKDAY(Modified@row) < 6,…","categoryID":322,"dateInserted":"2020-01-03T16:10:14+00:00","dateUpdated":null,"dateLastComment":"2020-01-03T18:04:08+00:00","insertUserID":115075,"insertUser":{"userID":115075,"name":"Mark Morris","url":"https:\/\/community.smartsheet.com\/profile\/Mark%20Morris","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-01-22T16:52:11+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-06-27T17:44:46+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":496,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/65015\/using-modified-date-in-a-formula-returns-date-expected","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/65015\/using-modified-date-in-a-formula-returns-date-expected","format":"Rich","groupID":null,"statusID":0,"attributes":{},"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":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}]},{"discussionID":64938,"type":"question","name":"When creating\/using forms, is there a way to have the formatting of a entry pull over to the form?","excerpt":"I am looking for a way to enter a list into a form and have it pulled into the sheet \"stacked\" instead of run together.","categoryID":321,"dateInserted":"2019-12-27T14:36:22+00:00","dateUpdated":"2019-12-27T14:36:53+00:00","dateLastComment":"2020-01-03T14:23:07+00:00","insertUserID":6036,"insertUser":{"userID":6036,"name":"Amy Burns","url":"https:\/\/community.smartsheet.com\/profile\/Amy%20Burns","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-01\/df\/ba\/ndfbaf51efe9385416d5d7fe6b7287cbf.jpg","dateLastActive":"2022-02-08T18:39:48+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":6036,"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-06-27T17:44:46+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":10,"countViews":87,"score":null,"hot":10,"url":"https:\/\/community.smartsheet.com\/discussion\/64938\/when-creating-using-forms-is-there-a-way-to-have-the-formatting-of-a-entry-pull-over-to-the-form","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/64938\/when-creating-using-forms-is-there-a-way-to-have-the-formatting-of-a-entry-pull-over-to-the-form","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-01-03T14:09:02+00:00","dateAnswered":"2020-01-02T22:51:41+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":204,"urlcode":"Forms","name":"Forms"},{"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}]},{"discussionID":64975,"type":"discussion","name":"Linked cells not showing in dashboard report","excerpt":"I have a dashboard that surfaces a report in which the duration value cells is blank. The report source data is in a row report. The duration value is visible in the row report. The source the duration value is a sheet in which it is also visible. I have refreshed the report but as the duration is automatic I cant do much…","categoryID":322,"dateInserted":"2020-01-01T21:26:38+00:00","dateUpdated":null,"dateLastComment":"2020-01-01T21:26:38+00:00","insertUserID":112016,"insertUser":{"userID":112016,"name":"Phil Wightman","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Phil%20Wightman","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-11\/35\/2e\/n352e0e53bf6c86b6f26b8d2be7cf0153.JPG","dateLastActive":"2023-06-26T04:04:39+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":112016,"lastUser":{"userID":112016,"name":"Phil Wightman","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Phil%20Wightman","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-11\/35\/2e\/n352e0e53bf6c86b6f26b8d2be7cf0153.JPG","dateLastActive":"2023-06-26T04:04:39+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":170,"score":1,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/64975\/linked-cells-not-showing-in-dashboard-report","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/64975\/linked-cells-not-showing-in-dashboard-report","format":"Rich","groupID":null,"statusID":0,"attributes":{},"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":319,"urlcode":"functionality","name":"functionality"},{"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":64935,"type":"question","name":"Reporting Question: create a report that aggregates Column information","excerpt":"Hi, I am trying to create a report that aggregates Column information based on a Condition. For example I have the following columns: -Track -Track Status -Days I would like to know a roll-up of the status by Track and then use days as a filter criteria. So if the days are 30, it would show status for just those that are…","categoryID":321,"dateInserted":"2019-12-26T20:50:43+00:00","dateUpdated":"2020-06-11T14:47:41+00:00","dateLastComment":"2020-01-01T11:17:28+00:00","insertUserID":114642,"insertUser":{"userID":114642,"name":"Paul Raphael","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Raphael","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-01-02T19:05:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"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-06-26T16:24:30+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":223,"score":null,"hot":6,"url":"https:\/\/community.smartsheet.com\/discussion\/64935\/reporting-question-create-a-report-that-aggregates-column-information","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/64935\/reporting-question-create-a-report-that-aggregates-column-information","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":265,"urlcode":"Reports","name":"Reports"},{"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}]},{"discussionID":64961,"type":"question","name":"Viewing Deliverable for Multiple Projects by Month - NOT in a Gantt : )","excerpt":"So...any creative ideas for how to achieve something similar to the attached image IN Smartsheet? We want to visual represent high level deliverables across multiple projects for the entire year by Month, however, NOT in a Gantt view and we want it as a 1-pager. Thoughts? Ideas?","categoryID":321,"dateInserted":"2019-12-31T00:17:57+00:00","dateUpdated":null,"dateLastComment":"2019-12-31T11:40:40+00:00","insertUserID":76911,"insertUser":{"userID":76911,"name":"LLaCosta","url":"https:\/\/community.smartsheet.com\/profile\/LLaCosta","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-11\/eb\/4f\/neb4fcae44b5a51af5f1be84de080b4f2.jpg","dateLastActive":"2020-07-20T14:04:21+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-06-27T18:07:15+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":127,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/64961\/viewing-deliverable-for-multiple-projects-by-month-not-in-a-gantt","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/64961\/viewing-deliverable-for-multiple-projects-by-month-not-in-a-gantt","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/969\/LNSQIAAU1SKN.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"project deliverables by month.JPG"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":241,"urlcode":"Calendar","name":"Calendar View"},{"tagID":319,"urlcode":"functionality","name":"functionality"},{"tagID":439,"urlcode":"gantt-view","name":"Gantt 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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">