Formulas

0, \"Yellow\",…","categoryID":319,"dateInserted":"2017-10-09T14:08:24+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-10-09T16:04:07+00:00","insertUserID":25591,"insertUser":{"userID":25591,"name":"SharonJ","url":"https:\/\/community.smartsheet.com\/profile\/SharonJ","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-10-09T14:05:19+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":10966,"lastUser":{"userID":10966,"name":"Mike Andreas","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20Andreas","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/91\/d0\/n91d09c538f868eabba651b6bb18ee8bd.jpg","dateLastActive":"2019-07-20T19:40:50+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":15,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/14591\/need-help-with-parent-status","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/14591\/need-help-with-parent-status","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":14571,"type":"discussion","name":"Formula for Date column based on status change","excerpt":"I'm looking to create a formula to automatically put a date in a column based upon certain statuses in a dropdown menu. For example, I would like that day's date to populate when the status is 1, 2, or 3 but not 4 or 5 (we have about 10 different statuses in our actual list). Is this something that is possible? ","categoryID":319,"dateInserted":"2017-10-09T11:31:14+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-10-09T12:12:36+00:00","insertUserID":25566,"insertUser":{"userID":25566,"name":"JennS","url":"https:\/\/community.smartsheet.com\/profile\/JennS","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-01-17T13:02:03+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":11072,"lastUser":{"userID":11072,"name":"Mike Wilday","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20Wilday","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/749H48MC3045\/nF9FQYPTX0X7D.jpg","dateLastActive":"2023-06-16T17:26:24+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":355,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/14571\/formula-for-date-column-based-on-status-change","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/14571\/formula-for-date-column-based-on-status-change","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":14416,"type":"discussion","name":"Formula to get averages from one column if another column is checked","excerpt":"Hi All! I have 2 date columns, Processing Start Date & Processing Turnaround Time, then a column to show the NETWORKDAYS, (labeled Average Setup Time), of those two columns. Then I have a checkbox column (labeled New Setup)and another column to convert the checks into 1, 2, 3, etc.(labeled Setups). What I need to do now is…","categoryID":319,"dateInserted":"2017-10-05T15:38:50+00:00","dateUpdated":"2017-10-05T15:41:04+00:00","dateLastComment":"2017-10-06T08:11:00+00:00","insertUserID":6168,"insertUser":{"userID":6168,"name":"Angie Hatfield","url":"https:\/\/community.smartsheet.com\/profile\/Angie%20Hatfield","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/63\/6f\/n636f71d5d8910027e5a0ff6225156cdb.jpg","dateLastActive":"2021-01-15T20:01:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":6168,"lastUser":{"userID":6168,"name":"Angie Hatfield","url":"https:\/\/community.smartsheet.com\/profile\/Angie%20Hatfield","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/63\/6f\/n636f71d5d8910027e5a0ff6225156cdb.jpg","dateLastActive":"2021-01-15T20:01:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":2,"countViews":58,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/14416\/formula-to-get-averages-from-one-column-if-another-column-is-checked","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/14416\/formula-to-get-averages-from-one-column-if-another-column-is-checked","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2017-10\/c6\/0b\/c60b728cf1860622131e8a2619c42f42.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"AVG 1,2,3.jpg"},"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"},{"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":14421,"type":"discussion","name":"Changing the Color of a Font Based on Values","excerpt":"Hi All I'm building a budget sheet and am trying to figure out how to change the color of the font if it adds up to be over budget. For Example: =IF([Column]1 > [Column]2, \"Red\") But by doing that, it doesn't change the color, it puts in the word Red. Is there a way to do it in Conditional Formatting that I'm just missing?…","categoryID":319,"dateInserted":"2017-10-05T15:51:46+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-10-05T16:33:03+00:00","insertUserID":25266,"insertUser":{"userID":25266,"name":"info25266","url":"https:\/\/community.smartsheet.com\/profile\/info25266","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-10-10T12:34:38+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":10004,"lastUser":{"userID":10004,"name":"Jason Anderson","url":"https:\/\/community.smartsheet.com\/profile\/Jason%20Anderson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2017-10\/2c\/1a\/n2c1a27a36b5829dc3b2635f3ac165bb5.jpg","dateLastActive":"2018-12-12T09:58:56+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":648,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/14421\/changing-the-color-of-a-font-based-on-values","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/14421\/changing-the-color-of-a-font-based-on-values","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":238,"urlcode":"Finance","name":"Finance"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"},{"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":14406,"type":"discussion","name":"COUNTIF Does not equal","excerpt":"Hello! I'd like to set up a formula to COUNTIF(Children)<>\"app\/registration complete\" so I don't have to setup a more complicated COUNTIFS (I allow the dropdown to not be restricted to the text options I set up). Can't seem to get it to work. Is \"does not equal\" possible for COUNTIF in Smartsheet? Thanks in advance! ","categoryID":319,"dateInserted":"2017-10-05T15:05:33+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-10-05T15:27:00+00:00","insertUserID":7344,"insertUser":{"userID":7344,"name":"Lillian Murphy","url":"https:\/\/community.smartsheet.com\/profile\/Lillian%20Murphy","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-10-05T15:00:39+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":11072,"lastUser":{"userID":11072,"name":"Mike Wilday","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20Wilday","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/749H48MC3045\/nF9FQYPTX0X7D.jpg","dateLastActive":"2023-06-16T17:26:24+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":4272,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/14406\/countif-does-not-equal","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/14406\/countif-does-not-equal","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":249,"urlcode":"Education","name":"Education"},{"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":14101,"type":"discussion","name":"Renewal Date","excerpt":"Hello - I have a column for Purchased Date and a column for Renewal Date. I want the Renewal Date to automatically populate to the following year so we know when renewal is due. What is the best formula? Thanks, Barb","categoryID":319,"dateInserted":"2017-09-27T14:29:33+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-10-04T20:30:17+00:00","insertUserID":24126,"insertUser":{"userID":24126,"name":"bbloch18","url":"https:\/\/community.smartsheet.com\/profile\/bbloch18","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-02-11T14:21:59+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":4374,"lastUser":{"userID":4374,"name":"J. Craig Williams","title":"","url":"https:\/\/community.smartsheet.com\/profile\/J.%20Craig%20Williams","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/74\/da\/n74da5fe4ff9c5b38c13d6409a3c883a3.jpg","dateLastActive":"2023-05-13T18:07:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":4,"countViews":134,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/14101\/renewal-date","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/14101\/renewal-date","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":14121,"type":"discussion","name":"Detect if cell value increased or decreased","excerpt":"Is there a way to detect if a cell value increased or decreased compared to its previous value? I've already devised a way to reflect a symbol if the auto-column date modified was today. Now, I want that symbol to vary depending if the value on a cell in that row increased or decreased. Or if there's a way to put in two…","categoryID":319,"dateInserted":"2017-09-28T02:50:01+00:00","dateUpdated":null,"dateLastComment":"2017-10-04T20:09:15+00:00","insertUserID":24401,"insertUser":{"userID":24401,"name":"oj6_projmgr","url":"https:\/\/community.smartsheet.com\/profile\/oj6_projmgr","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-10-11T04:02:37+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":4374,"lastUser":{"userID":4374,"name":"J. Craig Williams","title":"","url":"https:\/\/community.smartsheet.com\/profile\/J.%20Craig%20Williams","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/74\/da\/n74da5fe4ff9c5b38c13d6409a3c883a3.jpg","dateLastActive":"2023-05-13T18:07:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":2,"countViews":112,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/14121\/detect-if-cell-value-increased-or-decreased","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/14121\/detect-if-cell-value-increased-or-decreased","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"},{"tagID":292,"urlcode":"Dashboards","name":"Dashboards"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"},{"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">