形式
讨论表
at the top because they don't want anyone to have access to the…","categoryID":321,"dateInserted":"2023-03-22T21:35:15+00:00","dateUpdated":"2023-03-23T12:07:17+00:00","dateLastComment":"2023-03-24T15:51:43+00:00","insertUserID":151846,"insertUser":{"userID":151846,"name":"Marcia562","url":"https:\/\/community.smartsheet.com\/profile\/Marcia562","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!k7lTf3TKRD0!XacpX0JyFDo!s5oPSjX47im","dateLastActive":"2023-06-08T22:36:39+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":91566,"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-08T20:51:15+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":107,"score":null,"hot":3359198218,"url":"https:\/\/community.smartsheet.com\/discussion\/103046\/survey-form-automation-teams-integration","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/103046\/survey-form-automation-teams-integration","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/SGQGNUKUVNZE\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-03-24T03:39:24+00:00","dateAnswered":"2023-03-24T03:04:17+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"},{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":448,"urlcode":"workflows-in-smartsheet","name":"Workflows in Smartsheet"}],"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":103124,"type":"question","name":"If there are multiple batch numbers, how can I make that go to different rows instead of columns?","excerpt":"Hello, I am trying to create a form that allows you to enter in when you receive different batches. Sometimes we receive multiple batch numbers at once. Is there a way to make it so that if multiple batch numbers are chosen that all the data will copy to another row instead of another column within the same row? Right now…","categoryID":322,"dateInserted":"2023-03-24T14:26:26+00:00","dateUpdated":null,"dateLastComment":"2023-03-24T15:51:17+00:00","insertUserID":159528,"insertUser":{"userID":159528,"name":"tchav","url":"https:\/\/community.smartsheet.com\/profile\/tchav","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-01T00:55:45+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":159528,"lastUser":{"userID":159528,"name":"tchav","url":"https:\/\/community.smartsheet.com\/profile\/tchav","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-01T00:55:45+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":58,"score":null,"hot":3359342863,"url":"https:\/\/community.smartsheet.com\/discussion\/103124\/if-there-are-multiple-batch-numbers-how-can-i-make-that-go-to-different-rows-instead-of-columns","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/103124\/if-there-are-multiple-batch-numbers-how-can-i-make-that-go-to-different-rows-instead-of-columns","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/AKSDPNOSMNI5\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-03-24T15:34:42+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":204,"urlcode":"Forms","name":"Forms"},{"tagID":281,"urlcode":"Support","name":"Support"},{"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":103015,"type":"question","name":"How to have only certain fields show on a form based on a condition","excerpt":"Trying to create One form where users can submit an enhancement request and based on the \"Request Type\" (a drop-down list), only certain fields will display and other fields will not display. For example, if a user selects Request Type = Report, then I want only report related fields to display. If a user selects Request…","categoryID":321,"dateInserted":"2023-03-22T15:20:09+00:00","dateUpdated":null,"dateLastComment":"2023-03-22T15:25:25+00:00","insertUserID":139576,"insertUser":{"userID":139576,"name":"K Miller","url":"https:\/\/community.smartsheet.com\/profile\/K%20Miller","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!hAtpoYJ45_M!Dl1TQ0DO0iQ!MPp8IQrC3KR","dateLastActive":"2023-05-05T16:05:51+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-08T23:29:29+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":66,"score":null,"hot":3358997734,"url":"https:\/\/community.smartsheet.com\/discussion\/103015\/how-to-have-only-certain-fields-show-on-a-form-based-on-a-condition","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/103015\/how-to-have-only-certain-fields-show-on-a-form-based-on-a-condition","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-03-22T15:25:25+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"},{"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":100594,"type":"discussion","name":"Self-Update Solution - Enabling [outside] users to edit previously submitted content","excerpt":"If you host a set of records that \"belong\" to others, and you want them to be able to edit their records at any time, check out this dashboard as a seedbed of ideas for how you could achieve this. Please suggest other wording I could edit into in this title or entry to help people find this. I'm doubtful \"self-update\" is…","categoryID":322,"dateInserted":"2023-02-02T18:53:12+00:00","dateUpdated":null,"dateLastComment":"2023-03-22T12:03:16+00:00","insertUserID":105651,"insertUser":{"userID":105651,"name":"Cleversheet","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Cleversheet","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-09\/9d\/3c\/n9d3cda2a97cae4b01fcea6153d986565.jpg","dateLastActive":"2023-06-07T14:34:30+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":105651,"lastUser":{"userID":105651,"name":"Cleversheet","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Cleversheet","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-09\/9d\/3c\/n9d3cda2a97cae4b01fcea6153d986565.jpg","dateLastActive":"2023-06-07T14:34:30+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":56,"score":1,"hot":3354851488,"url":"https:\/\/community.smartsheet.com\/discussion\/100594\/self-update-solution-enabling-outside-users-to-edit-previously-submitted-content","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/100594\/self-update-solution-enabling-outside-users-to-edit-previously-submitted-content","format":"Rich","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":204,"urlcode":"Forms","name":"Forms"},{"tagID":245,"urlcode":"Sharing","name":"Sharing and Collaboration"},{"tagID":446,"urlcode":"update-requests","name":"Update Requests"},{"tagID":448,"urlcode":"workflows-in-smartsheet","name":"Workflows in Smartsheet"}],"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":102244,"type":"question","name":"How to prepopulate a form using the row as a reference?","excerpt":"Hello, I apologize for the simple question. I am a beginner with Smartsheet but I have not found the question answered in the help sheets. I would like to prepopulate a form answer using the row as reference. I can get the form to prepopulate but I have to enter the address manually in the formula each time. I have…","categoryID":322,"dateInserted":"2023-03-07T17:22:09+00:00","dateUpdated":"2023-03-08T10:14:59+00:00","dateLastComment":"2023-03-21T18:22:01+00:00","insertUserID":159109,"insertUser":{"userID":159109,"name":"Craig B.","url":"https:\/\/community.smartsheet.com\/profile\/Craig%20B.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-16T16:15:42+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":159706,"lastUser":{"userID":159706,"name":"Carlos D","url":"https:\/\/community.smartsheet.com\/profile\/Carlos%20D","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AATXAJweNtJVt8RTeDCYeAmpqg83pk8Gm6Vv296_KUKd=s96-c","dateLastActive":"2023-03-31T20:09:33+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":122,"score":null,"hot":3357633850,"url":"https:\/\/community.smartsheet.com\/discussion\/102244\/how-to-prepopulate-a-form-using-the-row-as-a-reference","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/102244\/how-to-prepopulate-a-form-using-the-row-as-a-reference","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-03-10T15:40:31+00:00","dateAnswered":"2023-03-09T13:48:05+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":204,"urlcode":"Forms","name":"Forms"},{"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">