New Data Not Automatically Added to Charts

Shawn R
Shawn R ✭
edited 12/09/19 inSmartsheet Basics

How do I (if possible) get my charts to automatically update with new information that's been added to the sheet?

I currently have a sheet that has a scoring system based on a 0-100 percentage. When I created the chart I selected all the columns I wanted and included all 5 line entries. It charts just the way I want it to, however when someone uses the web form to enter new data, that new data is excluded from the chart and I have to manually edit the chart and select the new data.

Is there an option for the charts to automatically include new lines of data and update? Or does this have to be done manually everytime?

Tags:
· Share on Facebook Share on Twitter

Comments

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi Shawn,

    You'll have to include the whole column(s) with the data that you want in the chart.

    I hope this helps you!

    Best,

    Andrée Starå - Workflow Consultant / Get Done

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    https://workbold.com/

    Andrée Starå| Workflow Consultant / CEO @WORK BOLD

    W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

    · Share on Facebook Share on Twitter
  • Shawn R
    Shawn R ✭
    edited 05/10/18

    I believe I am doing that. Here you can see I have the columns selected.

    However when new lines of data are entered the chart does not change. When I go to edit data, it only includes the lines that were already present when the chart was created.

    Is there a special way I need to select the columns?

    EDIT: Screenshots uploaded. Apparently I cannot add them into the post itself

    Capture.PNG

    Capture2.PNG

    · Share on Facebook Share on Twitter
  • Shawn R
    Shawn R ✭

    Not really sure why my responses on here are disappearing, perhaps its because I am trying to attach images. I'll do my best to explain whats happening.

    我有一个表,夏arizes scores of different audits. What we are looking to do is create charts that give us an idea of how we are trending on the performance of the audits, so multiple line entries are needed in order to compare past to present data.

    When I go to the sights page and click add widget, I add a chart. It then prompts me to select a sheet. So I select my summary sheet. Then it forces to to highlight a block of data to report on. I cannot just merely select columns. So I select all of the data.

    Then when I edit the charts I click the select columns option and select the two columns I want to report on. At this point, everything is the way I want. However, when new entries are submitted to the sheet the chart excludes those entries and has the highlighted data that I originally selected.

    What I am hoping to accomplish is to just select the columns I want to report on so when new data is submitted the chart can update.

    · Share on Facebook Share on Twitter
  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Shawn,

    If I'm not mistaken I think that you need to use a report to be able to select the columns. Another way to do it is to use cell linking or cross sheet formulas.

    Best,

    Andrée

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    https://workbold.com/

    Andrée Starå| Workflow Consultant / CEO @WORK BOLD

    W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

    · Share on Facebook Share on Twitter
  • Shawn R
    Shawn R ✭

    Yup, that works. Thanks for the help!

    · Share on Facebook Share on Twitter
  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Happy to help!

    Best,

    Andrée

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    https://workbold.com/

    Andrée Starå| Workflow Consultant / CEO @WORK BOLD

    W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

    · Share on Facebook Share on Twitter

Categories

Everything will remain as is. They just will no longer be able to access.<\/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":107734,"type":"question","name":"Summarizing result of a formula","excerpt":"Hello, I have a report that groups and summarizes points earned by individuals - well, it's supposed to do so, but the summary of points doesn't work. This appears to be because the points are calculated by a formula - if I just enter numbers, I can get a sum, but if the number are the result of a formula, the sum = 0.…","snippet":"Hello, I have a report that groups and summarizes points earned by individuals - well, it's supposed to do so, but the summary of points doesn't work. This appears to be because…","categoryID":321,"dateInserted":"2023-07-18T14:42:45+00:00","dateUpdated":null,"dateLastComment":"2023-07-19T14:20:18+00:00","insertUserID":149226,"insertUser":{"userID":149226,"name":"Ldonoghue","url":"https:\/\/community.smartsheet.com\/profile\/Ldonoghue","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!!28lBP6L25To!knnAvx7mcjw!0bjLA8JaVC7","dateLastActive":"2023-07-19T18:35:23+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-07-20T01:56:58+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":55,"score":null,"hot":3379472583,"url":"https:\/\/community.smartsheet.com\/discussion\/107734\/summarizing-result-of-a-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107734\/summarizing-result-of-a-formula","format":"Rich","lastPost":{"discussionID":107734,"commentID":385930,"name":"Re: Summarizing result of a formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/385930#Comment_385930","dateInserted":"2023-07-19T14:20:18+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-07-20T01:56:58+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-19T12:07:36+00:00","dateAnswered":"2023-07-18T15:44:21+00:00","acceptedAnswers":[{"commentID":385758,"body":"

It is fine using a formula as long as the formula is outputting numbers. What formula are you using?<\/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":107740,"type":"question","name":"Smartsheet ownership","excerpt":"The person who created and \"owns\" an important sheet we need is on 8 weeks maternity leave. We need to change a few things, but no one has that permission. How do we override that?","snippet":"The person who created and \"owns\" an important sheet we need is on 8 weeks maternity leave. We need to change a few things, but no one has that permission. How do we override that?","categoryID":321,"dateInserted":"2023-07-18T15:14:59+00:00","dateUpdated":null,"dateLastComment":"2023-07-18T21:01:34+00:00","insertUserID":76851,"insertUser":{"userID":76851,"name":"Kitty","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Kitty","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-01\/6c\/fb\/n6cfbd4e9f8b51ef6eac617de4934460f.jpg","dateLastActive":"2023-07-18T18:11:31+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-07-20T01:56:58+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":34,"score":null,"hot":3379409193,"url":"https:\/\/community.smartsheet.com\/discussion\/107740\/smartsheet-ownership","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107740\/smartsheet-ownership","format":"Rich","lastPost":{"discussionID":107740,"commentID":385833,"name":"Re: Smartsheet ownership","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/385833#Comment_385833","dateInserted":"2023-07-18T21:01: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-07-20T01:56:58+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-18T15:52:14+00:00","dateAnswered":"2023-07-18T15:49:34+00:00","acceptedAnswers":[{"commentID":385764,"body":"

If there is anyone shared to the sheet as Admin, they should be able to make the necessary changes or share someone else to the sheet as Admin so that the changes can be made. Otherwise you are just going to have to wait until the owner of the sheet is able to share someone to it as Admin.<\/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":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=321&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":4855,"limit":3},"title":"Trending in Smartsheet Basics","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending in Smartsheet Basics

  • What happens when a user account has been deleted?

    We do a lot of collaborating on our sheets with contractors outside our organization. What happens when that contractor leaves their employment and their company deletes their account? Does all of the data/contributions the contractor did on our sheets remain or do they disappear when their user account is deleted?

  • Summarizing result of a formula

    Hello, I have a report that groups and summarizes points earned by individuals - well, it's supposed to do so, but the summary of points doesn't work. This appears to be because the points are calculated by a formula - if I just enter numbers, I can get a sum, but if the number are the result of a formula, the sum = 0.…

  • Smartsheet ownership

    The person who created and "owns" an important sheet we need is on 8 weeks maternity leave. We need to change a few things, but no one has that permission. How do we override that?

Help shape the future of Smartsheet.
Share your ideas and feature requests.

 Watch video