Explore. Ask. Answer

TODAY(-7)) Once we get it for this sheet, we want to do the same for a few sheets and add them all together to know the total. we use this sheet as…","categoryID":322,"dateInserted":"2023-08-14T15:34:26+00:00","dateUpdated":null,"dateLastComment":"2023-08-14T19:23:25+00:00","insertUserID":162138,"insertUser":{"userID":162138,"name":"Louis.Smith","url":"https:\/\/community.smartsheet.com\/profile\/Louis.Smith","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-23T14:00:50+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-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":56,"score":null,"hot":3384070071,"url":"https:\/\/community.smartsheet.com\/discussion\/108917\/we-are-trying-to-count-how-many-applicants-applied-in-the-last-7-days-for-delta-client","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108917\/we-are-trying-to-count-how-many-applicants-applied-in-the-last-7-days-for-delta-client","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/EG0FIX4THYRK\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-08-14T16:05: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":95362,"type":"question","name":"\"Row Moved\" not in Cell History when called by the API?","excerpt":"\"When I call \"List Cell History\" with the API the \"Row was moved from another sheet\" does not show up. Am I doing something wrong? Why can't I get this cell history?","categoryID":320,"dateInserted":"2022-09-14T17:57:27+00:00","dateUpdated":null,"dateLastComment":"2023-08-14T19:15:32+00:00","insertUserID":137019,"insertUser":{"userID":137019,"name":"Samuel Mueller","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Samuel%20Mueller","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B9G8B70WXQWC\/nKTI46EH9WQOM.jpg","dateLastActive":"2023-08-25T18:19:58+00:00","banned":0,"punished":0,"private":false,"label":"Overachievers"},"updateUserID":null,"lastUserID":148386,"lastUser":{"userID":148386,"name":"dsmitts.jay","url":"https:\/\/community.smartsheet.com\/profile\/dsmitts.jay","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!Asq033UutIg!DAu0A77Sx_w!NYd7SSBcGwv","dateLastActive":"2023-08-20T18:41:52+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":17,"countViews":291,"score":null,"hot":3355228979,"url":"https:\/\/community.smartsheet.com\/discussion\/95362\/row-moved-not-in-cell-history-when-called-by-the-api","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95362\/row-moved-not-in-cell-history-when-called-by-the-api","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/CAP8QN53VK1V\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-10-04T15:06:13+00:00","dateAnswered":"2022-09-29T05:09:55+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","allowedDiscussionTypes":[]},"tags":[{"tagID":227,"urlcode":"api-and-developers","name":"API and Developers"},{"tagID":369,"urlcode":"bridge-by-smartsheet","name":"Bridge"},{"tagID":447,"urlcode":"activity-log","name":"Activity Log"}],"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":108833,"type":"question","name":"Has anyone seen this error when copying rows to another sheet?","excerpt":"At first I thought it was because a was trying to move about 100 rows at once, but then I tried with just one row and it keeps showing. I also tried changing my internet connection from WiFi to Ethernet but the error stays. Also, sometimes even the error shows, it still performs the copy but it copy the rows 2, 3 or 4…","categoryID":321,"dateInserted":"2023-08-11T00:18:10+00:00","dateUpdated":null,"dateLastComment":"2023-08-14T19:03:04+00:00","insertUserID":158836,"insertUser":{"userID":158836,"name":"Roberto Cordero","url":"https:\/\/community.smartsheet.com\/profile\/Roberto%20Cordero","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-25T18:02:56+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":158836,"lastUser":{"userID":158836,"name":"Roberto Cordero","url":"https:\/\/community.smartsheet.com\/profile\/Roberto%20Cordero","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-25T18:02:56+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":62,"score":null,"hot":3383754074,"url":"https:\/\/community.smartsheet.com\/discussion\/108833\/has-anyone-seen-this-error-when-copying-rows-to-another-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108833\/has-anyone-seen-this-error-when-copying-rows-to-another-sheet","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/70Z4MJ9LSM06\/copy-rows-error.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Copy rows Error.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-14T19:03:10+00:00","dateAnswered":"2023-08-11T01:29:52+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":71137,"type":"question","name":"Impact of deleting\/removing a user","excerpt":"What is the impact of deleting a user if they were previously an owner of sheet and groups? (Note; I have already transferred all of their items to someone else, but they were the original author of these sheets and had input (row entries and comments alike) . I don't want to lose knowing what they did in the past in case…","categoryID":321,"dateInserted":"2020-09-08T14:08:10+00:00","dateUpdated":null,"dateLastComment":"2023-08-14T19:00:23+00:00","insertUserID":120700,"insertUser":{"userID":120700,"name":"Rich Stowell","url":"https:\/\/community.smartsheet.com\/profile\/Rich%20Stowell","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-09T21:05:41+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":165068,"lastUser":{"userID":165068,"name":"imayes","url":"https:\/\/community.smartsheet.com\/profile\/imayes","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-14T20:04:57+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":446,"score":null,"hot":3291616113,"url":"https:\/\/community.smartsheet.com\/discussion\/71137\/impact-of-deleting-removing-a-user","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/71137\/impact-of-deleting-removing-a-user","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2021-02-01T13:12:35+00:00","dateAnswered":"2020-09-08T14:45:58+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":319,"urlcode":"functionality","name":"functionality"},{"tagID":549,"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}]},{"discussionID":108812,"type":"question","name":"more than 1 resource assigned to a task","excerpt":"When there is more than 1 resource assigned to a task (Ex: 2 people) and change in RM the percentage of allocation of Resource number 1 , it automatically set the same percentage of allocation to the second ressource. How can we differenciate the specific allocation distinctively other than having to create a second liner…","categoryID":355,"dateInserted":"2023-08-10T18:12:29+00:00","dateUpdated":"2023-08-10T18:35:13+00:00","dateLastComment":"2023-08-14T18:46:42+00:00","insertUserID":164933,"insertUser":{"userID":164933,"name":"Louis Gaudet ","title":"Sr Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/Louis%20Gaudet%20","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-22T17:00:59+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":164933,"lastUser":{"userID":164933,"name":"Louis Gaudet ","title":"Sr Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/Louis%20Gaudet%20","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-22T17:00:59+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":93,"score":null,"hot":3383731151,"url":"https:\/\/community.smartsheet.com\/discussion\/108812\/more-than-1-resource-assigned-to-a-task","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108812\/more-than-1-resource-assigned-to-a-task","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-08-11T21:02:59+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":355,"name":"Resource Management","url":"https:\/\/community.smartsheet.com\/categories\/resource-management","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":468,"urlcode":"resource-management","name":"Resource 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}">