Excel导入
答案
-
她名叫Stara ✭✭✭✭✭✭
嗨,金姆,
该限制仅适用于列标题,因此如果更改名称或为标题选择另一行,则应该可以工作。
希望这对你有帮助!
祝你一周愉快!
最好的
她名叫Stara
工作流程顾问@完成咨询
智能表专家顾问兼合伙人
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时与我联系,了解有关Smartsheet,集成,一般工作流建议或其他方面的帮助。
-
她名叫Stara ✭✭✭✭✭✭
我希望你一切安好!
你能更详细地描述一下你的过程吗分享表格/表格的副本或者一些截图?(在分享之前删除/替换任何机密/敏感信息)这样更容易提供帮助。(分享,(电子邮件保护))
我希望这对你有帮助!
注意安全,祝你度过美好的一周!
最好的
✅我的帖子是否帮助或回答了你的问题或解决了你的问题?请帮助社区将其标记为可接受的答案/有用的.这将使其他人更容易找到解决方案或帮助回答!
智能表专家顾问兼合伙人
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时与我联系,了解有关Smartsheet,集成,一般工作流建议或其他方面的帮助。
-
我遇到了同样的问题,50个字符长的错误是指指定的Sheet名称。编辑工作表的名称,这应该能解决你的问题。
-
Oana。 ✭
你说得太对了!文件名必须小于50个字符,否则即使列名小于50个字符,也会出现此错误。
类别
You were on the right track.<\/p>
Will the current and previous months be the only options? Will there be entries from prior to last month?<\/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":106120,"type":"question","name":"PDF Attachment Downloads","excerpt":"We used to be able to click one time on the PDF symbol to open our documents, but now have to click on the three dots and then get this menu and select open in new tab. The single click still works if we are opening a Word document, just not with PDF. Is there a way to get this function back?","categoryID":321,"dateInserted":"2023-06-07T10:34:01+00:00","dateUpdated":"2023-06-07T10:38:21+00:00","dateLastComment":"2023-06-07T13:43:04+00:00","insertUserID":162132,"insertUser":{"userID":162132,"name":"Renee1_CRA","url":"https:\/\/community.smartsheet.com\/profile\/Renee1_CRA","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-07T13:46:45+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-06-07T18:22:11+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":29,"score":null,"hot":3372281225,"url":"https:\/\/community.smartsheet.com\/discussion\/106120\/pdf-attachment-downloads","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106120\/pdf-attachment-downloads","format":"Rich","lastPost":{"discussionID":106120,"commentID":379260,"name":"Re: PDF Attachment Downloads","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379260#Comment_379260","dateInserted":"2023-06-07T13:43:04+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-06-07T18:22:11+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"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\/H01NI7XP81IL\/screenshot-2023-06-07-at-11-38-08.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screenshot 2023-06-07 at 11.38.08.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-07T13:48:56+00:00","dateAnswered":"2023-06-07T13:43:04+00:00","acceptedAnswers":[{"commentID":379260,"body":"
Hi @Renee1_CRA<\/a> <\/p> If you don't want to select the option from the dropdown menu, you can use keyboard shortcuts to open the file in a new tab as well: Ctrl+Click<\/strong> (Windows) or CMD+Click <\/strong>(Mac).<\/p> Cheers,<\/p> Genevieve<\/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":106077,"type":"question","name":"Percentages not displaying correctly in Report Summary","excerpt":"Hi, In this report. I want to total up a number of percentages coming from different sheets. Sometimes the percentages add up as percentages, sometimes they display as an fraction. The source sheets are all from the same template, so should be formatted the same way, though I have noticed that certain files seem to be…","categoryID":321,"dateInserted":"2023-06-06T16:57:43+00:00","dateUpdated":null,"dateLastComment":"2023-06-07T14:55:02+00:00","insertUserID":161188,"insertUser":{"userID":161188,"name":"RRM","title":"Mr","url":"https:\/\/community.smartsheet.com\/profile\/RRM","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nrDn__-bHHo!-ilmN2fAGAI!vHUL5VGglpN","dateLastActive":"2023-06-07T14:54:08+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":161188,"lastUser":{"userID":161188,"name":"RRM","title":"Mr","url":"https:\/\/community.smartsheet.com\/profile\/RRM","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nrDn__-bHHo!-ilmN2fAGAI!vHUL5VGglpN","dateLastActive":"2023-06-07T14:54:08+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":31,"score":null,"hot":3372222765,"url":"https:\/\/community.smartsheet.com\/discussion\/106077\/percentages-not-displaying-correctly-in-report-summary","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106077\/percentages-not-displaying-correctly-in-report-summary","format":"Rich","tagIDs":[265],"lastPost":{"discussionID":106077,"commentID":379287,"name":"Re: Percentages not displaying correctly in Report Summary","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379287#Comment_379287","dateInserted":"2023-06-07T14:55:02+00:00","insertUserID":161188,"insertUser":{"userID":161188,"name":"RRM","title":"Mr","url":"https:\/\/community.smartsheet.com\/profile\/RRM","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nrDn__-bHHo!-ilmN2fAGAI!vHUL5VGglpN","dateLastActive":"2023-06-07T14:54:08+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\/9KBOWFBASG02\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-07T14:54:05+00:00","dateAnswered":"2023-06-07T11:56:42+00:00","acceptedAnswers":[{"commentID":379219,"body":" Hi @RRM<\/a> and @Kleerfyre<\/a> <\/p> The Support team received other reports of this same behaviour yesterday and were able to identify the cause; this should now be resolved! Please refresh your Report and you should see your percentages appear in the Summary rows again.<\/p> Cheers,<\/p> Genevieve<\/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":265,"urlcode":"Reports","name":"Reports"}]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">