日历应用程序-编辑任务

你好,

我试图更新日历应用程序中的任务,以反映在源表/报告中,但我得到一个弹出框,提示“无法更新事件”。我的日历是基于我从多张表格中创建的报告,作为所有者。我也是一个管理员的工作空间,其中所有的源表都被安置。

附加的照片


请指教-谢谢!

答案

  • 吉纳维芙P。
    吉纳维芙P。 员工管理

    @Angelique H。

    当前有一个错误,如果RYG符号列在源表中有列公式,则无法通过日历应用程序更新任务,而且该字段被设置为Calendar配置中的Symbol字段。

    我没有一个ETA,当这可能是固定的,但在此期间,您可以更改RYG符号列下配置4日Tab代替Symbol字段。这意味着在日历视图中,您将看到单词“绿色”而不是符号,但在面板中,它仍然会显示符号。

    让我知道这是否对你有用!

    欢呼,

    吉纳维芙

  • 这很有道理。我会试试的。但是,我试图更新“DM”名称,这是在数据分组和更新没有采取。这不是一个列公式,而只是一个下拉单选择列。你是说因为RYG公式附加到行,它也不会更新吗?


    谢谢

    安吉丽

  • 吉纳维芙P。
    吉纳维芙P。 员工管理

    @Angelique H。

    是的,完全正确-如果在列集中有一个列公式作为Symbol字段,您将无法编辑任何其他字段,即使它们没有被锁定或本身没有列公式。这是我们团队正在研究的意外行为。

    欢呼,

    吉纳维芙

If you select the cell you want to enter the coordinates in, you should be able to select the small arrow at the bottom and then scroll down to find the location pin icon.<\/p>


<\/p>

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


<\/p>

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

<\/p>


<\/p>

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


<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-11-18 21:49:03","updateUser":{"userID":131092,"name":"Julie Nelson","url":"https:\/\/community.smartsheet.com\/profile\/Julie%20Nelson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-18T22:06:04+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":97929,"type":"question","name":"Copy Row by Automation","excerpt":"I'm copying rows that meet specific criteria from multiple project sheets into a single different sheet using an automation. When looking at the destination sheet, is there an easy way to determine what source sheet each row came from? Similar question for reports - If a report is collecting data from multiple different…","categoryID":321,"dateInserted":"2022-11-18T14:02:25+00:00","dateUpdated":null,"dateLastComment":"2022-11-18T15:18:34+00:00","insertUserID":154725,"insertUser":{"userID":154725,"name":"Chadd","url":"https:\/\/community.smartsheet.com\/profile\/Chadd","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-18T18:09:29+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":126598,"lastUser":{"userID":126598,"name":"Paul McGuinness","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20McGuinness","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-18T16:32:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":20,"score":null,"hot":3337565459,"url":"https:\/\/community.smartsheet.com\/discussion\/97929\/copy-row-by-automation","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/97929\/copy-row-by-automation","format":"Rich","tagIDs":[265,333,334],"lastPost":{"discussionID":97929,"commentID":351683,"name":"Re: Copy Row by Automation","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/351683#Comment_351683","dateInserted":"2022-11-18T15:18:34+00:00","insertUserID":126598,"insertUser":{"userID":126598,"name":"Paul McGuinness","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20McGuinness","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-18T16:32:43+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-11-18T17:48:58+00:00","dateAnswered":"2022-11-18T15:18:34+00:00","acceptedAnswers":[{"commentID":351683,"body":"

HI @Chadd<\/a> <\/p>

Simplest way to do this is to have a hidden column in each sheet with a column formula to add a sheet name into the cell when other data is added to the row.<\/p>

i.e. =\"Sheet 1\" (or whatever works for you), make sure it is a column formula.<\/p>

You can use that to identify where the row of data came from and to sort or filter the data in reports.<\/p>

Hope that helps<\/p>

Thanks<\/p>

Paul<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-11-18 17:48:58","updateUser":{"userID":154725,"name":"Chadd","url":"https:\/\/community.smartsheet.com\/profile\/Chadd","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-18T18:09:29+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":265,"urlcode":"Reports","name":"Reports"},{"tagID":333,"urlcode":"Workflows in Smartsheet","name":"Workflows in Smartsheet"},{"tagID":334,"urlcode":"automations","name":"Automations"}]},{"discussionID":97927,"type":"question","name":"Using Formulae within Smartsheet Reports","excerpt":"Hi all, I am working on a project to aggregate data on a pan-European level with different Smartsheet files, a file per country. I bring all these different country Smartsheet files together using the Smartsheet report functionality. Some of the country data is in local currency and\/or in square feet. I would like to have…","categoryID":321,"dateInserted":"2022-11-18T11:42:09+00:00","dateUpdated":null,"dateLastComment":"2022-11-18T15:28:03+00:00","insertUserID":155114,"insertUser":{"userID":155114,"name":"BramdR","url":"https:\/\/community.smartsheet.com\/profile\/BramdR","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!!2V8u_kpssPo!3Ejsvz5QgLo!hia0290amPc","dateLastActive":"2022-11-18T15:57:25+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":126598,"lastUser":{"userID":126598,"name":"Paul McGuinness","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20McGuinness","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-18T16:32:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":26,"score":null,"hot":3337557612,"url":"https:\/\/community.smartsheet.com\/discussion\/97927\/using-formulae-within-smartsheet-reports","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/97927\/using-formulae-within-smartsheet-reports","format":"Rich","tagIDs":[254,265],"lastPost":{"discussionID":97927,"commentID":351688,"name":"Re: Using Formulae within Smartsheet Reports","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/351688#Comment_351688","dateInserted":"2022-11-18T15:28:03+00:00","insertUserID":126598,"insertUser":{"userID":126598,"name":"Paul McGuinness","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20McGuinness","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-18T16:32:43+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-11-18T15:57:28+00:00","dateAnswered":"2022-11-18T15:28:03+00:00","acceptedAnswers":[{"commentID":351688,"body":"

Hi @BramdR<\/a> <\/p>

The report will pull in the columns from each of your country sheets but cant perform an active calculation on that data.<\/p>

You will need to perform the conversions in the country sheets and then pull through those aligned EUR and sqm columns instead of the local country data.<\/p>

So its most likely you will need to add two columns to each of those country sheets to hold your formulas and the converted EUR and sqm values for each row etc.<\/p>

Hope that helps<\/p>

Thanks<\/p>

Paul<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-11-18 15:57:28","updateUser":{"userID":155114,"name":"BramdR","url":"https:\/\/community.smartsheet.com\/profile\/BramdR","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!!2V8u_kpssPo!3Ejsvz5QgLo!hia0290amPc","dateLastActive":"2022-11-18T15:57:25+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":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":265,"urlcode":"Reports","name":"Reports"}]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">