Horizontal Axis

Evan Fowler
Evan Fowler ✭✭
inSmartsheet Basics

Hello,

我希望有一种方法可以rename the horizontal Axis with grids rather then having to keep making a metric longer and longer.

This is where the information is being pulled from.

image.png

But, when I create a dashboard you will see that it is not being labeled with the months. Making my metric sheet and this dashboard useless for presenting.

image.png

I look forward to any help you can provide.

· Share on Facebook Share on Twitter

Best Answer

  • Ryan Sides
    Ryan Sides ✭✭✭✭✭✭
    Answer ✓

    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.


    Here's mine displaying the cell value rather than the column value...

    image.png


    image.png


    image.png


    Ryan Sides

    Smartsheet Tips and Tricks for Beginners and Advanced onLinkedInandYouTube

    Come Say Hello!

    · Share on Facebook Share on Twitter

Answers

Categories

You would need to create two separate forms. Default values are not dynamic.<\/p>


<\/p>

That is a great idea though. Feel free to browse the Product Ideas tab (at the top of the page) to see if someone else has already submitted the idea. If they have then you can add your vote to it. If they have not, you can submit it as a new idea which will give others the ability to add their votes.<\/p>


<\/p>

Also... Don't forget to post a link to the idea here in this thread as well so others looking for the same thing can easily navigate to it and add their vote.<\/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":204,"urlcode":"Forms","name":"Forms"}]},{"discussionID":105908,"type":"question","name":"Is it possible to show all or selected sheet rows on a form?","excerpt":"I am tasked to show all active rows from a sheet in a Smartsheet form where users can select which one they want to de-activate and provide business reasons and justifications. Is this possible?","categoryID":321,"dateInserted":"2023-06-01T17:18:30+00:00","dateUpdated":"2023-06-01T17:51:02+00:00","dateLastComment":"2023-06-01T23:33:30+00:00","insertUserID":160974,"insertUser":{"userID":160974,"name":"molson","title":"Data Analyst","url":"https:\/\/community.smartsheet.com\/profile\/molson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-01T23:32:47+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":160974,"lastUser":{"userID":160974,"name":"molson","title":"Data Analyst","url":"https:\/\/community.smartsheet.com\/profile\/molson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-01T23:32:47+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":37,"score":null,"hot":3371304720,"url":"https:\/\/community.smartsheet.com\/discussion\/105908\/is-it-possible-to-show-all-or-selected-sheet-rows-on-a-form","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105908\/is-it-possible-to-show-all-or-selected-sheet-rows-on-a-form","format":"Rich","tagIDs":[204],"lastPost":{"discussionID":105908,"commentID":378463,"name":"Re: Is it possible to show all or selected sheet rows on a form?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/378463#Comment_378463","dateInserted":"2023-06-01T23:33:30+00:00","insertUserID":160974,"insertUser":{"userID":160974,"name":"molson","title":"Data Analyst","url":"https:\/\/community.smartsheet.com\/profile\/molson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-01T23:32:47+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-01T23:32:45+00:00","dateAnswered":"2023-06-01T18:08:53+00:00","acceptedAnswers":[{"commentID":378368,"body":"

There are a few ways to do this. <\/p>


<\/p>

1) You would need to set up a Data Shuttle workflow to export the column containing the Row ID as an excel doc. You would want to include a filter in the workflow to only pull rows that are active. Then you would need to set up a second Data Shuttle workflow to update the dropdown values in the column where the user can select the Row ID they want to deactivate.<\/p>


<\/p>

2) You could use a Dynamic View.<\/p>


<\/p>

3) You can use a report to show only rows that are active and drop that onto a dashboard alongside a form that allows free text for the Row ID they want to deactivate.<\/p>"},{"commentID":378406,"body":"

I personally prefer Dynamic View.<\/p>


<\/p>

You can use a Web Content widget and drop the form URL in. I would suggest setting the form to automatically refresh after submission.<\/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":204,"urlcode":"Forms","name":"Forms"}]},{"discussionID":105914,"type":"question","name":"Smartsheet Merge add on for Google Docs-are reports supported?","excerpt":"I have reports generated from a sheet where sheets attachments feature Google Docs\/Smartsheet Merge Add On. I am not seeing the attachments in the report. Is this to be expected? Thank you! Lisa","categoryID":321,"dateInserted":"2023-06-01T18:19:28+00:00","dateUpdated":null,"dateLastComment":"2023-06-01T18:36:37+00:00","insertUserID":27646,"insertUser":{"userID":27646,"name":"lisa.bolger27646","url":"https:\/\/community.smartsheet.com\/profile\/lisa.bolger27646","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AEdFTp7cpxlcU7HjY9mYSddcCpxMHEZMIdIX09gZQz19=s96-c","dateLastActive":"2023-06-01T18:32:59+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":27646,"lastUser":{"userID":27646,"name":"lisa.bolger27646","url":"https:\/\/community.smartsheet.com\/profile\/lisa.bolger27646","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AEdFTp7cpxlcU7HjY9mYSddcCpxMHEZMIdIX09gZQz19=s96-c","dateLastActive":"2023-06-01T18:32:59+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":28,"score":null,"hot":3371289365,"url":"https:\/\/community.smartsheet.com\/discussion\/105914\/smartsheet-merge-add-on-for-google-docs-are-reports-supported","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105914\/smartsheet-merge-add-on-for-google-docs-are-reports-supported","format":"Rich","tagIDs":[265],"lastPost":{"discussionID":105914,"commentID":378386,"name":"Re: Smartsheet Merge add on for Google Docs-are reports supported?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/378386#Comment_378386","dateInserted":"2023-06-01T18:36:37+00:00","insertUserID":27646,"insertUser":{"userID":27646,"name":"lisa.bolger27646","url":"https:\/\/community.smartsheet.com\/profile\/lisa.bolger27646","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AEdFTp7cpxlcU7HjY9mYSddcCpxMHEZMIdIX09gZQz19=s96-c","dateLastActive":"2023-06-01T18:32:59+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-02T09:33:15+00:00","dateAnswered":"2023-06-01T18:28:57+00:00","acceptedAnswers":[{"commentID":378384,"body":"

Are the attachments sheet attachments or row attachments?<\/p>"},{"commentID":378386,"body":"

Hi, good point! Thank you..problem solved!<\/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":[]}">

Trending in Using Smartsheet