如何在日历上多选列显示

我在表摘要报告上有一个多选列。比如显示从多选列中选择的选项,以显示在日历应用程序上,并从多选列中添加过滤器。任何建议吗?

标签:

最佳答案

答案

It's not possible to include the date in the column, but here's a workaround:<\/p>
\n
\n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n

<\/p>


<\/p>


<\/p>


<\/p>


<\/p>


<\/p>


<\/p>

\n \n https:\/\/help.smartsheet.com\/articles\/2482475-latest-comment-column\n <\/a>\n<\/div>


<\/p>

Julie Fortney<\/p>

www.linkedin.com\/in\/JulieFortney-PMP-SmartsheetPartner-LSSBlackBelt<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-12-30 19:10:44","updateUser":{"userID":156373,"name":"Alegna","url":"https:\/\/community.smartsheet.com\/profile\/Alegna","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-30T19:10:34+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":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":283,"urlcode":"Enhancement Request","name":"Enhancement Request"}]},{"discussionID":99135,"type":"question","name":"Want a copy of automated email \"Send to contacts in a cell\"","excerpt":"Happy early 2023! I've created an automated workflow to send a message to \"Send to Contacts in a cell\" but I'd also like to be copied so I know when requestors are receiving it. How can I do this? Or is there a way to tell \"who\" was sent the automated email? Currently it would only tell you when the automation was last…","categoryID":321,"dateInserted":"2022-12-29T18:05:05+00:00","dateUpdated":null,"dateLastComment":"2022-12-29T19:35:26+00:00","insertUserID":145367,"insertUser":{"userID":145367,"name":"Sancta Watley","url":"https:\/\/community.smartsheet.com\/profile\/Sancta%20Watley","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!bYtrW4PMU_M!u0K05_U4mQg!GbzlM30r8OV","dateLastActive":"2022-12-29T19:32:19+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":145367,"lastUser":{"userID":145367,"name":"Sancta Watley","url":"https:\/\/community.smartsheet.com\/profile\/Sancta%20Watley","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!bYtrW4PMU_M!u0K05_U4mQg!GbzlM30r8OV","dateLastActive":"2022-12-29T19:32:19+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":42,"score":null,"hot":3344682631,"url":"https:\/\/community.smartsheet.com\/discussion\/99135\/want-a-copy-of-automated-email-send-to-contacts-in-a-cell","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/99135\/want-a-copy-of-automated-email-send-to-contacts-in-a-cell","format":"Rich","tagIDs":[448],"lastPost":{"discussionID":99135,"commentID":355541,"name":"Re: Want a copy of automated email \"Send to contacts in a cell\"","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/355541#Comment_355541","dateInserted":"2022-12-29T19:35:26+00:00","insertUserID":145367,"insertUser":{"userID":145367,"name":"Sancta Watley","url":"https:\/\/community.smartsheet.com\/profile\/Sancta%20Watley","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!bYtrW4PMU_M!u0K05_U4mQg!GbzlM30r8OV","dateLastActive":"2022-12-29T19:32:19+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-12-29T18:26:11+00:00","dateAnswered":"2022-12-29T18:19:01+00:00","acceptedAnswers":[{"commentID":355518,"body":"

@Sancta Watley<\/a> <\/p>

Set up your trigger in the Automation and then set up 2 actions like this:<\/p>

\n
\n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n

For the bottom one, you'll select yourself as the specific person. You can edit the message to include the Contact column so when you receive the message you'll even know who the first alert went to.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-12-29 18:26:11","updateUser":{"userID":145367,"name":"Sancta Watley","url":"https:\/\/community.smartsheet.com\/profile\/Sancta%20Watley","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!bYtrW4PMU_M!u0K05_U4mQg!GbzlM30r8OV","dateLastActive":"2022-12-29T19:32:19+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":448,"urlcode":"workflows-in-smartsheet","name":"Workflows in Smartsheet"}]},{"discussionID":99065,"type":"question","name":"Uploading data with Data Shuttle, with spaces between numbers.","excerpt":"When I upload a numerical string, which has a space before the last 2 digits, the space is removed. How do I upload the numerical string and maintain the space before the last 2 digits? Example, I need the string to import as \"123 45\", but after the import it appears as \"12345\".","categoryID":343,"dateInserted":"2022-12-27T01:20:40+00:00","dateUpdated":null,"dateLastComment":"2022-12-29T15:37:21+00:00","insertUserID":140766,"insertUser":{"userID":140766,"name":"Mitch Cohen","url":"https:\/\/community.smartsheet.com\/profile\/Mitch%20Cohen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-01-01T16:39:07+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":140766,"lastUser":{"userID":140766,"name":"Mitch Cohen","url":"https:\/\/community.smartsheet.com\/profile\/Mitch%20Cohen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-01-01T16:39:07+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":41,"score":null,"hot":3344434081,"url":"https:\/\/community.smartsheet.com\/discussion\/99065\/uploading-data-with-data-shuttle-with-spaces-between-numbers","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/99065\/uploading-data-with-data-shuttle-with-spaces-between-numbers","format":"Rich","lastPost":{"discussionID":99065,"commentID":355488,"name":"Re: Uploading data with Data Shuttle, with spaces between numbers.","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/355488#Comment_355488","dateInserted":"2022-12-29T15:37:21+00:00","insertUserID":140766,"insertUser":{"userID":140766,"name":"Mitch Cohen","url":"https:\/\/community.smartsheet.com\/profile\/Mitch%20Cohen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-01-01T16:39:07+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":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-12-29T15:35:45+00:00","dateAnswered":"2022-12-28T23:53:24+00:00","acceptedAnswers":[{"commentID":355471,"body":"

In your data shuttle workflow mapping, click the three bars and change the column type to Text<\/p>