非营利性的

07.01.2019, [Completed in days]:[Completed in days]) The Smartsheet returns me the value 0 that is wrong cause I have lots of numbers that meet this criterion. Please advise and thanks in advance ","categoryID":322,"dateInserted":"2019-11-26T07:25:32+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-11-26T08:07:33+00:00","insertUserID":112551,"insertUser":{"userID":112551,"name":"Pilarmonia","url":"https:\/\/community.smartsheet.com\/profile\/Pilarmonia","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-11\/0b\/79\/n0b792dcb9885070d8990b9071b6b5c1a.jpg","dateLastActive":"2019-11-26T07:18:35+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-07-01T01:22:18+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":195,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/63861\/dates-in-formula-averageif","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/63861\/dates-in-formula-averageif","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":238,"urlcode":"Finance","name":"Finance"},{"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":63466,"type":"discussion","name":"Report and Calendar View","excerpt":"I created a report from a sheet. The report contains only a few columns. This report is intended to be mostly used for calendar view. The items we want viewable in the calendar are the same items contained in the report -- not the main sheet. In calendar view, if you click on a scheduled item, all the details from the main…","categoryID":321,"dateInserted":"2019-11-20T11:49:57+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-11-23T18:34:44+00:00","insertUserID":98731,"insertUser":{"userID":98731,"name":"alwayslearning","url":"https:\/\/community.smartsheet.com\/profile\/alwayslearning","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-11\/13\/3c\/n133c933fa3810f414f2712baddd1bcee.jpg","dateLastActive":"2022-06-27T12:58:51+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":98731,"lastUser":{"userID":98731,"name":"alwayslearning","url":"https:\/\/community.smartsheet.com\/profile\/alwayslearning","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-11\/13\/3c\/n133c933fa3810f414f2712baddd1bcee.jpg","dateLastActive":"2022-06-27T12:58:51+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":259,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/63466\/report-and-calendar-view","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/63466\/report-and-calendar-view","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":216,"urlcode":"Non-profit","name":"Non-profit"},{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":241,"urlcode":"Calendar","name":"Calendar View"},{"tagID":265,"urlcode":"Reports","name":"Reports"}],"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":63506,"type":"discussion","name":"Risk Register - download example template","excerpt":"Hi - I am trying to download the very first risk register template that is referenced on this page. \/\/www.santa-greenland.com\/risk-register-templates When I click the Smartsheet version, I get a completely different Risk Register. When I select Excel, I get the one pictured. I tried to download the Excel version and they…","categoryID":321,"dateInserted":"2019-11-20T17:36:12+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-11-21T02:53:00+00:00","insertUserID":87911,"insertUser":{"userID":87911,"name":"latsyrcg3","url":"https:\/\/community.smartsheet.com\/profile\/latsyrcg3","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-11-20T17:31:18+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-07-01T00:15:58+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":420,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/63506\/risk-register-download-example-template","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/63506\/risk-register-download-example-template","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":216,"urlcode":"Non-profit","name":"Non-profit"},{"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":63436,"type":"discussion","name":"Automating RYG balls to change colors","excerpt":"So i have parent cells and dependencies. The dependencies have color balls (red, yellow, green, grey). Here is what I want: If one of the dependencies has a red color ball, I want the parent ball color to be red. If all dependencies have a green ball, I want the ball for the parent to be green If all dependencies have a…","categoryID":322,"dateInserted":"2019-11-20T09:05:57+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-11-20T13:09:32+00:00","insertUserID":111911,"insertUser":{"userID":111911,"name":"NaNa","url":"https:\/\/community.smartsheet.com\/profile\/NaNa","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-11-20T08:54:42+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-07-01T01:22:18+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":370,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/63436\/automating-ryg-balls-to-change-colors","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/63436\/automating-ryg-balls-to-change-colors","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":213,"urlcode":"Conditional Formatting","name":"Conditional Formatting"},{"tagID":216,"urlcode":"Non-profit","name":"Non-profit"},{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":234,"urlcode":"Health-care","name":"Healthcare"},{"tagID":244,"urlcode":"Product Development","name":"Product Development"},{"tagID":249,"urlcode":"Education","name":"Education"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":269,"urlcode":"Gantt View","name":"Gantt View"},{"tagID":302,"urlcode":"Community Platform","name":"Community Platform"}],"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":63066,"type":"discussion","name":"Conditional Formatting","excerpt":"I am using a form to collect contact information for event registration. We want our guests to register separate email and phone numbers for each member of the household. Is there a way to create a conditional format that keeps guests from entering the same phone number and email more for more than one person? Thanks, d ","categoryID":321,"dateInserted":"2019-11-16T11:53:47+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-11-17T04:00:08+00:00","insertUserID":111556,"insertUser":{"userID":111556,"name":"Dtuck","url":"https:\/\/community.smartsheet.com\/profile\/Dtuck","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-11-16T11:44:40+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-07-01T00:15:58+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":64,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/63066\/conditional-formatting","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/63066\/conditional-formatting","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-11\/67\/85\/6785333a8315186d260dce665a017b96.png","urlSrcSet":{"10":"","300":"","800":"","1200":""},"alt":"Screen Shot 2019-11-16 at 10.51.44 AM.png"},"attributes":{},"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":216,"urlcode":"Non-profit","name":"Non-profit"}],"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":62411,"type":"discussion","name":"At Risk Flag","excerpt":"Hi there! I am trying to have it so that the flag shows if the End Date is 3 days away AND the Status is \"Not Started\" (ideally, I would like it to show if the status is anything but Completed, but that may be too difficult). I know to use a nested IF\/AND function, but I keep getting errors when I write it out. I started…","categoryID":322,"dateInserted":"2019-11-08T15:40:18+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-11-12T11:49:04+00:00","insertUserID":102781,"insertUser":{"userID":102781,"name":"klawr95","url":"https:\/\/community.smartsheet.com\/profile\/klawr95","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-11-11T08:21:19+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\/518\/n0UL39EAWX965.jpg","dateLastActive":"2022-06-24T20:38:44+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":250,"score":null,"hot":8,"url":"https:\/\/community.smartsheet.com\/discussion\/62411\/at-risk-flag","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/62411\/at-risk-flag","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-11\/64\/3b\/643b19b6e4bd896e03749c5594642365.png","urlSrcSet":{"10":"","300":"","800":"","1200":""},"alt":"Screen Shot 2019-11-08 at 3.40.08 PM.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":216,"urlcode":"Non-profit","name":"Non-profit"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"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}]},{"discussionID":6457,"type":"discussion","name":"Is having multiple 'events' on the same row or specific days highlighted possible on Gantt view","excerpt":"I'm creating a Gantt chart to monitor and plan my progress for a thesis I am writing. I have the various stages of my thesis with their sub-projects indented under them, so my Gantt chart is becoming quite tall. I also need the days of my other deadlines highlighted on the Gantt chart, so I can see where my deadlines will…","categoryID":318,"dateInserted":"2016-11-03T15:04:36+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-11-07T23:12:29+00:00","insertUserID":9015,"insertUser":{"userID":9015,"name":"Nathan Bourne","url":"https:\/\/community.smartsheet.com\/profile\/Nathan%20Bourne","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-11-03T14:28:48+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":110471,"lastUser":{"userID":110471,"name":"Jetlog75","url":"https:\/\/community.smartsheet.com\/profile\/Jetlog75","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-11-07T16:01:07+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":4,"countViews":378,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/6457\/is-having-multiple-events-on-the-same-row-or-specific-days-highlighted-possible-on-gantt-view","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/6457\/is-having-multiple-events-on-the-same-row-or-specific-days-highlighted-possible-on-gantt-view","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"tagID":216,"urlcode":"Non-profit","name":"Non-profit"},{"tagID":228,"urlcode":"Project Management","name":"Project Management"},{"tagID":269,"urlcode":"Gantt View","name":"Gantt View"}],"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}">