政府
讨论表
0, IF(COUNTIF(CHILDREN(), \"Red\") > 0, \"Red\", IF(COUNTIF(CHILDREN(), \"Yellow\") > 0, \"Yellow\",…","categoryID":321,"dateInserted":"2019-06-13T13:33:59+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-06-13T16:02:46+00:00","insertUserID":92216,"insertUser":{"userID":92216,"name":"Waseem K","url":"https:\/\/community.smartsheet.com\/profile\/Waseem%20K","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-06\/41\/20\/n41205f53724ed064a509a697256a11a5.jpg","dateLastActive":"2021-10-07T16:26:04+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-10T23:30:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":98,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/50596\/how-to-write-nested-if-statements-each-on-separate-line","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/50596\/how-to-write-nested-if-statements-each-on-separate-line","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":263,"urlcode":"Government","name":"Government"},{"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":50176,"type":"discussion","name":"No longer receiving reminders\/notifications","excerpt":"I have not received reminder emails or notifications in the app for any reminders\/alerts since 5\/22\/2019. I have checked my notification settings, my spam folder, I keep running tests, and so far I can't find an easy solution. I've attached screenshots that show my notification center, card view showing active reminders…","categoryID":321,"dateInserted":"2019-06-10T15:51:40+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-06-10T16:53:27+00:00","insertUserID":91491,"insertUser":{"userID":91491,"name":"htak91491","url":"https:\/\/community.smartsheet.com\/profile\/htak91491","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-06-10T15:48:20+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-10T23:30:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":140,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/50176\/no-longer-receiving-reminders-notifications","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/50176\/no-longer-receiving-reminders-notifications","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-06\/8f\/d8\/8fd806dca3279a565d1dd21e9bdcd055.PNG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Smartsheet_Error_1.PNG"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":263,"urlcode":"Government","name":"Government"},{"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":70,"type":"discussion","name":"Using multiple working days\/resource schedules in the same project","excerpt":"Hello, As a construction PM, one of the functions I use most with SS is the Gantt style programming. I have multiple crews on the same project\/in the same sheet, but the issue I have is they each have a different working schedule - for example night shift is Sunday to Thursday night, day shift is Monday to Friday, and some…","categoryID":317,"dateInserted":"2015-04-06T03:20:34+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-06-09T17:42:32+00:00","insertUserID":348,"insertUser":{"userID":348,"name":"Oliver","url":"https:\/\/community.smartsheet.com\/profile\/Oliver","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2015-04-06T16:52:01+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":91386,"lastUser":{"userID":91386,"name":"carlo_a","url":"https:\/\/community.smartsheet.com\/profile\/carlo_a","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-06-09T17:31:43+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":17,"countViews":709,"score":1,"hot":18,"url":"https:\/\/community.smartsheet.com\/discussion\/70\/using-multiple-working-days-resource-schedules-in-the-same-project","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/70\/using-multiple-working-days-resource-schedules-in-the-same-project","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":210,"urlcode":"Human Resources","name":"Human Resources"},{"tagID":211,"urlcode":"Manufacturing","name":"Manufacturing"},{"tagID":218,"urlcode":"Construction","name":"Construction"},{"tagID":241,"urlcode":"Calendar","name":"Calendar View"},{"tagID":247,"urlcode":"Contacts","name":"Contacts"},{"tagID":261,"urlcode":"Account and User Management","name":"Account and User Management"},{"tagID":263,"urlcode":"Government","name":"Government"},{"tagID":283,"urlcode":"Enhancement Request","name":"Enhancement Request"},{"tagID":439,"urlcode":"gantt-view","name":"Gantt View"},{"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":49476,"type":"discussion","name":"Formulas","excerpt":"Hi, I have a formula that works perfectly in Excel but I can not get it to work in Smartsheets. I am having issues finding corresponding functions in Smartsheets. This is the formula and screenshots show what I am getting from them.…","categoryID":322,"dateInserted":"2019-05-30T17:44:54+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-06-03T12:27:39+00:00","insertUserID":90481,"insertUser":{"userID":90481,"name":"eganji","url":"https:\/\/community.smartsheet.com\/profile\/eganji","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-09-28T16:47:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":90481,"lastUser":{"userID":90481,"name":"eganji","url":"https:\/\/community.smartsheet.com\/profile\/eganji","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-09-28T16:47:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":270,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/49476\/formulas","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/49476\/formulas","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-05\/2d\/b3\/2db3cf0db997f1a2a43a30a6a094c4dc.PNG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screen Shot 05-30-19 at 02.31 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":234,"urlcode":"Health-care","name":"Healthcare"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":263,"urlcode":"Government","name":"Government"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"}],"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":7703,"type":"discussion","name":"Parent Date Roll ups - Possible for two sets of dates?","excerpt":"I have a head scratcher here, thanks in advance for any help that anyone may have. My scenario is this, I have project plans that have two sets of dates, one is estimated dates and the other is the actual dates on the project tasks. In my project settings the estimated dates are linked to the dependencies. When I enter in…","categoryID":319,"dateInserted":"2017-03-21T15:53:47+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-05-31T12:54:55+00:00","insertUserID":3226,"insertUser":{"userID":3226,"name":"Scott Houle","url":"https:\/\/community.smartsheet.com\/profile\/Scott%20Houle","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-10-03T08:36:51+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":10116,"lastUser":{"userID":10116,"name":"Josh Garcia","url":"https:\/\/community.smartsheet.com\/profile\/Josh%20Garcia","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2017-07\/bf\/8f\/nbf8f93ce6bfd35b96095c4946c9b3c3b.jpg","dateLastActive":"2019-09-11T15:10:10+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":8,"countViews":351,"score":null,"hot":8,"url":"https:\/\/community.smartsheet.com\/discussion\/7703\/parent-date-roll-ups-possible-for-two-sets-of-dates","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/7703\/parent-date-roll-ups-possible-for-two-sets-of-dates","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":216,"urlcode":"Non-profit","name":"Non-profit"},{"tagID":234,"urlcode":"Health-care","name":"Healthcare"},{"tagID":263,"urlcode":"Government","name":"Government"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"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}">