在日历应用程序中分配用户

JorisB
JorisB
编辑06/14/22 添加Ons和集成

你好,

当我尝试在日历应用程序中添加一个新事件,并尝试分配某人完成该任务时,SmartSheet会告诉我值对此列类型不支持。请改用objectValue。”

日历应用程序中似乎不支持“联系人”。

  • 有什么建议吗?

  • 谢谢你!
  • J

最佳答案

  • 吉纳维芙P。
    吉纳维芙P。 员工管理
    ✓回答

    @JorisB

    目前没有办法通过日历应用程序分配一个联系人值,如果在表中的列允许多个联系人。

    然而!如果将“联系人”列更改为“仅”-select,这将允许你的下拉值出现在日历应用程序中,你将能够分配行没有问题。

    请让产品团队知道您希望通过日历ob欧宝娱乐app手机下载应用程序支持多联系人字段通过这个表格。

    谢谢,

    吉纳维芙

答案

  • 吉纳维芙P。
    吉纳维芙P。 员工管理
    ✓回答

    @JorisB

    目前没有办法通过日历应用程序分配一个联系人值,如果在表中的列允许多个联系人。

    然而!如果将“联系人”列更改为“仅”-select,这将允许你的下拉值出现在日历应用程序中,你将能够分配行没有问题。

    请让产品团队知道您希望通过日历ob欧宝娱乐app手机下载应用程序支持多联系人字段通过这个表格。

    谢谢,

    吉纳维芙

Hi @Abe B.<\/a> <\/p>

Dynamic View was first announced at Smartsheet's Engage conference in 2018<\/strong>. Here's the youtube video <\/a>showing the announcement. <\/p>

Cheers,<\/p>

Genevieve<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-28 16:31:56","updateUser":{"userID":138467,"name":"Abe B.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Abe%20B.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nEQMY42MFGXWS.png","dateLastActive":"2022-10-28T16:30:27+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","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":97081,"type":"question","name":"Truncate currency data labels on dashboard widgets?","excerpt":"Hello everyone, I have a dashboard where monthly financial and fundraising info is displayed in line charts. The time frame displayed is a calendar year, so for the first few months of the year the chart is fine. After a few months however, the data labels - some for 7- and 8- figure amounts - start overlapping one…","categoryID":321,"dateInserted":"2022-10-27T17:51:27+00:00","dateUpdated":null,"dateLastComment":"2022-10-28T18:50:18+00:00","insertUserID":137020,"insertUser":{"userID":137020,"name":"Jeff Jensen (LFS)","url":"https:\/\/community.smartsheet.com\/profile\/Jeff%20Jensen%20%28LFS%29","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-28T18:48:06+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":137020,"lastUser":{"userID":137020,"name":"Jeff Jensen (LFS)","url":"https:\/\/community.smartsheet.com\/profile\/Jeff%20Jensen%20%28LFS%29","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-28T18:48:06+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":13,"score":null,"hot":3333877305,"url":"https:\/\/community.smartsheet.com\/discussion\/97081\/truncate-currency-data-labels-on-dashboard-widgets","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/97081\/truncate-currency-data-labels-on-dashboard-widgets","format":"Rich","tagIDs":[292],"lastPost":{"discussionID":97081,"commentID":349194,"name":"Re: Truncate currency data labels on dashboard widgets?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/349194#Comment_349194","dateInserted":"2022-10-28T18:50:18+00:00","insertUserID":137020,"insertUser":{"userID":137020,"name":"Jeff Jensen (LFS)","url":"https:\/\/community.smartsheet.com\/profile\/Jeff%20Jensen%20%28LFS%29","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-28T18:48:06+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-10-28T18:50:09+00:00","dateAnswered":"2022-10-28T16:56:38+00:00","acceptedAnswers":[{"commentID":349161,"body":"

You could adjust your metrics to divide by one million then indicate on the dashboard that all figures shown are millions.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-28 18:50:09","updateUser":{"userID":137020,"name":"Jeff Jensen (LFS)","url":"https:\/\/community.smartsheet.com\/profile\/Jeff%20Jensen%20%28LFS%29","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-28T18:48:06+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":292,"urlcode":"Dashboards","name":"Dashboards"}]},{"discussionID":97092,"type":"question","name":"Count Number of Closed Tickets","excerpt":"Hello, Could use some help with a formula that would count the number of closed tickets that contain a date in the date processed column. I am unsure how to make this formula work, any tips? Example Thank you, Kelly","categoryID":321,"dateInserted":"2022-10-27T19:20:35+00:00","dateUpdated":null,"dateLastComment":"2022-10-28T16:08:13+00:00","insertUserID":151995,"insertUser":{"userID":151995,"name":"Kelly R.","url":"https:\/\/community.smartsheet.com\/profile\/Kelly%20R.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-28T16:06:53+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":151995,"lastUser":{"userID":151995,"name":"Kelly R.","url":"https:\/\/community.smartsheet.com\/profile\/Kelly%20R.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-28T16:06:53+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":18,"score":null,"hot":3333872928,"url":"https:\/\/community.smartsheet.com\/discussion\/97092\/count-number-of-closed-tickets","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/97092\/count-number-of-closed-tickets","format":"Rich","lastPost":{"discussionID":97092,"commentID":349147,"name":"Re: Count Number of Closed Tickets","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/349147#Comment_349147","dateInserted":"2022-10-28T16:08:13+00:00","insertUserID":151995,"insertUser":{"userID":151995,"name":"Kelly R.","url":"https:\/\/community.smartsheet.com\/profile\/Kelly%20R.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-28T16:06:53+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/M2W77GLGBCEY\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-10-28T16:08:29+00:00","dateAnswered":"2022-10-27T22:10:39+00:00","acceptedAnswers":[{"commentID":349061,"body":"

Hi @Kelly R.<\/a> <\/p>

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

Try something like this.<\/p>

=COUNTIFS([Date Processed]:[Date Processed], ISDATE(@cell))<\/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","log":{"dateUpdated":"2022-10-28 16:08:29","updateUser":{"userID":151995,"name":"Kelly R.","url":"https:\/\/community.smartsheet.com\/profile\/Kelly%20R.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-28T16:06:53+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":[]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">