探索。问。回答

x.cells.length && x.cells[0].displayValue)…","categoryID":320,"dateInserted":"2023-02-02T02:02:31+00:00","dateUpdated":null,"dateLastComment":"2023-05-24T16:10:28+00:00","insertUserID":113904,"insertUser":{"userID":113904,"name":"Chris Shifflett","url":"https:\/\/community.smartsheet.com\/profile\/Chris%20Shifflett","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-02T13:10:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":1133,"lastUser":{"userID":1133,"name":"Gwen Rymill SBP","url":"https:\/\/community.smartsheet.com\/profile\/Gwen%20Rymill%20SBP","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/09\/99\/n099985aff011cad70744a1fb676d6340.jpg","dateLastActive":"2023-06-09T17:00:34+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":true,"countComments":4,"countViews":308,"score":3,"hot":3360251279,"url":"https:\/\/community.smartsheet.com\/discussion\/100552\/dynamic-dropdowns","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/100552\/dynamic-dropdowns","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-02-03T19:24:02+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","allowedDiscussionTypes":[]},"tags":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":227,"urlcode":"api-and-developers","name":"API and Developers"}],"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":105643,"type":"question","name":"Form Managment tool","excerpt":"Hey, Is there a form management tool? I have a sheet with over 100 forms and I need to make the same change in all of them. Is there a view like a smartsheet sheets of all the forms so I can edit them more easily? Even a list view would make it easier so I dont need to see the photo of every form. Thank you","categoryID":321,"dateInserted":"2023-05-24T14:26:01+00:00","dateUpdated":"2023-05-24T14:26:53+00:00","dateLastComment":"2023-05-24T15:53:52+00:00","insertUserID":160845,"insertUser":{"userID":160845,"name":"Itai","url":"https:\/\/community.smartsheet.com\/profile\/Itai","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T15:29:01+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"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-10T17:56:27+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":39,"score":null,"hot":3369882593,"url":"https:\/\/community.smartsheet.com\/discussion\/105643\/form-managment-tool","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105643\/form-managment-tool","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-05-24T15:53:52+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":204,"urlcode":"Forms","name":"Forms"}],"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":105647,"type":"idea","name":"Hours\/Minutes in Project Sheet","excerpt":"I want to be able to make standardized work documents for changeovers\/process information. I can't do that in smartsheet due to the lack of hours\/minutes in the project sheets (I want to have the gantt chart to the right) Of course I could do something like scale it with the days with 1 day = 1 hr and just ignore the wrong…","categoryID":349,"dateInserted":"2023-05-24T15:47:15+00:00","dateUpdated":null,"dateLastComment":"2023-05-24T15:47:15+00:00","insertUserID":16866,"insertUser":{"userID":16866,"name":"L_123","title":"","url":"https:\/\/community.smartsheet.com\/profile\/L_123","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T13:58:29+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":16866,"lastUser":{"userID":16866,"name":"L_123","title":"","url":"https:\/\/community.smartsheet.com\/profile\/L_123","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T13:58:29+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":30,"score":1,"hot":1684943535,"url":"https:\/\/community.smartsheet.com\/discussion\/105647\/hours-minutes-in-project-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105647\/hours-minutes-in-project-sheet","format":"Rich","groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"},{"tagID":440,"urlcode":"project-management","name":"Project Management"}],"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":105172,"type":"question","name":"Controlling font size and multiple line fields in Document Creation via Workflows","excerpt":"I am populating an intake sheet through Forms and then taking this intake sheet information to create a document through a Workflow as part of customer survey process. One of the form questions requires up to 500 characters. I select Multi-line text box in the Form \"Display As\" field but I don't get multiple lines on the…","categoryID":321,"dateInserted":"2023-05-12T13:13:13+00:00","dateUpdated":"2023-05-12T13:13:31+00:00","dateLastComment":"2023-05-24T15:01:24+00:00","insertUserID":131805,"insertUser":{"userID":131805,"name":"Mike Ferringer","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20Ferringer","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!bCDcG6mES-Q!jEteY2AQwHQ!7LgDMUcu9rT","dateLastActive":"2023-05-25T14:36:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":91566,"lastUserID":131805,"lastUser":{"userID":131805,"name":"Mike Ferringer","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20Ferringer","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!bCDcG6mES-Q!jEteY2AQwHQ!7LgDMUcu9rT","dateLastActive":"2023-05-25T14:36:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":65,"score":1,"hot":3368839777,"url":"https:\/\/community.smartsheet.com\/discussion\/105172\/controlling-font-size-and-multiple-line-fields-in-document-creation-via-workflows","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105172\/controlling-font-size-and-multiple-line-fields-in-document-creation-via-workflows","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-05-15T03:31:41+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":102774,"type":"question","name":"Join Ancestors help","excerpt":"I have a sheet that has a Task Name column which has Parent and Child rows. I have another column \"Levels\" that tells me the level that each row sits in the hierarchy. My formula does everything except include the data for task names that are at Level 4. I cannot figure out where I am going wrong. Any help is greatly…","categoryID":322,"dateInserted":"2023-03-16T20:04:35+00:00","dateUpdated":null,"dateLastComment":"2023-05-24T14:48:28+00:00","insertUserID":155955,"insertUser":{"userID":155955,"name":"NickEL","url":"https:\/\/community.smartsheet.com\/profile\/NickEL","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-30T22:20:42+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-06-09T16:55:11+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":10,"countViews":130,"score":null,"hot":3363942783,"url":"https:\/\/community.smartsheet.com\/discussion\/102774\/join-ancestors-help","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/102774\/join-ancestors-help","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/EI1JZUZLFVTK\/parent-help-png.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Parent Help.PNG"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-03-20T17:25:52+00:00","dateAnswered":"2023-03-20T11:56:21+00:00","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":76319,"type":"question","name":"Sharing & Permissions within Workspaces","excerpt":"I have a Workspace created that houses a number of different dashboards, sheets and reports. If I share the entire workspace with a group of people, is it possible to go in and remove them from select dashboards\/reports? Most users will have access to all assets but there are certain pieces we'd like to restrict access on.…","categoryID":321,"dateInserted":"2021-02-18T15:05:59+00:00","dateUpdated":null,"dateLastComment":"2023-05-24T14:39:57+00:00","insertUserID":120233,"insertUser":{"userID":120233,"name":"Chelsea LeBlanc","url":"https:\/\/community.smartsheet.com\/profile\/Chelsea%20LeBlanc","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!Dy9bA0Qyw3o!nLdbn1ApDLw!oe7a2HkSAd2","dateLastActive":"2022-07-01T01:24:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":153639,"lastUser":{"userID":153639,"name":"Allyson Sullivan","url":"https:\/\/community.smartsheet.com\/profile\/Allyson%20Sullivan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-06T16:22:10+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":536,"score":2,"hot":3298602956,"url":"https:\/\/community.smartsheet.com\/discussion\/76319\/sharing-permissions-within-workspaces","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/76319\/sharing-permissions-within-workspaces","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2021-02-18T15:21:27+00:00","dateAnswered":"2021-02-18T15:20:12+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":105636,"type":"question","name":"How to add rows in Project Plan Sheet Summary Section without formulas?","excerpt":"I want to add two more rows within the summary section of our project plan sheet. When I add these rows and insert text into a cell, the row gets populated with \"Not started\" and assigned a health. The current rows in the summary section do not get autopopulated but have the same formulas attached to them. These new rows…","categoryID":322,"dateInserted":"2023-05-24T13:16:05+00:00","dateUpdated":"2023-05-24T13:17:29+00:00","dateLastComment":"2023-05-24T14:38:24+00:00","insertUserID":161354,"insertUser":{"userID":161354,"name":"elanadicocco","title":"Research Coordinator","url":"https:\/\/community.smartsheet.com\/profile\/elanadicocco","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-24T14:38:58+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":161354,"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":"2023-06-10T20:34:55+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":37,"score":null,"hot":3369875069,"url":"https:\/\/community.smartsheet.com\/discussion\/105636\/how-to-add-rows-in-project-plan-sheet-summary-section-without-formulas","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105636\/how-to-add-rows-in-project-plan-sheet-summary-section-without-formulas","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-05-24T14:38:24+00:00","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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">