谷歌表单同步与Smartsheet

c.nak
c.nak ✭✭
编辑06/14/22 在添加插件和集成

你好,

我有几个关于将Google表单响应同步到Smartsheet的问题。我已经按照说明做了，并将两者连接起来，但答案没有记录在新的表格中。通常会有延迟吗?还是有什么东西不能正常工作?

此外，我还有一些“无题”问题，用于捕获对问题的可选评论。它们不包括在Smartsheet列中，所以这些需要“命名”以添加到/捕获响应中吗?这些可能是表格没有正确记录的问题吗?

任何帮助感激和感谢提前。

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

评论

类别

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

I hope you're well and safe!<\/p>

There's a known issue at the moment.<\/p>

\n \n https:\/\/status.smartsheet.com\/incidents\/n3gv8nrd6cyf\n <\/a>\n<\/div>


<\/p>

\n \n https:\/\/status.smartsheet.com\/\n <\/a>\n<\/div>

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"},"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":[]},{"discussionID":106259,"type":"question","name":"Calculate workdays, excluding weekends (Days elapsed)","excerpt":"I found the solution for \"How to calculate days a ticket is open\/closed\" on your site (solution submitted by Andrée Starå), but, I need the formula to count just the weekdays, excluding weekends. I tried a couple of different ways, but cannot get it to work properly. Any help would be greatly appreciated! This is the…","categoryID":321,"dateInserted":"2023-06-09T12:23:45+00:00","dateUpdated":null,"dateLastComment":"2023-06-12T17:37:13+00:00","insertUserID":162244,"insertUser":{"userID":162244,"name":"Seneca","title":"Technical Writer","url":"https:\/\/community.smartsheet.com\/profile\/Seneca","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/5100NMIIA7HJ\/n3UY7D9OQBBU6.jpg","dateLastActive":"2023-06-12T17:33:07+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":162244,"lastUser":{"userID":162244,"name":"Seneca","title":"Technical Writer","url":"https:\/\/community.smartsheet.com\/profile\/Seneca","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/5100NMIIA7HJ\/n3UY7D9OQBBU6.jpg","dateLastActive":"2023-06-12T17:33:07+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":96,"score":null,"hot":3372908458,"url":"https:\/\/community.smartsheet.com\/discussion\/106259\/calculate-workdays-excluding-weekends-days-elapsed","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106259\/calculate-workdays-excluding-weekends-days-elapsed","format":"Rich","lastPost":{"discussionID":106259,"commentID":380147,"name":"Re: Calculate workdays, excluding weekends (Days elapsed)","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380147#Comment_380147","dateInserted":"2023-06-12T17:37:13+00:00","insertUserID":162244,"insertUser":{"userID":162244,"name":"Seneca","title":"Technical Writer","url":"https:\/\/community.smartsheet.com\/profile\/Seneca","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/5100NMIIA7HJ\/n3UY7D9OQBBU6.jpg","dateLastActive":"2023-06-12T17:33:07+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\/Y6CX51TQRVBZ\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-12T17:37:11+00:00","dateAnswered":"2023-06-12T17:19:34+00:00","acceptedAnswers":[{"commentID":380143,"body":"

Either of these should work. They just approach the logic from a different direction.<\/p>


<\/p>

=IF([Project Completion Date]@row <> \"//www.santa-greenland.com/community/discussion/30691/\", NETWORKDAYS([Project Start Date]@row, [Project Completion Date]@row), NETWORKDAYS([Project Start Date]@row, TODAY()))<\/p>


<\/p>

=IF([Project Completion Date]@row = \"//www.santa-greenland.com/community/discussion/30691/\", NETWORKDAYS([Project Start Date]@row, TODAY()), NETWORKDAYS([Project Start Date]@row, [Project Completion Date]@row))<\/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":[]},{"discussionID":106251,"type":"question","name":"Unable to edit dashboard with Admin rights","excerpt":"Hello all, I have added a user as an admin for a dashboard but she is unable to see the edit (pencil) button. Tried adding her as admin in the workspace but still doesn't work. Any idea? We are on Enterprise plan. Thank you.","categoryID":321,"dateInserted":"2023-06-09T06:08:55+00:00","dateUpdated":"2023-06-09T07:54:11+00:00","dateLastComment":"2023-06-12T13:55:34+00:00","insertUserID":124399,"insertUser":{"userID":124399,"name":"firestorm","url":"https:\/\/community.smartsheet.com\/profile\/firestorm","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!0pnQ_1i5ezw!2uNXv2NG1jQ!_3DRw9ClXTT","dateLastActive":"2023-06-12T07:56:55+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":91566,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-06-12T22:47:24+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":10,"countViews":68,"score":null,"hot":3372875069,"url":"https:\/\/community.smartsheet.com\/discussion\/106251\/unable-to-edit-dashboard-with-admin-rights","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106251\/unable-to-edit-dashboard-with-admin-rights","format":"Rich","tagIDs":[292],"lastPost":{"discussionID":106251,"commentID":380080,"name":"Re: Unable to edit dashboard with Admin rights","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380080#Comment_380080","dateInserted":"2023-06-12T13:55:34+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-06-12T22:47:24+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-06-12T08:23:14+00:00","dateAnswered":"2023-06-12T04:13:41+00:00","acceptedAnswers":[{"commentID":380023,"body":"

@firestorm<\/a> <\/p>

Yes, unfortunately, (if I'm not mistaken) a license is needed to be able to edit a Dashboard. <\/p>

The sheet Owner and Admins can add or edit dashboard widgets. A license is required.<\/em><\/p>

More info. <\/p>

\n \n https:\/\/help.smartsheet.com\/articles\/518558-widget-types-for-smartsheet-dashboards\n <\/a>\n<\/div>


<\/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":[{"tagID":292,"urlcode":"Dashboards","name":"Dashboards"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=341&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&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":5371,"limit":3},"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

使用Smartsheet的趋势