欢迎来到Smartsheet论坛档案


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

将多行导入到web表单中

mikelondon
mikelondon ✭
编辑12/09/19 在2017年发布的文章

我需要从供应商那里得到大约12个项目的库存申报单。我想每周给他发一个网络表单，他可以完成并提交回来，这将反过来在智能表中填充12个新行。然后，我将使用更新来更新主库存清单表(使用Azuqua)。但我需要把每个人每周提交的材料单独放在一张纸上。问题:是否有第三方应用程序，我可以使用它来收集数据通过一个网络表单，然后我可以发布到SS使用Zapier?当然，原生的SS webform只能发布到一行，这在这种情况下是没有用的。

谢谢你！

标签:
· 在Facebook上分享 在Twitter上分享

评论

  • 格温妮丝C
    格温妮丝C ✭✭✭✭✭✭

    嗨Mikelondon,

    我认为更新请求功能可能会有所帮助。您需要创建单独的工作表，其中包含您希望供应商更新的列。然后，您可以在工作表中选择12行，并将请求发送给供应商，让他们用您需要的信息更新所有12行。

    这里有一个链接，可以从我们的帮助中心获得更多信息(还有一个视频)。

    使用更新请求

    https://help.smartsheet.com/articles/504779-using-update-requests

    如果你已经尝试过(或者不是你所需要的)，请回复。也许这里的其他人用不同的方法解决了这个问题。

    干杯!

    格温妮斯

    · 在Facebook上分享 在Twitter上分享
  • mikelondon
    mikelondon ✭

    亲爱的格温妮斯

    谢谢你的建议。我可以通过交换x轴和y轴来做我需要做的事情。否则，我可能需要使用表单应用程序，然后使用Zapier将数据输入SS。你能推荐一个表单应用吗?再次感谢。

    · 在Facebook上分享 在Twitter上分享
这次讨论已经结束了。

类别

@Kirsteen Leckie<\/a> <\/p>

I made some tweaks to the formula, please try below<\/p>

=IF([Client review Required]@row = \"Yes\", IF([Actual Submit Date]@row = \"//www.santa-greenland.com/community/discussion/7490/\", \"Pending\", (IF([Actual Compete date]@row = \"//www.santa-greenland.com/community/discussion/7490/\", \"Internal Review\", (IF([Actual Date to Client]@row = \"//www.santa-greenland.com/community/discussion/7490/\", \"Send To Client\", (IF([Actual Client comments]@row = \"//www.santa-greenland.com/community/discussion/7490/\", \"Client Review\", (IF([Actual Piramal Response]@row = \"//www.santa-greenland.com/community/discussion/7490/\", \"Addressing Comments\", (IF([Actual Final Client Approval]@row = \"//www.santa-greenland.com/community/discussion/7490/\", \"Client Approval\", (IF([Actual submission to QA]@row = \"//www.santa-greenland.com/community/discussion/7490/\", \"QA Review\", (IF([Actual Final or QA Approval]@row = \"//www.santa-greenland.com/community/discussion/7490/\", \"QA Review\", \"Approved\"))))))))))))))), IF([Client review Required]@row = \"No\", IF([Actual Final or QA Approval]@row = \"//www.santa-greenland.com/community/discussion/7490/\", \"QA Review\", \"Approved\")))\n<\/pre>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"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":106601,"type":"question","name":"Please can someone help with this formula","excerpt":"I am trying to calculate how many \"qualification\" stages there are in a given fiscal period for example Q4-2023, I know I am missing something but every variation of Count if formulas I have tried do not seem to work, it will be something really simple, that I am trying to make to complicated, but any help will be…","categoryID":322,"dateInserted":"2023-06-19T15:46:15+00:00","dateUpdated":"2023-06-19T15:48:22+00:00","dateLastComment":"2023-06-19T15:54:15+00:00","insertUserID":150472,"insertUser":{"userID":150472,"name":"Mel C","url":"https:\/\/community.smartsheet.com\/profile\/Mel%20C","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-19T18:04:03+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":150472,"lastUserID":144360,"lastUser":{"userID":144360,"name":"Hollie Green","url":"https:\/\/community.smartsheet.com\/profile\/Hollie%20Green","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-19T22:11:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":26,"score":null,"hot":3374380230,"url":"https:\/\/community.smartsheet.com\/discussion\/106601\/please-can-someone-help-with-this-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106601\/please-can-someone-help-with-this-formula","format":"Rich","lastPost":{"discussionID":106601,"commentID":381177,"name":"Re: Please can someone help with this formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381177#Comment_381177","dateInserted":"2023-06-19T15:54:15+00:00","insertUserID":144360,"insertUser":{"userID":144360,"name":"Hollie Green","url":"https:\/\/community.smartsheet.com\/profile\/Hollie%20Green","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-19T22:11:33+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/MRW4VGYRA7HG\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-19T17:03:50+00:00","dateAnswered":"2023-06-19T15:54:15+00:00","acceptedAnswers":[{"commentID":381177,"body":"
It needs to be a countifs instead of countif<\/p>
=COUNTIFS([column4]2:[column4]5,\"Qualification\",[column5]2:[column5]5,\"Q4-2023\")<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"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":106596,"type":"question","name":"Changing a font in a dashboard","excerpt":"I have a dashboard using reports and metrics widgets, using sheet summaries and grid data, but the font is too large. How do I change that? In the screenshot, the red dot and the blue dot show the data that is coming from the grid data of a sheet. Is there any way of changing the font of the blue dot?","categoryID":321,"dateInserted":"2023-06-19T13:37:23+00:00","dateUpdated":"2023-06-19T13:49:50+00:00","dateLastComment":"2023-06-19T14:36:05+00:00","insertUserID":128842,"insertUser":{"userID":128842,"name":"Karen Bruer","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Karen%20Bruer","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!5MPAuTrWZX4!elHDp9qhGX4!HMSKFvshvfI","dateLastActive":"2023-06-19T14:33:19+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":91566,"lastUserID":161714,"lastUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B0Q390EZX8XK\/nBGT0U1689CN6.jpg","dateLastActive":"2023-06-20T04:02:02+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":52,"score":null,"hot":3374370208,"url":"https:\/\/community.smartsheet.com\/discussion\/106596\/changing-a-font-in-a-dashboard","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106596\/changing-a-font-in-a-dashboard","format":"Rich","lastPost":{"discussionID":106596,"commentID":381155,"name":"Re: Changing a font in a dashboard","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381155#Comment_381155","dateInserted":"2023-06-19T14:36:05+00:00","insertUserID":161714,"insertUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B0Q390EZX8XK\/nBGT0U1689CN6.jpg","dateLastActive":"2023-06-20T04:02:02+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/HHR250SXIUPY\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-19T14:35:02+00:00","dateAnswered":"2023-06-19T14:34:51+00:00","acceptedAnswers":[{"commentID":381154,"body":"
OMG, I didn't click on the widget box, now I see the edit option. Thanks so much, this is going to be a game changer for me!<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"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":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&siteSectionID=0&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":10000,"limit":3},"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
             

               

                
热门文章

               

               
    
                
  • 有几个条件的公式
    嗨，我上周在做一个公式，但我仍然在努力解决这个问题的第二个标准。它的设置方式，根据输入的日期更新字段。它的工作原理如下:=IFERROR(IF([Client review Required]@row = "Yes"， IF([实际提交日期]@row = "" "Pending"， (IF([实际…]
    • 
                
  • 请问有人能帮我弄一下这个公式吗
    我试图计算有多少“资格”阶段有一个给定的财政期间，例如第四季度-2023年，我知道我错过了一些东西，但计数的每一个变化，如果我尝试过的公式似乎不起作用，这将是一些非常简单的东西，我试图使复杂，但任何帮助将是……
    • 
                
  • 在仪表板中更改字体
    我有一个使用报告和指标小部件的仪表板，使用表格摘要和网格数据，但是字体太大了。我该如何改变呢?在截图中，红点和蓝点表示来自工作表网格数据的数据。有办法改变蓝点的字体吗?
    •