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>
Be safe, and have a fantastic week!<\/p>
Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p>
I hope you're well and safe!<\/p>
Be safe, and have a fantastic week!<\/p>
Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p>
