Formulas

0, Percent1 < 6), \"Scope\", IF(AND(Percent1 > 5, Percent1 < 11), \"AE Selection\", IF(AND(Percent1 > 10, Percent1 < 21), \"Design\", IF(AND(Percent1 > 20, Percent1 < 26), \"Bid\", IF(AND(Percent1 > 25, Percent1 < 96), \"Construction\", IF(AND(Percent1 > 95, Percent1…","categoryID":319,"dateInserted":"2017-12-04T12:23:32+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-12-04T17:14:42+00:00","insertUserID":31886,"insertUser":{"userID":31886,"name":"tsteele","url":"https:\/\/community.smartsheet.com\/profile\/tsteele","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-12-04T12:18:23+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-08-23T14:56:37+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":4,"countViews":1862,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/16461\/if-and-greater-than-less-than","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/16461\/if-and-greater-than-less-than","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":218,"urlcode":"construction","name":"Construction"},{"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":16426,"type":"discussion","name":"Datamesh to Update Engagement Progress for Coaches and Clients","excerpt":"I run a smartsheet for tracking coach\/client engagements. There are typically 6 or more sessions in an engagement. Neither coaches nor clients can have access to the sheet. I need the coaches to report the dates of each session in the engagements. Due to the nature of this environment, coaches can report any number of…","categoryID":319,"dateInserted":"2017-12-01T16:22:28+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-12-03T13:04:32+00:00","insertUserID":9204,"insertUser":{"userID":9204,"name":"Keith Lawton","url":"https:\/\/community.smartsheet.com\/profile\/Keith%20Lawton","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-11-30T14:51:44+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":1,"countViews":2,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/16426\/datamesh-to-update-engagement-progress-for-coaches-and-clients","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/16426\/datamesh-to-update-engagement-progress-for-coaches-and-clients","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":210,"urlcode":"human-resources","name":"Human Resources"},{"tagID":219,"urlcode":"sheets","name":"Sheets"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":265,"urlcode":"reports","name":"Reports"},{"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":16416,"type":"discussion","name":"#Circular Reference when automating Yes,Hold,No decisions","excerpt":"Hi, Hit a lil road block here. Trying to automate the symbols for my status column based on drop down lists, but i keep getting a circular reference when putting in this formula, =IF([Lead Result]1=\"Win\",Status1=\"Yes\",IF([Lead Result]1,=\"Negotiating\",Status1=\"Hold\",Status1=\"No\")) Posting a screenshot of my sheet for…","categoryID":319,"dateInserted":"2017-12-01T11:09:27+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-12-01T15:56:50+00:00","insertUserID":28751,"insertUser":{"userID":28751,"name":"r@ndom_w@lker","url":"https:\/\/community.smartsheet.com\/profile\/r%40ndom_w%40lker","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-11-27T10:23:34+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":28751,"lastUser":{"userID":28751,"name":"r@ndom_w@lker","url":"https:\/\/community.smartsheet.com\/profile\/r%40ndom_w%40lker","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-11-27T10:23:34+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":4,"countViews":174,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/16416\/circular-reference-when-automating-yes-hold-no-decisions","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/16416\/circular-reference-when-automating-yes-hold-no-decisions","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2017-12\/38\/69\/3869c25bb50d76dd90359908e74d4fae.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screen Shot 2017-12-01 at 11.08.53 AM.png"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":319,"name":"Archived 2017 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2017","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":211,"urlcode":"manufacturing","name":"Manufacturing"},{"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":16371,"type":"discussion","name":"Autofill Date Column with Conditional Formatting","excerpt":"Hi there, I am trying to set up an approval sheet. I would like my \"Due Date Column\" to auto fill a date 3 days before the date in my \"Date\" column only if my \"Completed\" check box is NOT completed. Can anyone help me with this formula? Thank you","categoryID":319,"dateInserted":"2017-11-29T20:05:54+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-12-01T11:41:24+00:00","insertUserID":31501,"insertUser":{"userID":31501,"name":"Gabby Rosa","url":"https:\/\/community.smartsheet.com\/profile\/Gabby%20Rosa","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-11-29T20:02:54+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-08-23T14:56:37+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":4,"countViews":173,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/16371\/autofill-date-column-with-conditional-formatting","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/16371\/autofill-date-column-with-conditional-formatting","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":210,"urlcode":"human-resources","name":"Human Resources"},{"tagID":234,"urlcode":"health-care","name":"Healthcare"},{"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":16361,"type":"discussion","name":"Formulas: Countif \/ And \/ Children Rows","excerpt":"H E L P! What is a simple way to formulate the \"Evaluation\" Chart in the Screen Shots attached, based off ONLY the children rows of the 4 Departments on the top of the sheet in both the \"status\" and \"risk level\" columns? I'm trying to avoid a \"messy\" formula but I'm receiving an error through all my attempts. ","categoryID":319,"dateInserted":"2017-11-29T16:15:45+00:00","dateUpdated":"2017-11-29T16:24:53+00:00","dateLastComment":"2017-12-01T11:17:31+00:00","insertUserID":8777,"insertUser":{"userID":8777,"name":"Laura","url":"https:\/\/community.smartsheet.com\/profile\/Laura","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/0e\/35\/n0e35051e93891757bdff0c739bba89cc.jpg","dateLastActive":"2021-09-22T14:54:40+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":8777,"lastUser":{"userID":8777,"name":"Laura","url":"https:\/\/community.smartsheet.com\/profile\/Laura","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/0e\/35\/n0e35051e93891757bdff0c739bba89cc.jpg","dateLastActive":"2021-09-22T14:54:40+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":5,"countViews":87,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/16361\/formulas-countif-and-children-rows","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/16361\/formulas-countif-and-children-rows","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2017-11\/8c\/78\/8c783190946a932b5961a18ad5d84ffd.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"EVAL_parentSS.png"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":319,"name":"Archived 2017 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2017","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":211,"urlcode":"manufacturing","name":"Manufacturing"},{"tagID":219,"urlcode":"sheets","name":"Sheets"},{"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":16401,"type":"discussion","name":"Formula DATE & IF","excerpt":"Hi, I have a sheet that I use for accounts. I have a column for Invoice Date, a column for Due Date and a column for Status. I would like a formula for the status column to read \"due in X days\" ( a countdown of sorts) if invoice and due date same, read \"Today\" and once the due date is in the past, I would like the status…","categoryID":319,"dateInserted":"2017-11-30T18:44:20+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-12-01T05:36:41+00:00","insertUserID":31761,"insertUser":{"userID":31761,"name":"Kathy Rogers","url":"https:\/\/community.smartsheet.com\/profile\/Kathy%20Rogers","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-07-30T02:21:20+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":1,"countViews":22,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/16401\/formula-date-if","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/16401\/formula-date-if","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":16256,"type":"discussion","name":"If \"x\", and checked box y","excerpt":"Hello, I am trying to Check box = If column 1 =\"x\" and if column 2 is checked = column 3 to be checked e.g. If Column 1 contains \"Street Lighting\" & Quote Successful Column is checked, Street Lighting successful box is checked I've tried the following equasions =IF(AND(Team7 = \"Street Lighting\", (NOT(ISBLANK([Quote…","categoryID":319,"dateInserted":"2017-11-27T22:41:53+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-11-30T16:32:20+00:00","insertUserID":12841,"insertUser":{"userID":12841,"name":"Emma_w4tevr","url":"https:\/\/community.smartsheet.com\/profile\/Emma_w4tevr","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-02-15T22:01:22+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":23666,"lastUser":{"userID":23666,"name":"Chris McKay","url":"https:\/\/community.smartsheet.com\/profile\/Chris%20McKay","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2017-09\/d5\/d2\/nd5d2693be28ccbd24f978b00c5d1db1d.JPG","dateLastActive":"2018-08-14T22:59:56+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":7,"countViews":57,"score":null,"hot":7,"url":"https:\/\/community.smartsheet.com\/discussion\/16256\/if-x-and-checked-box-y","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/16256\/if-x-and-checked-box-y","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":218,"urlcode":"construction","name":"Construction"},{"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":2222,"type":"discussion","name":"Counting Check Boxes","excerpt":"I'm trying to get a formula to count the number of Check Boxes that are checked in all the Children rows under a Parent row. When using =\"Count:\" + COUNTIF(CHILDREN(), 1), which is one of the formula examples I'll get this Count: 2 All I'm looking for is the number so I tried =COUNTIF(CHILDREN(), 1) but it doesn't work.…","categoryID":317,"dateInserted":"2015-09-18T13:29:22+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-11-29T14:50:50+00:00","insertUserID":3471,"insertUser":{"userID":3471,"name":"MVigrass","url":"https:\/\/community.smartsheet.com\/profile\/MVigrass","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2015-09-18T13:21:42+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":31416,"lastUser":{"userID":31416,"name":"PLorimer","url":"https:\/\/community.smartsheet.com\/profile\/PLorimer","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-11-29T14:47:54+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":4,"countViews":3627,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/2222\/counting-check-boxes","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/2222\/counting-check-boxes","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":317,"name":"Archived 2015 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2015","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":544,"type":"discussion","name":"Hiding completed rows and showing all rows easily","excerpt":"I have several sheets with rows that are \"old\" (completed, sold,...) and that I want to hide most of the time. Conditional formating does that well. But I need sometimes to see them all. How to achieve this easily?","categoryID":317,"dateInserted":"2015-06-16T11:21:24+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-11-29T09:34:41+00:00","insertUserID":1290,"insertUser":{"userID":1290,"name":"Alan Guggenheim","url":"https:\/\/community.smartsheet.com\/profile\/Alan%20Guggenheim","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-09-09T15:25:37+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":245,"lastUser":{"userID":245,"name":"JamesR","title":"","url":"https:\/\/community.smartsheet.com\/profile\/JamesR","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/87\/15\/n8715b9481d6c0836c04cd6097804bec6.jpg","dateLastActive":"2019-07-19T03:25:36+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":11,"countViews":2200,"score":null,"hot":11,"url":"https:\/\/community.smartsheet.com\/discussion\/544\/hiding-completed-rows-and-showing-all-rows-easily","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/544\/hiding-completed-rows-and-showing-all-rows-easily","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":317,"name":"Archived 2015 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2015","allowedDiscussionTypes":["discussion","question"]},"tags":[{"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">