Unanswered Questions

0, \"Red\", IF(COUNTIFS(CHILDREN(), \"Yellow\") > 0, \"Yellow\", IF(COUNTIFS(CHILDREN(), \"Green\") = COUNT(CHILDREN()), \"Green\"))) that adds: If 5 or more tasks are yellow turn “yellow” If 3 or more tasks…","categoryID":322,"dateInserted":"2022-10-19T21:52:20+00:00","dateUpdated":null,"dateLastComment":"2022-10-21T14:03:33+00:00","insertUserID":153319,"insertUser":{"userID":153319,"name":"rachkh","url":"https:\/\/community.smartsheet.com\/profile\/rachkh","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-21T18:09:41+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":152316,"lastUser":{"userID":152316,"name":"Christian G.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Christian%20G.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-21T22:55:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":64,"score":null,"hot":3332580353,"url":"https:\/\/community.smartsheet.com\/discussion\/96814\/rollup-health","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96814\/rollup-health","format":"Rich","groupID":null,"statusID":4,"attributes":{"question":{"status":"rejected","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":96867,"type":"question","name":"Extracting an information from web page by machine learning","excerpt":"I would like to extract a specific type of information from web pages in Python. Let's say postal address. It has thousands of forms, but still, it is somehow recognizable. As there is a large number of forms, it would be probably very difficult to write regular expression or even something like a grammar and to use…","categoryID":320,"dateInserted":"2022-10-21T11:11:01+00:00","dateUpdated":null,"dateLastComment":"2022-10-21T11:11:01+00:00","insertUserID":153976,"insertUser":{"userID":153976,"name":"ravik","url":"https:\/\/community.smartsheet.com\/profile\/ravik","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/ALm5wu2LeWtUE-oRBiwWHFGW8jjRRWZQNHk_JBI9cEdG=s96-c","dateLastActive":"2022-10-21T11:11:06+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":153976,"lastUser":{"userID":153976,"name":"ravik","url":"https:\/\/community.smartsheet.com\/profile\/ravik","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/ALm5wu2LeWtUE-oRBiwWHFGW8jjRRWZQNHk_JBI9cEdG=s96-c","dateLastActive":"2022-10-21T11:11:06+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":13,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/96867\/extracting-an-information-from-web-page-by-machine-learning","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96867\/extracting-an-information-from-web-page-by-machine-learning","format":"Rich","groupID":null,"statusID":1,"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","allowedDiscussionTypes":[]},"tags":[{"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":96864,"type":"question","name":"Count Created Date within last month","excerpt":"Hi All, I want to use the formula in the Sheet Summary in my smartsheet to count the created date column for last month. I have tried the formula but it always return to 0; however, looking through the date I have 3 created last month. =COUNTIF([Date Created]:[Date Created], MONTH(TODAY())-1) Since I have 1 parent row with…","categoryID":322,"dateInserted":"2022-10-20T23:37:08+00:00","dateUpdated":null,"dateLastComment":"2022-10-21T00:26:29+00:00","insertUserID":144090,"insertUser":{"userID":144090,"name":"Emi","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Emi","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-21T22:23:42+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":144090,"lastUser":{"userID":144090,"name":"Emi","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Emi","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-21T22:23:42+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":24,"score":null,"hot":3332621617,"url":"https:\/\/community.smartsheet.com\/discussion\/96864\/count-created-date-within-last-month","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96864\/count-created-date-within-last-month","format":"Rich","groupID":null,"statusID":4,"attributes":{"question":{"status":"rejected","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":96861,"type":"question","name":"Parent\/Child Hierarchy Formulas","excerpt":"Hi, I have a formula to figure out where I want the parent rows to increase by 1 each time, while the child rows maintain the same number as the parent. IE only the parent rows should increase to match the numbering convention. I'm trying to get the A.X to match what's in the right most column (as those will be deleted and…","categoryID":322,"dateInserted":"2022-10-20T22:12:07+00:00","dateUpdated":null,"dateLastComment":"2022-10-20T22:12:07+00:00","insertUserID":153971,"insertUser":{"userID":153971,"name":"la3815","url":"https:\/\/community.smartsheet.com\/profile\/la3815","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-21T21:31:32+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":153971,"lastUser":{"userID":153971,"name":"la3815","url":"https:\/\/community.smartsheet.com\/profile\/la3815","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-21T21:31:32+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":36,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/96861\/parent-child-hierarchy-formulas","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96861\/parent-child-hierarchy-formulas","format":"Rich","groupID":null,"statusID":1,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/TU5B0PUJJMXR\/screenshot-2022-10-20-170859.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screenshot 2022-10-20 170859.png"},"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}],"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":96842,"type":"question","name":"Cannot use 'in' operator to search for 'message' in upstream request timeout","excerpt":"Hello, I have data shuttle set up to delete rows and then add the rows from the new file and it works most of the time fine. Today the below message showed for the first time and instead of first deleing the rows it added in the rows so I ended up with the double the rows! File was uploaded again and it processed…","categoryID":343,"dateInserted":"2022-10-20T17:15:42+00:00","dateUpdated":null,"dateLastComment":"2022-10-20T17:15:42+00:00","insertUserID":147791,"insertUser":{"userID":147791,"name":"SRDavies","url":"https:\/\/community.smartsheet.com\/profile\/SRDavies","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-20T17:11:53+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":147791,"lastUser":{"userID":147791,"name":"SRDavies","url":"https:\/\/community.smartsheet.com\/profile\/SRDavies","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-20T17:11:53+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":16,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/96842\/cannot-use-in-operator-to-search-for-message-in-upstream-request-timeout","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96842\/cannot-use-in-operator-to-search-for-message-in-upstream-request-timeout","format":"Rich","groupID":null,"statusID":1,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/E8EM8PN0BYD3\/picture-1.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Picture 1.png"},"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":[]},"tags":[],"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":96832,"type":"question","name":"Calendar View on Mobile App","excerpt":"I have a few questions about the Calendar View on the mobile app. I thought it was possible to view the calendar in a monthly format, but I can only see a weekly format on the mobile app. Is it possible to switch to a monthly view? Also, my filters don't seem to be applied in the mobile app, which makes the calendar very…","categoryID":321,"dateInserted":"2022-10-20T15:12:52+00:00","dateUpdated":null,"dateLastComment":"2022-10-20T15:12:52+00:00","insertUserID":153934,"insertUser":{"userID":153934,"name":"South Haven Homes","url":"https:\/\/community.smartsheet.com\/profile\/South%20Haven%20Homes","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-20T15:12:56+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":153934,"lastUser":{"userID":153934,"name":"South Haven Homes","url":"https:\/\/community.smartsheet.com\/profile\/South%20Haven%20Homes","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-20T15:12:56+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":9,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/96832\/calendar-view-on-mobile-app","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96832\/calendar-view-on-mobile-app","format":"Rich","groupID":null,"statusID":1,"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":241,"urlcode":"Calendar","name":"Calendar View"},{"tagID":246,"urlcode":"Mobile","name":"Mobile"}],"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}">