欢迎来到Smartsheet论坛档案


本论坛中的帖子不再被监控准确性，其内容可能不再是最新的。如果这里有您感兴趣的讨论，并且您想找到(或创建)一个更最新的版本，请访问当前论坛。

Web表单

马里奥
马里奥 ✭
编辑12/09/19 在2015年

我想能够改变形式的宽度

我希望表格能够识别电子邮件中的条目是一个实际的电子邮件地址

标签:
· 在Facebook上分享 在推特上分享

评论

  • 杰里米·米歇尔
    杰里米·米歇尔 ✭✭✭✭✭

    改变表单的宽度会给你带来什么?我只是好奇，看看这对我是否也有帮助。我们使用了大量的网页表单，并一直在寻求改进它们。

    · 在Facebook上分享 在推特上分享
  • 马里奥
    马里奥 ✭

    你好，谢谢你的问题。我经常用网络表格做调查。当我需要使用单选按钮(水平)，一些按钮显示在第二行和形式不好看。

    我可以使用垂直单选按钮或下拉列表，但这样调查表格要么变得太长，要么让被调查的客户感到困惑。

    · 在Facebook上分享 在推特上分享
  • 杰里米·米歇尔
    杰里米·米歇尔 ✭✭✭✭✭

    我们解决这个问题的方法是在工作表中创建一个公式列，将多个列拉到一起。使web表单数据更加统一，不需要更多的选项。当使用下拉列表时，一次会选择三到四个项目。很长的单线。

    · 在Facebook上分享 在推特上分享
  • 马里奥
    马里奥 ✭
    编辑04/06/15

    谢谢你！

    既然你提到了它，我在想我可以在描述字段中解释每个按钮的含义，然后按钮只能被标记为A - B - C等，或者我可以使用数字代替。

    我需要至少五种不同的选择，这样我的客户才能将我的服务从差到优。请见附件。在这种形式中，如果我添加另一个按钮，它将显示在另一行，这是我试图避免的。我希望我说的有意义。

    再次感谢您的反馈。

    · 在Facebook上分享 在推特上分享
  • PPS的解决方案
    PPS的解决方案 ✭✭✭✭✭
    编辑04/06/15

    嗨Mario，虽然web表单功能在Smartsheet是伟大的，更全面的表单选项和布局灵活性，考虑使用第三方工具之一，与Smartsheet或其他不整合，但可以通过Zapier与Smartsheet对话。

    彼得

    · 在Facebook上分享 在推特上分享
  • 特拉维斯
    特拉维斯 员工

    彼得提出了一个好建议。我们与谷歌表单集成，允许您在谷歌表单中构建表单，并将条目添加到表中。查看这个关于集成的页面，并观看一个以客户满意度调查为例的视频。

    //www.santa-greenland.com/apps/google-forms-smartsheet-sync

    · 在Facebook上分享 在推特上分享
  • 马里奥
    马里奥 ✭

    谢谢大家。这太棒了!我一直在摆弄SS的表格，但我对我的调查不太满意。我想我会尝试与谷歌表单的交互

    这个社区讨论是个好主意!我越来越喜欢它的每一分钟。笑

    · 在Facebook上分享 在推特上分享
这次讨论已经结束。

类别

\"//www.santa-greenland.com/community/discussion/66/\", SPI@row:CPI@row) Desired Results: If SPI & CPI are Not Blank Provide an Average. If They are Blank Then The Results Should Be Blank \/ Empty. Thanks","categoryID":322,"dateInserted":"2023-02-10T21:27:54+00:00","dateUpdated":null,"dateLastComment":"2023-02-10T22:33:44+00:00","insertUserID":146904,"insertUser":{"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":"✭✭"},"updateUserID":null,"lastUserID":146904,"lastUser":{"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":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":14,"score":null,"hot":3352134098,"url":"https:\/\/community.smartsheet.com\/discussion\/101006\/average-if-not-blank","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/101006\/average-if-not-blank","format":"Rich","lastPost":{"discussionID":101006,"commentID":361816,"name":"Re: Average If Not Blank","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/361816#Comment_361816","dateInserted":"2023-02-10T22:33:44+00:00","insertUserID":146904,"insertUser":{"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":"✭✭"}},"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-10T22:33:13+00:00","dateAnswered":"2023-02-10T22:06:46+00:00","acceptedAnswers":[{"commentID":361812,"body":"

@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":"

Hi @Pamb10<\/a> <\/p>

It is but you will need to use a hidden helper column, please see example below. As notifications are row based and would be triggered based on activity in the child row, you simply need to bring the parent row project name down to each row.<\/p>

\n
\n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n

Formula for copying - =PARENT(Parent@row)<\/p>

\n
\n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n

You can then reference the Helper column in your notifications against the child tasks as and when triggered<\/p>

Hope that helps<\/p>

Thanks<\/p>

Paul<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2023-02-10 16:32:36","updateUser":{"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":"✭✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":[]}],"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">