添加插件和集成

询问有关控制中心、动态视图、数据网格、Pivot应用程序、日历应用程序、工作应用程序或资源管理的问题。讨论通过Bridge、Data Shuttle、Jira连接器和Salesforce连接器等集成将Smartsheet连接到其他系统。

讨论表

Hey Evan, when you select your data source for your chart, be sure to select just the cells, not the columns. You also may need to toggle on that Switch Rows and Columns setting. And toggle off the Use column names setting.<\/p>


<\/p>

Here's mine displaying the cell value rather than the column value...<\/p>

\n
\n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n


<\/p>

\n
\n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n


<\/p>

\n
\n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n


<\/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":105671,"type":"question","name":"Email automation with PARENT\/CHILD data from pivot table","excerpt":"I'm trying to create an output of specific rows of a pivot table to attach\/include in an automated email. See below for an example table I'd like to extract from the master pivot table. The \"Alert someone\" automation allows me to specify which cell information I want to include but does not seem to be able to allow for…","categoryID":321,"dateInserted":"2023-05-24T20:30:05+00:00","dateUpdated":null,"dateLastComment":"2023-05-30T07:26:55+00:00","insertUserID":152100,"insertUser":{"userID":152100,"name":"ShannonL","url":"https:\/\/community.smartsheet.com\/profile\/ShannonL","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BDfYwfm-KLw!x-nfsdxDXj4!WF1ZpbcVLlX","dateLastActive":"2023-05-30T11:50:52+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-05-30T11:24:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":10,"countViews":92,"score":null,"hot":3370397820,"url":"https:\/\/community.smartsheet.com\/discussion\/105671\/email-automation-with-parent-child-data-from-pivot-table","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105671\/email-automation-with-parent-child-data-from-pivot-table","format":"Rich","tagIDs":[254,334,335,448],"lastPost":{"discussionID":105671,"commentID":377870,"name":"Re: Email automation with PARENT\/CHILD data from pivot table","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/377870#Comment_377870","dateInserted":"2023-05-30T07:26:55+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-05-30T11:24:12+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\/M5GUWQGDZLN3\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-05-30T08:25:24+00:00","dateAnswered":"2023-05-26T18:49:09+00:00","acceptedAnswers":[{"commentID":377765,"body":"

@ShannonL<\/a> <\/p>

Happy to help!<\/p>

You can set that up in that option. (see below)<\/p>

\n
\n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n

Would that work?<\/p>

Remember! <\/strong>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":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":335,"urlcode":"sheet-summary","name":"Sheet Summary"},{"tagID":448,"urlcode":"workflows-in-smartsheet","name":"Workflows in Smartsheet"}]},{"discussionID":105606,"type":"question","name":"How can I change the spacing of tick marks on the x axis as one per day is too many?","excerpt":"The daily measurements are too many showing to read the dates. How can I fix this to have the chart adjust to the number of data points?","categoryID":321,"dateInserted":"2023-05-23T19:00:48+00:00","dateUpdated":null,"dateLastComment":"2023-05-29T13:41:02+00:00","insertUserID":161727,"insertUser":{"userID":161727,"name":"m.loeffler","title":"Consultant","url":"https:\/\/community.smartsheet.com\/profile\/m.loeffler","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-26T20:49:41+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"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-05-30T12:09:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":95,"score":null,"hot":3370240310,"url":"https:\/\/community.smartsheet.com\/discussion\/105606\/how-can-i-change-the-spacing-of-tick-marks-on-the-x-axis-as-one-per-day-is-too-many","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105606\/how-can-i-change-the-spacing-of-tick-marks-on-the-x-axis-as-one-per-day-is-too-many","format":"Rich","lastPost":{"discussionID":105606,"commentID":377843,"name":"Re: How can I change the spacing of tick marks on the x axis as one per day is too many?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/377843#Comment_377843","dateInserted":"2023-05-29T13:41:02+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-05-30T12:09:43+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\/C6J8INDNPA2D\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-05-26T20:49:39+00:00","dateAnswered":"2023-05-24T13:43:24+00:00","acceptedAnswers":[{"commentID":377339,"body":"

@m.loeffler<\/a> So what you would do here is make a helper column that has a date in every 4 rows, and leave the others blank. Then make that your farther left column. When you add the chart and you click the option that says use the first column as data labels, it should be spaced out more.<\/p>

If that doesn't make sense, I can send an example.<\/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":[]}">

使用Smartsheet的趋势