How do I change the field in Calendar View
I would like to change the field that is shown on the calendar view from the default unique identifier to the description field. I can't find anywhere in support for tips on how to do this. Just showing the unique identifier is worthless to me. Please help. Thank you.
Answers
-
Stefan ✭✭✭✭✭✭
Hi@deason,
I'm sorry, in Calendar View only the data in the primary column can be shown.
If has a fixed set of rows you could create a duplicate of your sheet, make the column you need the primary column and cell link all the cells. BUT only useful, when you don't add new rows to your first sheet.
Besides that kind of workaround, why not head over to the ideas section and post this as a feature suggestion?
Hope this helps
Stefan
Smartsheet Consulting, Solution Building, Training and Support.
Projects for Processes and for People.
-
Andrée Starå ✭✭✭✭✭✭Hi@deason
I hope you're well and safe!
To add to Stefan's excellent advice/answer.
I'd recommend creating a so-called helper column where you combine what you want to show and then reference it in the Primary Column.
Something like this.
="Component" + " - " + ColumnNameA + " - " + ColumNameB
Would that work/help?
I hope that helps!
Be safe, and have a fantastic weekend!
Best,
Andrée Starå| Workflow Consultant / CEO @WORK BOLD
✅了我的帖子(s)帮助或回答你的问题吗tion or solve your problem? Please support the Community bymarking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
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 for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
You have the option of using \"Message only\", and then displaying your two fields within the message using double curly brackets like this:<\/p>
The tradeshow named {{Association\/Tradeshow Name}} will be held on {{Tradeshow Date}}.<\/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":112164,"type":"question","name":"Automation not working (Changing date and status when a task is checked off)","excerpt":"I would like both automations to be triggered when team members check off a task in the Done Column: The task should be marked as complete in the status column when triggered The current date should be added to the Completion Date column when triggered Currently, these are set up to run in the sheet and I'm not sure why…","snippet":"I would like both automations to be triggered when team members check off a task in the Done Column: The task should be marked as complete in the status column when triggered The…","categoryID":321,"dateInserted":"2023-10-25T20:18:31+00:00","dateUpdated":"2023-10-25T22:18:48+00:00","dateLastComment":"2023-10-26T14:56:00+00:00","insertUserID":169018,"insertUser":{"userID":169018,"name":"task_by_task_33","title":"Quality Coordinator","url":"https:\/\/community.smartsheet.com\/profile\/task_by_task_33","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-26T14:56:14+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":166028,"lastUserID":169018,"lastUser":{"userID":169018,"name":"task_by_task_33","title":"Quality Coordinator","url":"https:\/\/community.smartsheet.com\/profile\/task_by_task_33","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-26T14:56:14+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":23,"score":null,"hot":3396598471,"url":"https:\/\/community.smartsheet.com\/discussion\/112164\/automation-not-working-changing-date-and-status-when-a-task-is-checked-off","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112164\/automation-not-working-changing-date-and-status-when-a-task-is-checked-off","format":"Rich","tagIDs":[334],"lastPost":{"discussionID":112164,"commentID":401830,"name":"Re: Automation not working (Changing date and status when a task is checked off)","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/401830#Comment_401830","dateInserted":"2023-10-26T14:56:00+00:00","insertUserID":169018,"insertUser":{"userID":169018,"name":"task_by_task_33","title":"Quality Coordinator","url":"https:\/\/community.smartsheet.com\/profile\/task_by_task_33","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-26T14:56:14+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\/WGNVJVW0BQCM\/troubleshooting-1.png","urlSrcSet":{"10":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=10\/https:\/\/us.v-cdn.net\/6031209\/uploads\/WGNVJVW0BQCM\/troubleshooting-1.png","300":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=300\/https:\/\/us.v-cdn.net\/6031209\/uploads\/WGNVJVW0BQCM\/troubleshooting-1.png","800":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=800\/https:\/\/us.v-cdn.net\/6031209\/uploads\/WGNVJVW0BQCM\/troubleshooting-1.png","1200":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1200\/https:\/\/us.v-cdn.net\/6031209\/uploads\/WGNVJVW0BQCM\/troubleshooting-1.png","1600":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1600\/https:\/\/us.v-cdn.net\/6031209\/uploads\/WGNVJVW0BQCM\/troubleshooting-1.png"},"alt":"Troubleshooting 1.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-10-26T14:56:12+00:00","dateAnswered":"2023-10-26T09:37:13+00:00","acceptedAnswers":[{"commentID":401773,"body":"
Hi @task_by_task_33<\/a> <\/p> I hope you're well and safe!<\/p> Strange! I don't see any issues.<\/p> I recommend trying to copy the workflows and deactivating the old ones and see if that works.<\/p> Did 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"},"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":334,"urlcode":"automations","name":"Automations"}]},{"discussionID":112179,"type":"question","name":"Mobile-friendly Email Alerts","excerpt":"Hello! I created an automation that sends an email summary of all rows added throughout the day. I included only relevant columns so it's as streamlined as possible, and it looks great on the web. However, the leaders who will be receiving this summary will primarily be viewing it on mobile. Is there any way to increase…","snippet":"Hello! I created an automation that sends an email summary of all rows added throughout the day. I included only relevant columns so it's as streamlined as possible, and it looks…","categoryID":321,"dateInserted":"2023-10-25T23:04:10+00:00","dateUpdated":null,"dateLastComment":"2023-10-26T09:13:58+00:00","insertUserID":169096,"insertUser":{"userID":169096,"name":"Alyssa Truman","url":"https:\/\/community.smartsheet.com\/profile\/Alyssa%20Truman","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-26T16:05:30+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-10-26T13:24:16+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":20,"score":null,"hot":3396587288,"url":"https:\/\/community.smartsheet.com\/discussion\/112179\/mobile-friendly-email-alerts","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112179\/mobile-friendly-email-alerts","format":"Rich","tagIDs":[510],"lastPost":{"discussionID":112179,"commentID":401769,"name":"Re: Mobile-friendly Email Alerts","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/401769#Comment_401769","dateInserted":"2023-10-26T09:13:58+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-10-26T13:24:16+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\/36I6SBP9LL1Y\/image.png","urlSrcSet":{"10":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=10\/https:\/\/us.v-cdn.net\/6031209\/uploads\/36I6SBP9LL1Y\/image.png","300":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=300\/https:\/\/us.v-cdn.net\/6031209\/uploads\/36I6SBP9LL1Y\/image.png","800":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=800\/https:\/\/us.v-cdn.net\/6031209\/uploads\/36I6SBP9LL1Y\/image.png","1200":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1200\/https:\/\/us.v-cdn.net\/6031209\/uploads\/36I6SBP9LL1Y\/image.png","1600":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1600\/https:\/\/us.v-cdn.net\/6031209\/uploads\/36I6SBP9LL1Y\/image.png"},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-10-26T16:00:23+00:00","dateAnswered":"2023-10-26T09:13:58+00:00","acceptedAnswers":[{"commentID":401769,"body":" Hi @Alyssa Truman<\/a> <\/p> I hope you're well and safe!<\/p> Unfortunately, it's not possible to change it because it adapts to the screen size, but you can click on it to see it larger, it's an excellent idea to have more options on how it's displayed.<\/p> Please submit this as a Product Feedback or Idea <\/strong>(If it hasn't been added already)<\/em><\/strong> when you have a moment.<\/strong><\/a><\/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"},"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":510,"urlcode":"email-notifications","name":"Email Notifications"}]}],"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":5200,"limit":3},"title":"Trending in Smartsheet Basics","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
