Web表单
评论
-
杰里米·米歇尔 ✭✭✭✭✭改变表单的宽度会给你带来什么?我只是好奇，看看这对我是否也有帮助。我们使用了大量的网页表单，并一直在寻求改进它们。
-
马里奥 ✭你好，谢谢你的问题。我经常用网络表格做调查。当我需要使用单选按钮(水平)，一些按钮显示在第二行和形式不好看。
我可以使用垂直单选按钮或下拉列表，但这样调查表格要么变得太长，要么让被调查的客户感到困惑。
-
杰里米·米歇尔 ✭✭✭✭✭
我们解决这个问题的方法是在工作表中创建一个公式列，将多个列拉到一起。使web表单数据更加统一，不需要更多的选项。当使用下拉列表时，一次会选择三到四个项目。很长的单线。
-
马里奥 ✭
谢谢你！
既然你提到了它，我在想我可以在描述字段中解释每个按钮的含义，然后按钮只能被标记为A - B - C等，或者我可以使用数字代替。
我需要至少五种不同的选择，这样我的客户才能将我的服务从差到优。请见附件。在这种形式中，如果我添加另一个按钮，它将显示在另一行，这是我试图避免的。我希望我说的有意义。
再次感谢您的反馈。
-
PPS的解决方案 ✭✭✭✭✭嗨Mario，虽然web表单功能在Smartsheet是伟大的，更全面的表单选项和布局灵活性，考虑使用第三方工具之一，与Smartsheet或其他不整合，但可以通过Zapier与Smartsheet对话。
彼得
-
特拉维斯 员工彼得提出了一个好建议。我们与谷歌表单集成，允许您在谷歌表单中构建表单，并将条目添加到表中。查看这个关于集成的页面，并观看一个以客户满意度调查为例的视频。
-
马里奥 ✭
谢谢大家。这太棒了!我一直在摆弄SS的表格，但我对我的调查不太满意。我想我会尝试与谷歌表单的交互
这个社区讨论是个好主意!我越来越喜欢它的每一分钟。
类别
@Kaleb<\/a> Try this:<\/p> =IF(AVERAGEIF(SPI@row:CPI@row, <>\"//www.santa-greenland.com/community/discussion/66/\", SPI@row:CPI@row) = 0, \"//www.santa-greenland.com/community/discussion/66/\", AVERAGEIF(SPI@row:CPI@row, <>\"//www.santa-greenland.com/community/discussion/66/\", SPI@row:CPI@row))<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2023-02-10 22:33:13","updateUser":{"userID":146904,"name":"Kaleb","url":"https:\/\/community.smartsheet.com\/profile\/Kaleb","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!hzlAoSbUIDs!hU_D4f686H8!MeM8OksBL1v","dateLastActive":"2023-02-10T22:32:24+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"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}],"tags":[]},{"discussionID":100996,"type":"question","name":"Networkday Formula Not Working Correctly","excerpt":"I'm using the networkday formula to gather the number of working days between two dates and then dividing that number by 5 to get the total number of weeks. However, the formula doesn't seem to provide the correct answer unless I change the dividing number to 4.7 (no idea why that would work since there's 5 days in a…","categoryID":322,"dateInserted":"2023-02-10T18:57:16+00:00","dateUpdated":null,"dateLastComment":"2023-02-10T21:54:48+00:00","insertUserID":149834,"insertUser":{"userID":149834,"name":"Sarah123","url":"https:\/\/community.smartsheet.com\/profile\/Sarah123","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pz9CadKbo_o!29DB_y7O5eQ!floqOYAlioC","dateLastActive":"2023-02-10T21:55:05+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":86866,"lastUser":{"userID":86866,"name":"Jeff Reisman","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Jeff%20Reisman","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/3V8W2AM105QE\/nIDXI4I7VDS7W.JPG","dateLastActive":"2023-02-10T21:55:20+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":20,"score":null,"hot":3352122124,"url":"https:\/\/community.smartsheet.com\/discussion\/100996\/networkday-formula-not-working-correctly","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/100996\/networkday-formula-not-working-correctly","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":100996,"commentID":361811,"name":"Re: Networkday Formula Not Working Correctly","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/361811#Comment_361811","dateInserted":"2023-02-10T21:54:48+00:00","insertUserID":86866,"insertUser":{"userID":86866,"name":"Jeff Reisman","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Jeff%20Reisman","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/3V8W2AM105QE\/nIDXI4I7VDS7W.JPG","dateLastActive":"2023-02-10T21:55:20+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-02-10T21:55:51+00:00","dateAnswered":"2023-02-10T21:54:48+00:00","acceptedAnswers":[{"commentID":361811,"body":" @Sarah123<\/a> <\/p> If there's a holiday that falls between your start and end dates, that could affect your math results, because there would only be 4 days in that particular work week.<\/p> You might try using the WEEKNUMBER<\/a> function. Subtract the WEEKNUMBER([Start Date]@row) from the WEEKNUMBER([End Date]@row) and you get a pretty accurate idea of how many weeks. <\/p> You can tweak this to only include complete weeks by using the WEEKDAY function, for instance to say if the WEEKDAY(1 for Sunday, 2 for Monday, etc) of the End Date is less than the WEEKDAY of the Start Date, to subtract 1 from the difference between the end week and the start week.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2023-02-10 21:55:51","updateUser":{"userID":149834,"name":"Sarah123","url":"https:\/\/community.smartsheet.com\/profile\/Sarah123","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pz9CadKbo_o!29DB_y7O5eQ!floqOYAlioC","dateLastActive":"2023-02-10T21:55:05+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"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}],"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":100985,"type":"question","name":"Customized Workflow Notifications","excerpt":"I am investigating the use of workflow notifications. In my sheet I have a parent row with a row for the Project Name. Each child row has the Task name. They use the same column. I am wondering if it is possible to refer to the parent (Project Name) in a notification for a child task in the notification message content.…","categoryID":321,"dateInserted":"2023-02-10T16:05:55+00:00","dateUpdated":null,"dateLastComment":"2023-02-10T16:32:33+00:00","insertUserID":106346,"insertUser":{"userID":106346,"name":"Pamb10","url":"https:\/\/community.smartsheet.com\/profile\/Pamb10","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-10T16:31:53+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":106346,"lastUser":{"userID":106346,"name":"Pamb10","url":"https:\/\/community.smartsheet.com\/profile\/Pamb10","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-10T16:31:53+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":23,"score":null,"hot":3352093108,"url":"https:\/\/community.smartsheet.com\/discussion\/100985\/customized-workflow-notifications","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/100985\/customized-workflow-notifications","format":"Rich","lastPost":{"discussionID":100985,"commentID":361772,"name":"Re: Customized Workflow Notifications","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/361772#Comment_361772","dateInserted":"2023-02-10T16:32:33+00:00","insertUserID":106346,"insertUser":{"userID":106346,"name":"Pamb10","url":"https:\/\/community.smartsheet.com\/profile\/Pamb10","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-10T16:31:53+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-02-10T16:32:36+00:00","dateAnswered":"2023-02-10T16:28:47+00:00","acceptedAnswers":[{"commentID":361771,"body":"
![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/LO9EEXGKMA5B\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/MBOBMSYSXWNS\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
