公式和函数

= TODAY(), [Order Date]3 < TODAY(+7)), \"Yellow\", \"Green\")) My formula =IF([% Complete]@row < 70%, ''RED'', IF(AND([% Complete]@row <= 70%, [%…","categoryID":322,"dateInserted":"2020-12-16T07:50:10+00:00","dateUpdated":null,"dateLastComment":"2020-12-16T10:14:37+00:00","insertUserID":88961,"insertUser":{"userID":88961,"name":"Abdelhadi Said","url":"https:\/\/community.smartsheet.com\/profile\/Abdelhadi%20Said","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-12-17T09:45:58+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-05-06T18:54:39+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":75,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/74075\/if-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/74075\/if-formula","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-12-16T09:30:05+00:00","dateAnswered":"2020-12-16T08:54:57+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":74026,"type":"question","name":"Determine the Finish Date using NETWORKDAYS","excerpt":"Hi all, We have a group of tasks that commence on a given date. [ISSUE DATE] We would like to automatically populate the adjacent cell with a date, which is +5 business days from the ISSUE DATE. I'm assuming we need to use the NETWORKDAYS formula but I can't determine how to achieve this. Thanks for your assistance.…","categoryID":322,"dateInserted":"2020-12-15T03:08:01+00:00","dateUpdated":null,"dateLastComment":"2020-12-16T00:35:50+00:00","insertUserID":87801,"insertUser":{"userID":87801,"name":"Richard Heath","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Richard%20Heath","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/PQ5MK3GA3T0T\/nRH0VLM6IQ91L.jpg","dateLastActive":"2023-05-04T23:07:42+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":126171,"lastUser":{"userID":126171,"name":"Mark Cronk","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mark%20Cronk","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/9UVGVH5TN00I\/nO060PSRF4UVU.jpg","dateLastActive":"2023-05-05T17:42:25+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":76,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/74026\/determine-the-finish-date-using-networkdays","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/74026\/determine-the-finish-date-using-networkdays","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-12-15T03:44:33+00:00","dateAnswered":"2020-12-15T03:42:11+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":74000,"type":"question","name":"Pull month and year","excerpt":"Is there a way to pull the date and year from one column to another? I am currently using the following formula to pull the year out of the Report date column. Report Column. Mandated Date Column 10\/8\/2020 =IFERROR(YEAR([Validation Report IA Date]@row) + 1, \"//www.santa-greenland.com/community/categories/formulas-and-functions/\") I would like the \"Mandated Date Column\" to display the…","categoryID":322,"dateInserted":"2020-12-14T15:59:23+00:00","dateUpdated":"2020-12-14T15:59:42+00:00","dateLastComment":"2020-12-15T21:05:44+00:00","insertUserID":66106,"insertUser":{"userID":66106,"name":"Peggy Parchert","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Peggy%20Parchert","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/YYRDMWWFX83G\/nC7HLGW82ACPT.jpg","dateLastActive":"2023-05-03T16:39:20+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":66106,"lastUserID":66106,"lastUser":{"userID":66106,"name":"Peggy Parchert","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Peggy%20Parchert","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/YYRDMWWFX83G\/nC7HLGW82ACPT.jpg","dateLastActive":"2023-05-03T16:39:20+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":1451,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/74000\/pull-month-and-year","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/74000\/pull-month-and-year","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-12-15T21:05:01+00:00","dateAnswered":"2020-12-15T20:59:24+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":74048,"type":"question","name":"Flagging a cell based on checkmarks","excerpt":"Hello, I need a cell to flag if there is a check mark within a range of cells. I currently have a box checked if the schedule date matches a date in another column. The box checks if the Install Date matches the test date so I am thinking that if there are any check boxes within those columns I should raise the flag. At a…","categoryID":322,"dateInserted":"2020-12-15T16:46:14+00:00","dateUpdated":null,"dateLastComment":"2020-12-15T19:03:19+00:00","insertUserID":117744,"insertUser":{"userID":117744,"name":"Sharon Castiglia","url":"https:\/\/community.smartsheet.com\/profile\/Sharon%20Castiglia","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-07-15T22:08:02+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":117744,"lastUser":{"userID":117744,"name":"Sharon Castiglia","url":"https:\/\/community.smartsheet.com\/profile\/Sharon%20Castiglia","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-07-15T22:08:02+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":196,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/74048\/flagging-a-cell-based-on-checkmarks","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/74048\/flagging-a-cell-based-on-checkmarks","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-12-15T17:43:49+00:00","dateAnswered":"2020-12-15T17:31:46+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":74055,"type":"question","name":"Filling in an email address in a workflow in an automation workflow form","excerpt":"I have an automation workflow that requests an update through a simple form. One block on the form asks the receiver to complete the email of someone who should be notified (the question is tied to a Contact List column in the main sheet). In testing, when the user tries to type in the email address, the form locks up…","categoryID":322,"dateInserted":"2020-12-15T18:01:21+00:00","dateUpdated":null,"dateLastComment":"2020-12-15T18:05:54+00:00","insertUserID":129834,"insertUser":{"userID":129834,"name":"John Reynolds","url":"https:\/\/community.smartsheet.com\/profile\/John%20Reynolds","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!w5nf95qMA7w!xMHfsd63JP4!Ew9Sws668ou","dateLastActive":"2022-12-01T15:38: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-05-06T18:54:39+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":51,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/74055\/filling-in-an-email-address-in-a-workflow-in-an-automation-workflow-form","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/74055\/filling-in-an-email-address-in-a-workflow-in-an-automation-workflow-form","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":74034,"type":"question","name":"if formulas, and adding status symbol (Empty, Quarter, Half, Three Quarter, Full )","excerpt":"Good morning! I need some help with these Smartsheet Formulas. I don't even know if it is possible, but I am trying to get a formula written that captures the status of column \"Complete Date\". As people fill in the date they completed their task, it will translate the status symbol to the appropriate amount. I am just…","categoryID":322,"dateInserted":"2020-12-15T13:42:21+00:00","dateUpdated":null,"dateLastComment":"2020-12-15T17:41:13+00:00","insertUserID":127896,"insertUser":{"userID":127896,"name":"Tara Knox","url":"https:\/\/community.smartsheet.com\/profile\/Tara%20Knox","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nW1W8KHNFR845.png","dateLastActive":"2020-12-18T12:46:30+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-05-05T20:35:59+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":151,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/74034\/if-formulas-and-adding-status-symbol-empty-quarter-half-three-quarter-full","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/74034\/if-formulas-and-adding-status-symbol-empty-quarter-half-three-quarter-full","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/VB3EP1WSAPGQ\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.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":[{"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":74046,"type":"question","name":"DropDown list - from another Sheet","excerpt":"hello , i have a huge list to be added in Dropdown, Does Smartsheet have option to pull the Dropdown from another sheet, (similar to excel spreadsheet).? Since the list will be Dynamic, editing the downdrop list everytime is time consuming. thanks Vasanth","categoryID":322,"dateInserted":"2020-12-15T16:27:21+00:00","dateUpdated":null,"dateLastComment":"2020-12-15T16:30:52+00:00","insertUserID":129673,"insertUser":{"userID":129673,"name":"Vasanth Balakrishnan","url":"https:\/\/community.smartsheet.com\/profile\/Vasanth%20Balakrishnan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-04-21T18:44:14+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-05-06T18:54:39+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":232,"score":1,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/74046\/dropdown-list-from-another-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/74046\/dropdown-list-from-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":[{"tagID":283,"urlcode":"Enhancement Request","name":"Enhancement Request"},{"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":72523,"type":"question","name":"Search for assigned manager, then get list of direct reports","excerpt":"Hi - I am trying to create a formula in a Contact List column that returns all the people reporting to a manager. I do not know the best way to build this formula. Would someone kindly help me with the best way to do this, and possibly get me started with a formula? In the images below is my prototype. I have 5 employees…","categoryID":322,"dateInserted":"2020-10-23T18:27:21+00:00","dateUpdated":"2020-10-23T18:31:40+00:00","dateLastComment":"2020-12-15T16:24:30+00:00","insertUserID":127948,"insertUser":{"userID":127948,"name":"Mary A","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mary%20A","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-12-15T16:22:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":127948,"lastUserID":127948,"lastUser":{"userID":127948,"name":"Mary A","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mary%20A","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-12-15T16:22:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":111,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/72523\/search-for-assigned-manager-then-get-list-of-direct-reports","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/72523\/search-for-assigned-manager-then-get-list-of-direct-reports","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/A287RU4TKC5T\/screen-shot-2020-10-23-at-11-18-36-am.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screen Shot 2020-10-23 at 11.18.36 AM.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":74014,"type":"question","name":"Calculate column running total from ONLY last 12 months","excerpt":"I want my columns to be like this.. Column A (Month & Year) Column B ($ in) and Column 3 (Running total from last twelve months) Any help would be appreciated! Thanks🦓","categoryID":322,"dateInserted":"2020-12-14T20:42:57+00:00","dateUpdated":null,"dateLastComment":"2020-12-15T15:19:56+00:00","insertUserID":129255,"insertUser":{"userID":129255,"name":"Sofia Fernandez","url":"https:\/\/community.smartsheet.com\/profile\/Sofia%20Fernandez","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AOh14GjZHC7s_-ktvL7lerl1-yFl2KrtocNOsZK8LCOnpw=s96-c","dateLastActive":"2021-07-16T02:13:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":129255,"lastUser":{"userID":129255,"name":"Sofia Fernandez","url":"https:\/\/community.smartsheet.com\/profile\/Sofia%20Fernandez","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AOh14GjZHC7s_-ktvL7lerl1-yFl2KrtocNOsZK8LCOnpw=s96-c","dateLastActive":"2021-07-16T02:13:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":213,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/74014\/calculate-column-running-total-from-only-last-12-months","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/74014\/calculate-column-running-total-from-only-last-12-months","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-12-15T15:19:37+00:00","dateAnswered":"2020-12-15T01:07: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":[],"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}">

帮助文章参考资料欧宝体育app官方888