Calendar view in Dashboard

alisoncholak
alisoncholak ✭
inSmartsheet Basics

We have a sheet that acts as our project calendar and use start/end date columns to show them in calendar view across multiple days (to show duration). How can I get this same view of this sheet (or the report from sheet) in a dashboard. The report widget only appears to generate a gant view.

Tags:
· Share on Facebook Share on Twitter

Best Answer

Answers

Categories

Hello @kathyb<\/a>! The card view \"View by ___\" are the columns that are dropdown lists \/ single select options. If that dropdown list column type changed to \"allow multiple values per cell\" it's no longer a valid column type to organize the card view. Was the Resource Coach switched to a multi-select column type?<\/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":108321,"type":"question","name":"Generate Documents and Contact cells","excerpt":"Hi I have a fillable PDF and have mapped my fields. I have 4 columns that are Contact List properties. When I map those fields and test to make sure it is coming out correctly, it is showing the email address and not the contact name. What am I missing or doing wrong? Below is a screen shot","snippet":"Hi I have a fillable PDF and have mapped my fields. I have 4 columns that are Contact List properties. When I map those fields and test to make sure it is coming out correctly, it…","categoryID":321,"dateInserted":"2023-07-31T19:57:18+00:00","dateUpdated":null,"dateLastComment":"2023-08-01T12:54:02+00:00","insertUserID":127983,"insertUser":{"userID":127983,"name":"Carol-Anne Cerbone","url":"https:\/\/community.smartsheet.com\/profile\/Carol-Anne%20Cerbone","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!h1jY4Qxc4TY!prNYaQRZvvo!a6wiwaB2GsY","dateLastActive":"2023-08-01T12:56:19+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-08-01T20:06:15+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":24,"score":null,"hot":3381729680,"url":"https:\/\/community.smartsheet.com\/discussion\/108321\/generate-documents-and-contact-cells","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108321\/generate-documents-and-contact-cells","format":"Rich","tagIDs":[583],"lastPost":{"discussionID":108321,"commentID":388180,"name":"Re: Generate Documents and Contact cells","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/388180#Comment_388180","dateInserted":"2023-08-01T12:54: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-08-01T20:06:15+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/4LPR5097N8PJ\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-01T12:26:39+00:00","dateAnswered":"2023-08-01T12:18:28+00:00","acceptedAnswers":[{"commentID":388169,"body":"

You will need to create some helper text\/number columns and use a basic cell reference to pull the name over.<\/p>

=[Contact Column Name]@row <\/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":583,"urlcode":"generate-documents","name":"#generate documents"}]},{"discussionID":108308,"type":"question","name":"Can't Find Sheet to Set Up a Workflow","excerpt":"tl;dr: I've set up the same workflow before but can't for this particular sheet. I have set up many workflows and have not had an issue until today. I have a workflow for one particularly sheet so that when the work is done, the row will move to the archive sheet. For this example I will say that the Active sheet is…","snippet":"tl;dr: I've set up the same workflow before but can't for this particular sheet. I have set up many workflows and have not had an issue until today. I have a workflow for one…","categoryID":321,"dateInserted":"2023-07-31T15:49:42+00:00","dateUpdated":null,"dateLastComment":"2023-08-01T14:09:02+00:00","insertUserID":120231,"insertUser":{"userID":120231,"name":"Pamela Wagner","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Pamela%20Wagner","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-01T14:11:17+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-08-01T20:06:15+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":35,"score":null,"hot":3381722324,"url":"https:\/\/community.smartsheet.com\/discussion\/108308\/cant-find-sheet-to-set-up-a-workflow","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108308\/cant-find-sheet-to-set-up-a-workflow","format":"Rich","lastPost":{"discussionID":108308,"commentID":388194,"name":"Re: Can't Find Sheet to Set Up a Workflow","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/388194#Comment_388194","dateInserted":"2023-08-01T14:09: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-08-01T20:06:15+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-08-01T14:11:36+00:00","dateAnswered":"2023-08-01T08:23:03+00:00","acceptedAnswers":[{"commentID":388143,"body":"

Hey @Pamela Wagner<\/a> <\/p>

Based on your explanation it does sound like you're meeting the criteria Paul identified. As long as the owner of the original sheet is shared to your other sheet as an Admin, you should be able to select it in the workflow. <\/p>

It is possible that the \/ is affecting the search. What happens when you search just for the word \"Archive\"?<\/p>

Note that if you only JUST created the sheet, it can take around 5 minutes for the search to index and include it as an option. <\/p>

Cheers,<\/p>

Genevieve<\/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":4900,"limit":3},"title":"Trending in Smartsheet Basics","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending in Smartsheet Basics

  • Card View Filters

    How do I add or change column filters in card view? I had card view set up to arrange columns according to the Resource Coach for each project, but after using it this way for several months, suddenly it changed to the columns being organized by home unit (not helpful). When I tried to change the filter back, the Resource…

  • Generate Documents and Contact cells

    Hi I have a fillable PDF and have mapped my fields. I have 4 columns that are Contact List properties. When I map those fields and test to make sure it is coming out correctly, it is showing the email address and not the contact name. What am I missing or doing wrong? Below is a screen shot

  • Can't Find Sheet to Set Up a Workflow

    tl;dr: I've set up the same workflow before but can't for this particular sheet. I have set up many workflows and have not had an issue until today. I have a workflow for one particularly sheet so that when the work is done, the row will move to the archive sheet. For this example I will say that the Active sheet is…

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

 Watch video