在表单上输入时，Webform名称与联系人列表不匹配
评论
-
特拉维斯 员工嗨，Mark - web表单没有办法查看您的联系人或链接输入的名称到您的工作表中的智能表用户。最好的选择是在提交表单后在表单中修改名称。
0 -
斯蒂芬妮·泰勒 ✭✭✭✭✭✭你能在网页表单中预先填充名字吗?这样，它们就会与您的联系人列表相匹配。还是有太多不同的人在使用你的网页表单?
0 -
特拉维斯 员工
Stephanie -您可以用单个值预填充联系人列表字段，但这将作为文本输入，而不是作为联系人(就像您键入它一样)。目前没有将输入的名称链接到用户的解决方案。您需要在表单中修改名称。
我会把这个功能建议传递给我们的产品团队!ob欧宝娱乐app手机下载
0 -
谢谢你的建议。修改名称以匹配先前存在的提交者是现在必须做的事情。这是一个繁重的手工过程。如果web表单的提交者之前已经使用过该表单，那么它可以将名称提供给提交者。因此，当提交者开始从智能表预先存在的信息中输入他们的名字时，这将允许他们选择匹配。这是smartsheet能想到的吗?谢谢。
0 -
特拉维斯 员工
Mark -这个功能近期没有任何计划，但是我已经把这个请求发送给了我们的产品团队，以便在未来的开发中考虑。ob欧宝娱乐app手机下载谢谢马克!
0 -
大卫•鲍曼 ✭✭✭✭✭✭
我同意马克的观点!这太有帮助了。在工作表中，联系人是从下拉菜单中选择的，但是Webform中的相同字段没有给您下拉选项(不像其他下拉字段可以工作……)看来这是一件很重要的事。
谢谢!
戴夫
1 -
如果你使用联系人的电子邮件地址而不是他们的名字，那么SmartSheet就会建立连接。这在webforms和将excel数据复制到具有联系人字段的Smartsheet中非常有用。
0 -
嗨,伙计们,
这个功能什么时候会加入有什么消息吗?
K
0 -
嗨,伙计们,
只是一个关于联系人姓名的网络表单问题的想法。假设智能表单促进协作的逻辑，在这种情况下，您可以确定正确的名称和人员正在协作，那么您在现有智能表单用户的webform上有一个下拉名称选择不是很有意义吗?
如果这个人是新来的，他们需要一个基本的注册来保持他们的联系方式的一致?当然，只在需要联系人姓名的网页表单上。
具有自由形式的不一致的名称和手动纠正的可伸缩性不适用于大量人口。
谢谢,
马克0 -
特拉维斯 员工
大家好!我们感谢您的反馈并理解您的担忧。我们的目标是使Smartsheet成为协作，计划和监控项目和任务的最佳和最简单的方式，并不断改进产品。ob欧宝娱乐app手机下载我没有任何关于这个特殊功能的更新，但你可以查看我们的产品路线图，看看我们目前正在做什么:ob欧宝娱乐app手机下载www.santa-greenland.com/ob欧宝娱乐app手机下载product-roadmap
0 -
这是一个很好的请求，我将检查路线图，看看它是否很快!
0 -
戈登 ✭✭✭✭✭✭
根据Brian Veasman之前的建议，我尝试在webform联系人列表字段中输入电子邮件地址，但S/S似乎仍然无法将工作表中的电子邮件地址连接到我现有的团队帐户/联系人数据。
这个关键功能有什么更新吗，或者有什么创造性的解决方案?我正在寻找一种方法来设置提醒和警报绑定到一个联系人列表字段的表是通过webform输入。
0 -
肯特·沃恩 ✭✭✭✭✭✭
我加1分。
这是另一个我很难相信没有实现的功能。除非我遗漏了一些关键的细节，否则如果我没有联系信息，那么提醒/提醒将无法发送电子邮件，对吗?因此，这意味着尝试通过web表单做一些简单的操作项列表意味着您必须进入工作表以输入实际的联系信息。(也许可以在联系人栏中输入电子邮件地址，并在联系人栏中添加“链接”。但是必须为每一个“待办事项”输入一个电子邮件地址似乎非常低效)。
0 -
我加1分。
我参加了一些SS培训，并且我在基于最佳实践创建表格和报告方面做得越来越好，但是我使用的功能越多，SS产品中出现的漏洞就越多……ob欧宝娱乐app手机下载
0
类别
I hope you're well and safe!<\/p>
Unfortunately, you can't. You'll have to do it one by one, either moving them around in the Workbook or splitting them into different sheets.<\/p>
Would that work\/help? <\/p>
I hope that helps!<\/p>
Be safe, and have a fantastic week!<\/p>
Best,<\/p>
Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p> ✅Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-09-21 22:33:19","updateUser":{"userID":152663,"name":"rtrosper","url":"https:\/\/community.smartsheet.com\/profile\/rtrosper","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!HhFqH5JDl3s!XWcoX85eCjs!dlPh9heeTbQ","dateLastActive":"2022-09-21T22:32:39+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":[{"tagID":278,"urlcode":"Importing and Exporting","name":"Importing and Exporting"}]},{"discussionID":95731,"type":"question","name":"IF Formula with multiple layers","excerpt":"Hi community, I'm looking for help on creating a multi-layered IF formula for the following guidelines. Anyone an expert that can help me build it out? IF amount is > $100K Then this should be 4 IF amount is <$100K - $125K Then this should be 6 IF amount is <$125K - $150K Then this should be 8 IF amount is <$150K - $175K…","categoryID":322,"dateInserted":"2022-09-21T21:22:26+00:00","dateUpdated":null,"dateLastComment":"2022-09-21T22:48:31+00:00","insertUserID":152671,"insertUser":{"userID":152671,"name":"danielle.taylor","url":"https:\/\/community.smartsheet.com\/profile\/danielle.taylor","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-21T22:46:47+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":152671,"lastUser":{"userID":152671,"name":"danielle.taylor","url":"https:\/\/community.smartsheet.com\/profile\/danielle.taylor","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-21T22:46:47+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":18,"score":null,"hot":3327597057,"url":"https:\/\/community.smartsheet.com\/discussion\/95731\/if-formula-with-multiple-layers","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95731\/if-formula-with-multiple-layers","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":95731,"commentID":344362,"name":"Re: IF Formula with multiple layers","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/344362#Comment_344362","dateInserted":"2022-09-21T22:48:31+00:00","insertUserID":152671,"insertUser":{"userID":152671,"name":"danielle.taylor","url":"https:\/\/community.smartsheet.com\/profile\/danielle.taylor","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-21T22:46:47+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":"2022-09-21T22:46:44+00:00","dateAnswered":"2022-09-21T22:39:57+00:00","acceptedAnswers":[{"commentID":344359,"body":" Let's pretend the column with the financial amounts is: \"Employee Bonus\"<\/p> This is the formula:<\/p> you don't need the equals sign after your type of media range, you need a comma to distinguish the criterion range from the criteria<\/p> it should look like this<\/p> =SUMIFS([Total Pieces of Media]:[Total Pieces of Media], [Type of Media]:[Type of Media] ,\"Still\", [Current \/ Upcoming (USC\/NARA)]:[Current \/ Upcoming (USC\/NARA)], ISBLANK(@cell))<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-09-21 21:41:20","updateUser":{"userID":122484,"name":"Olivia Doiron","url":"https:\/\/community.smartsheet.com\/profile\/Olivia%20Doiron","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!!meFQPnRXLno!HgjXX29LlqY!R2PknPxzi18","dateLastActive":"2022-09-21T21:38:01+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":[]}],"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">=IF([Employee Bonus]@row>225000, 16, IF(AND([Employee Bonus]@row>=200000, [Employee Bonus]@row<=225000), 14, IF(AND([Employee Bonus]@row>=175000, [Employee Bonus]@row<=199999), 12, IF(AND([Employee Bonus]@row>=150000, [Employee Bonus]@row<=174999), 10, IF(AND([Employee Bonus]@row>=125000, [Employee Bonus]@row<=149999), 8, IF(AND([Employee Bonus]@row>=100000, [Employee Bonus]@row<=124999), 6, IF([Employee Bonus]@row<100000, 4, \"//www.santa-greenland.com/community/discussion/comment/688/\")))))))\n\n<\/pre>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-09-21 22:46:44","updateUser":{"userID":152671,"name":"danielle.taylor","url":"https:\/\/community.smartsheet.com\/profile\/danielle.taylor","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-21T22:46:47+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":95728,"type":"question","name":"Trying to Figure Out a SUMIFS Formula","excerpt":"I am trying to create a formula that add the 'total pieces of media' if the 'type of media' is 'still' and the 'current \/ upcoming' is empty. The formula I am using is below and I keep getting invalid operation. Not sure what I am doing wrong. Thank you for any help I can get. :) =SUMIFS([Total Pieces of Media]:[Total…","categoryID":322,"dateInserted":"2022-09-21T21:00:42+00:00","dateUpdated":null,"dateLastComment":"2022-09-21T21:42:00+00:00","insertUserID":122484,"insertUser":{"userID":122484,"name":"Olivia Doiron","url":"https:\/\/community.smartsheet.com\/profile\/Olivia%20Doiron","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!!meFQPnRXLno!HgjXX29LlqY!R2PknPxzi18","dateLastActive":"2022-09-21T21:38:01+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":122484,"lastUser":{"userID":122484,"name":"Olivia Doiron","url":"https:\/\/community.smartsheet.com\/profile\/Olivia%20Doiron","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!!meFQPnRXLno!HgjXX29LlqY!R2PknPxzi18","dateLastActive":"2022-09-21T21:38:01+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":28,"score":null,"hot":3327591762,"url":"https:\/\/community.smartsheet.com\/discussion\/95728\/trying-to-figure-out-a-sumifs-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95728\/trying-to-figure-out-a-sumifs-formula","format":"Rich","lastPost":{"discussionID":95728,"commentID":344341,"name":"Re: Trying to Figure Out a SUMIFS Formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/344341#Comment_344341","dateInserted":"2022-09-21T21:42:00+00:00","insertUserID":122484,"insertUser":{"userID":122484,"name":"Olivia Doiron","url":"https:\/\/community.smartsheet.com\/profile\/Olivia%20Doiron","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!!meFQPnRXLno!HgjXX29LlqY!R2PknPxzi18","dateLastActive":"2022-09-21T21:38:01+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":"2022-09-21T21:41:20+00:00","dateAnswered":"2022-09-21T21:07:54+00:00","acceptedAnswers":[{"commentID":344330,"body":"
