Create Chart Widget Using a Report (not a Sheet)

Pam Tadsen
Pam Tadsen ✭✭✭✭✭✭
edited 12/09/19 inSmartsheet Basics

With the Dashboards, I am able to create charts from a sheet but not from a report (this requires using the report widget).

I collect weekly "submission date" data from 40+ people. I have created a report that shows when the submission is due, when it is submitted, and the number of days (plus or minus) between the two. I would like to create a line graph for each individual that charts the above and below zero data; however, I can't graph the data from my report.

If I add the tracking information to my sheet, will I a) be able to still pull a report from that sheet, and b) create a line graph showing each person's time differences? OR, is there a way to use the report I have already created from my sheet, and put that into a line graph?

谢谢你！

Pam

Tags:

Answers

Categories

@Maureen Chausse<\/a> Do you have the required level of ownership of the sheets you are looking for, both source and target? And of the workspaces? <\/p>
\n \n https:\/\/help.smartsheet.com\/articles\/2479226-permissions-required-to-create-and-edit-automated-workflows\n <\/a>\n<\/div>

That is where I get hung up ... <\/p>

dm<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-09-22 16:43:32","updateUser":{"userID":150538,"name":"Preston P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Preston%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nWVKDFTEFOKBN.png","dateLastActive":"2022-09-22T17:03:32+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}}},"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":95743,"type":"question","name":"Importing an Excel Workbook","excerpt":"How can I import all the sheets in an Excel workbook at one time?","categoryID":321,"dateInserted":"2022-09-21T22:14:54+00:00","dateUpdated":null,"dateLastComment":"2022-09-21T22:42:42+00:00","insertUserID":152663,"insertUser":{"userID":152663,"name":"rtrosper","url":"https:\/\/community.smartsheet.com\/profile\/rtrosper","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!HhFqH5JDl3s!XWcoX85eCjs!dlPh9heeTbQ","dateLastActive":"2022-09-21T22:32:39+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2022-09-22T23:01:51+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":22,"score":null,"hot":3327600456,"url":"https:\/\/community.smartsheet.com\/discussion\/95743\/importing-an-excel-workbook","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95743\/importing-an-excel-workbook","format":"Rich","tagIDs":[278],"lastPost":{"discussionID":95743,"commentID":344361,"name":"Re: Importing an Excel Workbook","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/344361#Comment_344361","dateInserted":"2022-09-21T22:42:42+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2022-09-22T23:01:51+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":"2022-09-21T22:33:19+00:00","dateAnswered":"2022-09-21T22:17:09+00:00","acceptedAnswers":[{"commentID":344352,"body":"

Hi @rtrosper<\/a> <\/p>

I hope you're well and safe!<\/p>

Unfortunately, you can't. You'll have to do it one by one, either moving them around in the Workbook or splitting them into different sheets.<\/p>

Would that work\/help? <\/p>

I hope that helps!<\/p>

Be safe, and have a fantastic week!<\/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","log":{"dateUpdated":"2022-09-21 22:33:19","updateUser":{"userID":152663,"name":"rtrosper","url":"https:\/\/community.smartsheet.com\/profile\/rtrosper","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!HhFqH5JDl3s!XWcoX85eCjs!dlPh9heeTbQ","dateLastActive":"2022-09-21T22:32:39+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":278,"urlcode":"Importing and Exporting","name":"Importing and Exporting"}]},{"discussionID":95740,"type":"question","name":"Predecessors - creating conditional workflow question","excerpt":"Probably Smartsheet 101 but seeking help nonetheless. I've already selected \"Dependencies enabled\" in the sheet settings. My goal is to restrict a column checkbox (called \"Start [for a task]) from being selected unless the predecessor has been completed (a checkbox column called \"Complete\"). I'm not certain how to complete…","categoryID":321,"dateInserted":"2022-09-21T22:02:22+00:00","dateUpdated":null,"dateLastComment":"2022-09-21T22:13:24+00:00","insertUserID":152673,"insertUser":{"userID":152673,"name":"ProjectManagerIdaho","url":"https:\/\/community.smartsheet.com\/profile\/ProjectManagerIdaho","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/VHN7ISOAXAQM\/nJ9U5G4CPRHCB.JPG","dateLastActive":"2022-09-21T22:45:53+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2022-09-22T23:01:51+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":18,"score":null,"hot":3327597946,"url":"https:\/\/community.smartsheet.com\/discussion\/95740\/predecessors-creating-conditional-workflow-question","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95740\/predecessors-creating-conditional-workflow-question","format":"Rich","tagIDs":[440],"lastPost":{"discussionID":95740,"commentID":344351,"name":"Re: Predecessors - creating conditional workflow question","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/344351#Comment_344351","dateInserted":"2022-09-21T22:13:24+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2022-09-22T23:01:51+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":"2022-09-22T13:54:57+00:00","dateAnswered":"2022-09-21T22:04:32+00:00","acceptedAnswers":[{"commentID":344348,"body":"

Hi @ProjectManagerIdaho<\/a> <\/p>

I hope you're well and safe!<\/p>

You'd use Workflows combined with the lock\/unlock row Actions.<\/p>

Would that work\/help? <\/p>

I hope that helps!<\/p>

Be safe, and have a fantastic week!<\/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","log":{"dateUpdated":"2022-09-22 13:54:57","updateUser":{"userID":150538,"name":"Preston P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Preston%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nWVKDFTEFOKBN.png","dateLastActive":"2022-09-22T17:03:32+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}}},"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":440,"urlcode":"project-management","name":"Project Management"}]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">