无法为图表小部件选择数据源?
很确定这是我的用户错误，但我是SmartSheet的新手，不能弄清楚。
我试图添加一个图表小部件到我的仪表板，总结了过期，正在进行等任务的数量。我试图选择一个摘要报告作为图表的来源。当我选择报表时，报表全部显示为灰色，并且我无法选择特定的范围。当我选择“选择”时，它就说不能从我的数据中制作图表。截图。
我做错了什么?
答案
-
保罗新来的 ✭✭✭✭✭✭
类别
- Currently there is no sorting inside of a group. Please vote for that functionality in this Enhancement Request:<\/li><\/ol>\n \n https:\/\/community.smartsheet.com\/discussion\/104139\/group-management-sorting-contact-list-alphabetically\n <\/a>\n<\/div>\n
- To my knowledge this is not available. As a System Admin on Enterprise Plan, I can export the User List and sort\/filter that way but it would be nice to be able to do this inside of Smartsheet. From Plan & Billing\/User Management I can filter but it does not count.<\/li><\/ol>"}]}},"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":442,"urlcode":"groups-and-group-management","name":"Groups and Group Management"}]},{"discussionID":106239,"type":"question","name":"Help! Published a Sheet with Edit by Anyone Permissions but Dynamic View is Requiring a Login","excerpt":"I spent the last month building a solution for people to sign up for mentors by creating a sheet that has information about each mentor and lots of formulas color fields where someone has already signed up with only a max number of sign up fields (aka I can't do this in forms that I know of). I created a Dynamic View with…","categoryID":343,"dateInserted":"2023-06-08T20:54:45+00:00","dateUpdated":null,"dateLastComment":"2023-06-09T14:09:40+00:00","insertUserID":160816,"insertUser":{"userID":160816,"name":"Sara H","url":"https:\/\/community.smartsheet.com\/profile\/Sara%20H","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!26_eP3rAZ3w!3LFcf_LcDHw!n_D8wzNBgmE","dateLastActive":"2023-06-09T14:12:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":160816,"lastUser":{"userID":160816,"name":"Sara H","url":"https:\/\/community.smartsheet.com\/profile\/Sara%20H","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!26_eP3rAZ3w!3LFcf_LcDHw!n_D8wzNBgmE","dateLastActive":"2023-06-09T14:12:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":20,"score":null,"hot":3372578665,"url":"https:\/\/community.smartsheet.com\/discussion\/106239\/help-published-a-sheet-with-edit-by-anyone-permissions-but-dynamic-view-is-requiring-a-login","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106239\/help-published-a-sheet-with-edit-by-anyone-permissions-but-dynamic-view-is-requiring-a-login","format":"Rich","tagIDs":[223,443],"lastPost":{"discussionID":106239,"commentID":379829,"name":"Re: Help! Published a Sheet with Edit by Anyone Permissions but Dynamic View is Requiring a Login","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379829#Comment_379829","dateInserted":"2023-06-09T14:09:40+00:00","insertUserID":160816,"insertUser":{"userID":160816,"name":"Sara H","url":"https:\/\/community.smartsheet.com\/profile\/Sara%20H","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!26_eP3rAZ3w!3LFcf_LcDHw!n_D8wzNBgmE","dateLastActive":"2023-06-09T14:12:11+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":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-09T14:07:07+00:00","dateAnswered":"2023-06-08T23:09:15+00:00","acceptedAnswers":[{"commentID":379755,"body":"\n \n https:\/\/community.smartsheet.com\/discussion\/106239\/help-published-a-sheet-with-edit-by-anyone-permissions-but-dynamic-view-is-requiring-a-login\n <\/a>\n<\/div>\n
Hi Sara!<\/p>
Dynamic View has its own settings for sharing that are separate from those on your underlying published sheet. If you haven't already shared the DV, itself (as well as the source sheet<\/em>), I think that may be the roadblock here. <\/p>
When you open the settings for your DV, you'll see \"Sharing<\/strong>\" on the far right. I chose the Shared domains option at the bottom to ensure users enterprise-wide could access a particular DV I created, even if they didn't have a Smartsheet account. Adding the appropriate domain(s) (i.e., the part of your email address after the @<\/strong>; like CompanyXYZ<\/em>.com<\/em>) for your user audience should clear up the restrictions requiring sign-in.<\/p>
If sharing at the domain level is too broad, I would suggest creating a named Group within the Smartsheet Admin Center (\"Group Management<\/em>\"). You can copy a list of email addresses and paste them into the \"Add Members\" field to \"bulk load\" a large group of users. Once your group is created, use the dropdown in the Shared groups option to select the appropriate group.<\/p>
\n\n \n![\"DV](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/FXRWBAANJGXT\/dv-settings-sharing.png\")
<\/img><\/a>\n <\/div>\n<\/div>\nI hope this helps resolve your problem! Please let me know how it goes!<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","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":223,"urlcode":"Publish","name":"Publish"},{"tagID":443,"urlcode":"dynamic-view","name":"Dynamic View"}]},{"discussionID":106213,"type":"question","name":"Calendar App vs. Published Calendar View","excerpt":"Our support team is trying to publish a calendar and allow customers to click on the time slots for and enter their information to book a training. I have the sheet and the automation working well (formulas, automation, etc.). This all seems to work in Calendar view, but the saving and all gets a little weird, and the look…","categoryID":321,"dateInserted":"2023-06-08T16:33:56+00:00","dateUpdated":null,"dateLastComment":"2023-06-09T12:10:26+00:00","insertUserID":103241,"insertUser":{"userID":103241,"name":"Autumn Beauchamp","url":"https:\/\/community.smartsheet.com\/profile\/Autumn%20Beauchamp","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T13:53:24+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":103241,"lastUser":{"userID":103241,"name":"Autumn Beauchamp","url":"https:\/\/community.smartsheet.com\/profile\/Autumn%20Beauchamp","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T13:53:24+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":25,"score":null,"hot":3372557062,"url":"https:\/\/community.smartsheet.com\/discussion\/106213\/calendar-app-vs-published-calendar-view","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106213\/calendar-app-vs-published-calendar-view","format":"Rich","lastPost":{"discussionID":106213,"commentID":379798,"name":"Re: Calendar App vs. Published Calendar View","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379798#Comment_379798","dateInserted":"2023-06-09T12:10:26+00:00","insertUserID":103241,"insertUser":{"userID":103241,"name":"Autumn Beauchamp","url":"https:\/\/community.smartsheet.com\/profile\/Autumn%20Beauchamp","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T13:53: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-09T12:10:37+00:00","dateAnswered":"2023-06-09T09:30:28+00:00","acceptedAnswers":[{"commentID":379774,"body":"
Hi @Autumn Beauchamp<\/a> <\/p>
I hope you're well and safe!<\/p>
Here's a possible workaround or workarounds <\/strong><\/p>
- You could automatically update the options left using the Premium app, Data Shuttle.<\/li>
- You could have a dashboard\/portal with the form on one side and the options left on the other side.<\/li><\/ul>
Would any of those options work\/help? <\/p>
I hope that helps!<\/p>
Be safe, and have a fantastic weekend!<\/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":[]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
- To my knowledge this is not available. As a System Admin on Enterprise Plan, I can export the User List and sort\/filter that way but it would be nice to be able to do this inside of Smartsheet. From Plan & Billing\/User Management I can filter but it does not count.<\/li><\/ol>"}]}},"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":442,"urlcode":"groups-and-group-management","name":"Groups and Group Management"}]},{"discussionID":106239,"type":"question","name":"Help! Published a Sheet with Edit by Anyone Permissions but Dynamic View is Requiring a Login","excerpt":"I spent the last month building a solution for people to sign up for mentors by creating a sheet that has information about each mentor and lots of formulas color fields where someone has already signed up with only a max number of sign up fields (aka I can't do this in forms that I know of). I created a Dynamic View with…","categoryID":343,"dateInserted":"2023-06-08T20:54:45+00:00","dateUpdated":null,"dateLastComment":"2023-06-09T14:09:40+00:00","insertUserID":160816,"insertUser":{"userID":160816,"name":"Sara H","url":"https:\/\/community.smartsheet.com\/profile\/Sara%20H","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!26_eP3rAZ3w!3LFcf_LcDHw!n_D8wzNBgmE","dateLastActive":"2023-06-09T14:12:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":160816,"lastUser":{"userID":160816,"name":"Sara H","url":"https:\/\/community.smartsheet.com\/profile\/Sara%20H","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!26_eP3rAZ3w!3LFcf_LcDHw!n_D8wzNBgmE","dateLastActive":"2023-06-09T14:12:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":20,"score":null,"hot":3372578665,"url":"https:\/\/community.smartsheet.com\/discussion\/106239\/help-published-a-sheet-with-edit-by-anyone-permissions-but-dynamic-view-is-requiring-a-login","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106239\/help-published-a-sheet-with-edit-by-anyone-permissions-but-dynamic-view-is-requiring-a-login","format":"Rich","tagIDs":[223,443],"lastPost":{"discussionID":106239,"commentID":379829,"name":"Re: Help! Published a Sheet with Edit by Anyone Permissions but Dynamic View is Requiring a Login","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379829#Comment_379829","dateInserted":"2023-06-09T14:09:40+00:00","insertUserID":160816,"insertUser":{"userID":160816,"name":"Sara H","url":"https:\/\/community.smartsheet.com\/profile\/Sara%20H","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!26_eP3rAZ3w!3LFcf_LcDHw!n_D8wzNBgmE","dateLastActive":"2023-06-09T14:12:11+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":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-09T14:07:07+00:00","dateAnswered":"2023-06-08T23:09:15+00:00","acceptedAnswers":[{"commentID":379755,"body":"
