技术

TODAY(+7), \"Green\", IF(AND([Due Date]@row >= TODAY(+3), [Due Date]@row < TODAY(+7)), \"Yellow\", IF([Due Date]@row < TODAY(+3), \"Red\")))) What I want to do is create a…","categoryID":322,"dateInserted":"2019-11-04T00:35:07+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2021-04-23T11:40:00+00:00","insertUserID":103976,"insertUser":{"userID":103976,"name":"Bazza","url":"https:\/\/community.smartsheet.com\/profile\/Bazza","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-11-13T05:40: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":"2022-06-22T18:54:18+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":82,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/61846\/another-automate-ryg-balls-for-parent-based-on-child","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/61846\/another-automate-ryg-balls-for-parent-based-on-child","format":"Html","groupID":null,"statusID":0,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-04-22T15:22:36+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":228,"urlcode":"Project Management","name":"Project Management"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":270,"urlcode":"Technology","name":"Technology"}],"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":59271,"type":"question","name":"Email as form field and for copy of responses","excerpt":"My organization has just started using Smartsheet and I created my first form. I have a required \"Email\" field. I also enable the submitter the option to receive a email copy of their submission, which also requires an email. I announced the form and asked for feedback. Immediate and understandable feedback was, \"Why do I…","categoryID":321,"dateInserted":"2019-10-03T21:44:32+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2021-04-20T13:07:52+00:00","insertUserID":94326,"insertUser":{"userID":94326,"name":"jim.wilson94326","url":"https:\/\/community.smartsheet.com\/profile\/jim.wilson94326","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!bHDDmw0dQvQ!gk9AH9FQsHo!uKWEAKpRAFX","dateLastActive":"2020-11-12T12:32:27+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/NDZ9JFCTQ8E3\/n8CCYP0Y12F8V.png","dateLastActive":"2022-06-22T23:07:52+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":1087,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/59271\/email-as-form-field-and-for-copy-of-responses","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/59271\/email-as-form-field-and-for-copy-of-responses","format":"Html","groupID":null,"statusID":0,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-04-19T18:03:53+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":216,"urlcode":"Non-profit","name":"Non-profit"},{"tagID":228,"urlcode":"Project Management","name":"Project Management"},{"tagID":262,"urlcode":"Agriculture","name":"Agriculture"},{"tagID":270,"urlcode":"Technology","name":"Technology"},{"tagID":271,"urlcode":"Services","name":"Services"}],"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":57266,"type":"discussion","name":"Counting number of tasks per Assigned To contact","excerpt":"My task list contains parent, sub-parent, then children tasks. The workstream leader is assigned to both the parent and sub-parent tasks, and possibly sub-tasks as well. I need to count the number of tasks per \"Assigned To\" contact. It would be ideal if parent tasks are not included in that number, but it's manageable if…","categoryID":322,"dateInserted":"2019-09-09T11:23:06+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2021-04-12T13:38:57+00:00","insertUserID":103251,"insertUser":{"userID":103251,"name":"brenttopa","url":"https:\/\/community.smartsheet.com\/profile\/brenttopa","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-10-23T09:18:55+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":134709,"lastUser":{"userID":134709,"name":"Ollie Cater","url":"https:\/\/community.smartsheet.com\/profile\/Ollie%20Cater","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-04-29T10:47:14+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":12,"countViews":1016,"score":null,"hot":12,"url":"https:\/\/community.smartsheet.com\/discussion\/57266\/counting-number-of-tasks-per-assigned-to-contact","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/57266\/counting-number-of-tasks-per-assigned-to-contact","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-09\/38\/4b\/384bd85b9a7a5bde94eac0a88b9849b3.png","urlSrcSet":{"10":"","300":"","800":"","1200":""},"alt":"Count tasks by assigned to contact screenshot.png"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":228,"urlcode":"Project Management","name":"Project Management"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":270,"urlcode":"Technology","name":"Technology"}],"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":77444,"type":"question","name":"Smartsheet - Azure DevOps integration","excerpt":"Hey guys, I'm trying to create a connection between Azure DevOps and Smartsheet but I'm having a lot of issues with it. Has anyone ever made a two-way connection between the two? Especially being able to update an item in Azure when a row is updated in Smartsheet (and vice versa)? My goal is to be able to update fields in…","categoryID":343,"dateInserted":"2021-03-18T15:36:55+00:00","dateUpdated":"2022-06-14T14:37:53+00:00","dateLastComment":"2021-03-22T16:08:01+00:00","insertUserID":113728,"insertUser":{"userID":113728,"name":"Tomer Blankitny","url":"https:\/\/community.smartsheet.com\/profile\/Tomer%20Blankitny","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AOh14GgOWHSwIzNTwmnReGBf-NEbgD-HyUdtNh1YMIl2=s96-c","dateLastActive":"2022-03-31T06:28:35+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":91566,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/NDZ9JFCTQ8E3\/n8CCYP0Y12F8V.png","dateLastActive":"2022-06-22T23:07:52+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":222,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/77444\/smartsheet-azure-devops-integration","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/77444\/smartsheet-azure-devops-integration","format":"Rich","groupID":null,"statusID":0,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-03-22T16:08:01+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":[]},"tags":[{"tagID":259,"urlcode":"IT & Operations","name":"IT & Operations"},{"tagID":270,"urlcode":"Technology","name":"Technology"},{"tagID":277,"urlcode":"Integrations","name":"Integrations"},{"tagID":278,"urlcode":"Importing and Exporting","name":"Importing and Exporting"},{"tagID":334,"urlcode":"automations","name":"Automations"}],"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":77505,"type":"question","name":"Updating rows with multi_contact cell?","excerpt":"Hello, I'm using the Python API to update some rows as follows: copy cell values in specific columns from an old row, and append these to an update request as cells in the respective column for a new row. This works for all but a contact column (with multi_contact enabled). I'm getting the error that I need to use…","categoryID":320,"dateInserted":"2021-03-19T17:14:44+00:00","dateUpdated":null,"dateLastComment":"2021-03-22T10:31:07+00:00","insertUserID":133860,"insertUser":{"userID":133860,"name":"nschum","title":"","url":"https:\/\/community.smartsheet.com\/profile\/nschum","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-03-19T17:08:56+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":133860,"lastUser":{"userID":133860,"name":"nschum","title":"","url":"https:\/\/community.smartsheet.com\/profile\/nschum","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-03-19T17:08:56+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":420,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/77505\/updating-rows-with-multi-contact-cell","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/77505\/updating-rows-with-multi-contact-cell","format":"Rich","groupID":null,"statusID":0,"attributes":{"question":{"status":"accepted","dateAccepted":"2021-03-22T10:31:11+00:00","dateAnswered":"2021-03-19T18:13:40+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 Developers","name":"API and Developers"},{"tagID":270,"urlcode":"Technology","name":"Technology"},{"tagID":281,"urlcode":"Support","name":"Support"},{"tagID":285,"urlcode":"Solution Center","name":"Solution Center"}],"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":77290,"type":"question","name":"Cursor Bug when Referencing other Sheets in a Formula","excerpt":"Hi, I found a bug when referencing other sheets in a formula. When referencing multiple ranges from other sheets, the cursor will go outside of the braces for the first reference, then will go inside the braces for every reference after. I need to either click outside of the braces or hit the right key to get outside of…","categoryID":322,"dateInserted":"2021-03-15T15:37:41+00:00","dateUpdated":null,"dateLastComment":"2021-03-16T21:42:19+00:00","insertUserID":130394,"insertUser":{"userID":130394,"name":"Andrew James","url":"https:\/\/community.smartsheet.com\/profile\/Andrew%20James","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-03-26T18:57:08+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":130394,"lastUser":{"userID":130394,"name":"Andrew James","url":"https:\/\/community.smartsheet.com\/profile\/Andrew%20James","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-03-26T18:57:08+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":42,"score":1,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/77290\/cursor-bug-when-referencing-other-sheets-in-a-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/77290\/cursor-bug-when-referencing-other-sheets-in-a-formula","format":"Rich","groupID":null,"statusID":0,"attributes":{"question":{"status":"accepted","dateAccepted":"2021-03-16T21:42:24+00:00","dateAnswered":"2021-03-16T14:08:36+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":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":270,"urlcode":"Technology","name":"Technology"},{"tagID":281,"urlcode":"Support","name":"Support"},{"tagID":285,"urlcode":"Solution Center","name":"Solution Center"}],"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":50986,"type":"discussion","name":"Checkbox formula using =IF(OR","excerpt":"Hi, I am trying to find a formula to check a box based on another cell in the row having either maintenance OR support (along with other text) but keep getting an #INCORRECT ARGUMENT SET error. The formula works perfectly for one criteria i.e. =IF(FIND(\"Maintenance\", $[Item description]@row) >= 1, 1, 0) but when I try to…","categoryID":322,"dateInserted":"2019-06-18T23:55:34+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2021-02-12T21:13:08+00:00","insertUserID":92906,"insertUser":{"userID":92906,"name":"IBRIEOG","url":"https:\/\/community.smartsheet.com\/profile\/IBRIEOG","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!k6la33XwR7o!kpDZX8mAfZQ!5noBl7Id1_1","dateLastActive":"2022-05-11T21:49:59+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":"2022-06-22T18:54:18+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":25,"countViews":1911,"score":null,"hot":25,"url":"https:\/\/community.smartsheet.com\/discussion\/50986\/checkbox-formula-using-if-or","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/50986\/checkbox-formula-using-if-or","format":"Html","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":228,"urlcode":"Project Management","name":"Project Management"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":270,"urlcode":"Technology","name":"Technology"}],"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":76136,"type":"question","name":"Is it possible to send specific columns of two spreadsheets to a third one?","excerpt":"Hi everyone I have two spreadsheets and I want to take some columns of sheet 1 and others from sheet 2 and put them in a third one and that every time an update is made in sheet 1 or 2, it also apply on the third one. Including new rows, deleting rows and changing data. I am working with many data. Thank you, Belia Báez","categoryID":321,"dateInserted":"2021-02-12T19:58:16+00:00","dateUpdated":null,"dateLastComment":"2021-02-12T20:13:08+00:00","insertUserID":131979,"insertUser":{"userID":131979,"name":"Belia Baez","url":"https:\/\/community.smartsheet.com\/profile\/Belia%20Baez","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-02-18T14:41:41+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2022-06-23T00:01:53+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":12,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/76136\/is-it-possible-to-send-specific-columns-of-two-spreadsheets-to-a-third-one","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/76136\/is-it-possible-to-send-specific-columns-of-two-spreadsheets-to-a-third-one","format":"Rich","groupID":null,"statusID":0,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-02-12T20:13:08+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":213,"urlcode":"Conditional Formatting","name":"Conditional Formatting"},{"tagID":231,"urlcode":"Cell linking","name":"Cell linking"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":270,"urlcode":"Technology","name":"Technology"},{"tagID":334,"urlcode":"automations","name":"Automations"}],"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":75558,"type":"question","name":"Max Cost per Year","excerpt":"I need to determine the max Remediation Cost PER Year. I also, need to pull this information into another sheet's cell. What's the best way to go about this? This is the formula I have thus far, but it's coming out UNPARSEABLE... =MAX(IF([Date of Incident]:[Date of Incident], <=DATE(2020, 12, 31), [Date of Incident]:[Date…","categoryID":322,"dateInserted":"2021-02-01T17:32:09+00:00","dateUpdated":null,"dateLastComment":"2021-02-03T19:47:28+00:00","insertUserID":122093,"insertUser":{"userID":122093,"name":"Ashley Pierce","url":"https:\/\/community.smartsheet.com\/profile\/Ashley%20Pierce","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!!BOlXQXc6Kbo!mTFX3ic1sPo!ZDvysfgd1TM","dateLastActive":"2022-05-23T17:55:48+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/NDZ9JFCTQ8E3\/n8CCYP0Y12F8V.png","dateLastActive":"2022-06-22T23:07:52+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":62,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/75558\/max-cost-per-year","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/75558\/max-cost-per-year","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/V4EX1KCMXPQO\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-02-03T19:47:28+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":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":231,"urlcode":"Cell linking","name":"Cell linking"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":270,"urlcode":"Technology","name":"Technology"},{"tagID":285,"urlcode":"Solution Center","name":"Solution Center"}],"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":69311,"type":"question","name":"Smartsheet at- risk formula","excerpt":"Hi all, I'm having a little trouble with creating the right formula for my \"at risk\" \/ \"attn\" column. I only want the column to flag is the status is not complete and the target end date is past due. My current formula is =IF(AND(Status301 <> \"Complete\", [Target End Date]301 <= TODAY()), 1, 0) Currently, the column flags…","categoryID":322,"dateInserted":"2020-06-22T21:01:38+00:00","dateUpdated":null,"dateLastComment":"2021-02-03T16:58:05+00:00","insertUserID":122907,"insertUser":{"userID":122907,"name":"Titilope Akinlose","url":"https:\/\/community.smartsheet.com\/profile\/Titilope%20Akinlose","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-02-03T16:53:40+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":122907,"lastUser":{"userID":122907,"name":"Titilope Akinlose","url":"https:\/\/community.smartsheet.com\/profile\/Titilope%20Akinlose","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-02-03T16:53:40+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":172,"score":null,"hot":6,"url":"https:\/\/community.smartsheet.com\/discussion\/69311\/smartsheet-at-risk-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69311\/smartsheet-at-risk-formula","format":"Rich","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/MQCFRTESBHS0\/annotation-2020-06-22-165725.png","urlSrcSet":{"10":"","300":"","800":"","1200":""},"alt":"Annotation 2020-06-22 165725.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2020-06-23T17:54:44+00:00","dateAnswered":"2020-06-23T12:43:18+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":206,"urlcode":"Update Requests","name":"Update Requests"},{"tagID":241,"urlcode":"Calendar","name":"Calendar View"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":270,"urlcode":"Technology","name":"Technology"},{"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">