公式

Today8, \"Green\")))) Very new at this, but I can't see the problem...","categoryID":322,"dateInserted":"2019-02-07T17:15:54+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-02-07T18:31:02+00:00","insertUserID":76851,"insertUser":{"userID":76851,"name":"Kitty","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Kitty","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-01\/6c\/fb\/n6cfbd4e9f8b51ef6eac617de4934460f.jpg","dateLastActive":"2023-03-08T15:10:49+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":52616,"lastUser":{"userID":52616,"name":"Nic Larsen","url":"https:\/\/community.smartsheet.com\/profile\/Nic%20Larsen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nWVKDFTEFOKBN.png","dateLastActive":"2023-06-16T22:32:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":65,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/40991\/please-tell-me-what-is-wrong-with-this-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/40991\/please-tell-me-what-is-wrong-with-this-formula","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":216,"urlcode":"Non-profit","name":"Non-profit"},{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":440,"urlcode":"project-management","name":"Project 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":40846,"type":"discussion","name":"Complex Formula for RYG Automation","excerpt":"I automated the RYG circles according to several columns of a Smartsheet grid for project management purposes. The logic is below: IF [Proposed Product Launch Date] =TODAY AND [Deviation from Proposed Launch Date] <100, \"Green\" IF [Proposed Product Launch Date]…","categoryID":322,"dateInserted":"2019-02-06T20:34:00+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-02-07T17:35:22+00:00","insertUserID":76046,"insertUser":{"userID":76046,"name":"KWright84","url":"https:\/\/community.smartsheet.com\/profile\/KWright84","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!hafYoX3UND4!!E9s4FnPd1e9","dateLastActive":"2020-11-12T14:29:24+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":24581,"lastUser":{"userID":24581,"name":"Andrew Stewart","url":"https:\/\/community.smartsheet.com\/profile\/Andrew%20Stewart","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pZdd6VRKs7o!3eNef4Qckbo!i7PuC5gsNf3","dateLastActive":"2020-08-04T02:22:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":68,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/40846\/complex-formula-for-ryg-automation","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/40846\/complex-formula-for-ryg-automation","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":249,"urlcode":"Education","name":"Education"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":440,"urlcode":"project-management","name":"Project 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":17371,"type":"discussion","name":"SUMIFS trouble","excerpt":"I feel like I'm almost there with this, but just can't figure it out. I'm trying to determine a Sales Rate (money\/hours) per Estimator, per month (date range). My column headings are: Ops Start Date, Estimator, Scope Hr, and Contract Amount. I think the problem is using a date range within a SUMIFS formula. I know its…","categoryID":322,"dateInserted":"2018-01-05T11:59:42+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-02-07T16:26:35+00:00","insertUserID":10911,"insertUser":{"userID":10911,"name":"TJ-Webfoot","url":"https:\/\/community.smartsheet.com\/profile\/TJ-Webfoot","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/9d\/43\/n9d431aa2caae58e9e3e1acf8e487537c.png","dateLastActive":"2018-06-25T18:06:40+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":73606,"lastUser":{"userID":73606,"name":"Stephanie Stoewe","url":"https:\/\/community.smartsheet.com\/profile\/Stephanie%20Stoewe","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-02-06T11:22:28+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":370,"score":null,"hot":7,"url":"https:\/\/community.smartsheet.com\/discussion\/17371\/sumifs-trouble","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/17371\/sumifs-trouble","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":254,"urlcode":"Formulas","name":"Formulas"},{"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":7556,"type":"discussion","name":"SUMIFS Multiple Criteria","excerpt":"I'm beating myself up. Im trying to calculate the sum of tasks, that if they have the status \"Submitted\" and the submitted date is in March then it would calculate the value. Currently it is saying its #unparseable =SUMIFS([Submitted ($)]:[Submitted ($)], [Status]:[Status], \"Submitted\", [Date Submitted]:[Date Submitted],…","categoryID":319,"dateInserted":"2017-03-08T11:58:32+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-02-07T15:18:18+00:00","insertUserID":12124,"insertUser":{"userID":12124,"name":"Nic","url":"https:\/\/community.smartsheet.com\/profile\/Nic","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-03-08T11:25:15+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":73606,"lastUser":{"userID":73606,"name":"Stephanie Stoewe","url":"https:\/\/community.smartsheet.com\/profile\/Stephanie%20Stoewe","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-02-06T11:22:28+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":8,"countViews":5734,"score":null,"hot":8,"url":"https:\/\/community.smartsheet.com\/discussion\/7556\/sumifs-multiple-criteria","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/7556\/sumifs-multiple-criteria","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":319,"name":"Archived 2017 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2017","allowedDiscussionTypes":["discussion","question"]},"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":17191,"type":"discussion","name":"SUMIF with dates that land in a specific month","excerpt":"Im trying to use the sumif function to match 2 columns of data, transaction type, and corresponding value then return only month specific dates read from a date column. Date column is in mm\/dd\/yy format.","categoryID":319,"dateInserted":"2017-12-28T23:38:58+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-02-07T15:02:35+00:00","insertUserID":33366,"insertUser":{"userID":33366,"name":"kitter82","url":"https:\/\/community.smartsheet.com\/profile\/kitter82","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-01-05T22:21:53+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":73606,"lastUser":{"userID":73606,"name":"Stephanie Stoewe","url":"https:\/\/community.smartsheet.com\/profile\/Stephanie%20Stoewe","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-02-06T11:22:28+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":2,"countViews":1131,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/17191\/sumif-with-dates-that-land-in-a-specific-month","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/17191\/sumif-with-dates-that-land-in-a-specific-month","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":319,"name":"Archived 2017 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2017","allowedDiscussionTypes":["discussion","question"]},"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":40891,"type":"discussion","name":"Month Function","excerpt":"Hello, I am trying to figure out how to extract months out of a grid. My goal is to count how many assignments were completed within each month of the year. e.g. | January | 45 | --------------------- | February| 20 | However, I am finding trouble actually calculating the amount based off of the creation date. I figured a…","categoryID":322,"dateInserted":"2019-02-07T10:04:36+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-02-07T14:03:58+00:00","insertUserID":76561,"insertUser":{"userID":76561,"name":"cjleon","url":"https:\/\/community.smartsheet.com\/profile\/cjleon","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-03-08T07:10:53+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":76561,"lastUser":{"userID":76561,"name":"cjleon","url":"https:\/\/community.smartsheet.com\/profile\/cjleon","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-03-08T07:10:53+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":396,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/40891\/month-function","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/40891\/month-function","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":211,"urlcode":"Manufacturing","name":"Manufacturing"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":324,"urlcode":"community-platform","name":"Community Platform"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"tagID":440,"urlcode":"project-management","name":"Project Management"},{"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":40741,"type":"discussion","name":"Dynamic Sum from Multiple Sheets in a Workspace","excerpt":"Hello, I have a workspace full of our active projects. Each tasks has a status (not started, in progress, complete) and I would like be able to see the total numbers of these tasks statuses across all the projects. I already have columns that count the number of each task status in the individual projects, but I would like…","categoryID":322,"dateInserted":"2019-02-06T11:19:21+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-02-07T12:49:08+00:00","insertUserID":77406,"insertUser":{"userID":77406,"name":"TSpear","url":"https:\/\/community.smartsheet.com\/profile\/TSpear","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-08-30T15:56:37+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-19T22:46:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":630,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/40741\/dynamic-sum-from-multiple-sheets-in-a-workspace","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/40741\/dynamic-sum-from-multiple-sheets-in-a-workspace","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":208,"urlcode":"Workspaces","name":"Workspaces"},{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":440,"urlcode":"project-management","name":"Project Management"},{"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":40446,"type":"discussion","name":"Count Multiple Cells If Multiple Conditions with Date","excerpt":"Hello! I am working on linking a database to a results sheet and I need several metrics pulled out. I have Supplier, Defect Column 1, Defect Column 2, Defect Column 3, and date. What I ultimately need to do is create a January through December count of defects per Supplier. So I have Jan, Feb, Mar, ... Dec. on one axis,…","categoryID":322,"dateInserted":"2019-02-01T16:11:59+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-02-07T11:39:42+00:00","insertUserID":73606,"insertUser":{"userID":73606,"name":"Stephanie Stoewe","url":"https:\/\/community.smartsheet.com\/profile\/Stephanie%20Stoewe","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-02-06T11:22:28+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":73606,"lastUser":{"userID":73606,"name":"Stephanie Stoewe","url":"https:\/\/community.smartsheet.com\/profile\/Stephanie%20Stoewe","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-02-06T11:22:28+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":21,"countViews":193,"score":null,"hot":21,"url":"https:\/\/community.smartsheet.com\/discussion\/40446\/count-multiple-cells-if-multiple-conditions-with-date","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/40446\/count-multiple-cells-if-multiple-conditions-with-date","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":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":391,"urlcode":"product-development","name":"Product Development"},{"tagID":440,"urlcode":"project-management","name":"Project 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":40801,"type":"discussion","name":"Prevent users from entering dates that put other tasks in the past","excerpt":"Our project managers are responsible for creating new projects in our schedule. They enter a install start date and contract date. The dates for all the other tasks are formula driven from the install date. The image below shows our engineering tasks. Those 3 projects where entered within the past two days. All of our…","categoryID":322,"dateInserted":"2019-02-06T17:00:30+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-02-07T09:41:16+00:00","insertUserID":77571,"insertUser":{"userID":77571,"name":"Matt@Stidham_Cabinet","url":"https:\/\/community.smartsheet.com\/profile\/Matt%40Stidham_Cabinet","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-02-06T16:48:05+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-15T21:50:54+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":78,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/40801\/prevent-users-from-entering-dates-that-put-other-tasks-in-the-past","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/40801\/prevent-users-from-entering-dates-that-put-other-tasks-in-the-past","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":211,"urlcode":"Manufacturing","name":"Manufacturing"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"}],"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":40841,"type":"discussion","name":"IF Function to Deliver Target","excerpt":"How do I build a formula with two variables to deliver a target date? Example: IF cell A = defined variable and cell B = defined variable, then cell D = 6 months from date reflected in cell C. I can do this in excel using IF and Edate functions, but can't figure out in Smartsheet. Any assistance would be greatly…","categoryID":322,"dateInserted":"2019-02-06T20:27:56+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-02-07T03:10:33+00:00","insertUserID":77606,"insertUser":{"userID":77606,"name":"MattJ","url":"https:\/\/community.smartsheet.com\/profile\/MattJ","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-02-06T20:22: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-06-19T22:46:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":80,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/40841\/if-function-to-deliver-target","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/40841\/if-function-to-deliver-target","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":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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">