FAQ:如何创建、编辑或删除我的帖子?

吉纳维芙P。
吉纳维芙P。 员工管理
编辑09/26/22 在欢迎加入社区

登录:

为了在Smartsheet在线社区中提问或回答问题或创建帖子，您必须首先建立一个帐户(参见:入门:创建帐户）.

创建一个职位:

您可以通过单击开始一个新的问题、讨论或想法新职位。

  • 问题:只有问题才能有最好的答案所以当你有问题需要解决或者你正在寻找解决方案时，这是最好的选择。
  • 讨论:这些帖子允许您与其他用户聊天，例如提供您自己的一个用例场景的示例，而不必得到答案。
  • 的想法:这些帖子可以由其他社区成员投票。只有当你确定一个想法还不存在的时候才去创造它。


编辑或删除你的帖子:

你可以编辑你的帖子长达4小时在你的初始发布时间后，点击你的帖子右上角的三个点。

如果时间过去了，你需要编辑或删除您的帖子，您将需要联系社区版主以方便更改。

这样做:

  • 点击Post上的flag图标
  • 选择报告
  • 写一份详细的便条，说明你希望你的职位如何改变

注意:报告一个帖子是一个私人行为，不添加任何负面的分数。

截图2015-09-26 09:42.53 .png

您还可以使用此Report功能请求删除图像，向审核团队发送通知，或更改标记为问题最佳答案的评论。

标签:

评论

  • Andrew1983
    Andrew1983 ✭

    删除一篇文章的能力并不明显，或者已经被删除了。

    我在错误的类别中发布了一些东西，但没有办法改变类别或删除帖子。

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

    嗨@Andrew1983

    版主将能够为您删除帖子或将帖子移动到正确的类别，这取决于您喜欢什么。

    请使用报告功能从旗帜图标上的帖子，你想调整和留下评论，如上所示，我们很乐意帮助。

    干杯!

    吉纳维芙

类别

@keesuri25<\/a> <\/p>

Your formula is working for me:<\/p>

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

What type of column is YTD on your sheet? It needs to be a Date type column.<\/p>"},{"commentID":346398,"body":"

It looks like you have a minor syntax issue. Whenever you reference a column name that has a space, number, and\/or special character in it, you have to wrap the column name in square brackets whereas you wrapped the entire reference in square brackets. Try this:<\/p>

=COUNTIFS([Engagement Phase]:[Engagement Phase], \"COMPLETED\", [PoC End date]<\/strong>:[<\/strong>PoC End date], YEAR(@cell) = 2022)<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-07 00:22:30","updateUser":{"userID":153291,"name":"keesuri25","url":"https:\/\/community.smartsheet.com\/profile\/keesuri25","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-07T00:19:47+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","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":96311,"type":"question","name":"INDEX \/ MATCH Formula Question","excerpt":"Hello, I am missing something with executing this formula. This is my first time trying to apply to my sheet. I can only successfully return a #Unparseable error. 😥 Would appreciate any guidance you can provide. Formula: =INDEX({CI Weight}), MATCH([Task Name]@row, {Project Name}, 0) Goal: Pull in ranking (CI Weight) from…","categoryID":322,"dateInserted":"2022-10-06T17:01:23+00:00","dateUpdated":null,"dateLastComment":"2022-10-06T23:25:11+00:00","insertUserID":134324,"insertUser":{"userID":134324,"name":"Marcela Hernandez","url":"https:\/\/community.smartsheet.com\/profile\/Marcela%20Hernandez","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-06T23:22:23+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":134324,"lastUser":{"userID":134324,"name":"Marcela Hernandez","url":"https:\/\/community.smartsheet.com\/profile\/Marcela%20Hernandez","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-06T23:22:23+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":48,"score":null,"hot":3330178594,"url":"https:\/\/community.smartsheet.com\/discussion\/96311\/index-match-formula-question","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96311\/index-match-formula-question","format":"Rich","lastPost":{"discussionID":96311,"commentID":346402,"name":"Re: INDEX \/ MATCH Formula Question","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/346402#Comment_346402","dateInserted":"2022-10-06T23:25:11+00:00","insertUserID":134324,"insertUser":{"userID":134324,"name":"Marcela Hernandez","url":"https:\/\/community.smartsheet.com\/profile\/Marcela%20Hernandez","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-06T23:22:23+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/LKAW8HFTGVXC\/index-match-question.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"INDEX MATCH question.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-10-06T20:52:07+00:00","dateAnswered":"2022-10-06T20:47:41+00:00","acceptedAnswers":[{"commentID":346374,"body":"

Remove the ) after CI WEIGHT<\/p>"},{"commentID":346375,"body":"

My hero!! Muchas gracias, @Michael Culley<\/a> ! 🤩<\/span>🤩<\/span><\/p>"},{"commentID":346400,"body":"

If you want it to only apply to parent rows then it would look more like this:<\/p>

=IF(COUNT(CHILDREN([Task Name]@row)) <> 0, <\/strong>INDEX({CI Weight}, MATCH([Task Name]@row, {Project Name}, 0)))<\/strong><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-06 20:52:07","updateUser":{"userID":134324,"name":"Marcela Hernandez","url":"https:\/\/community.smartsheet.com\/profile\/Marcela%20Hernandez","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-06T23:22:23+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","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":96312,"type":"question","name":"Can I use the Countif function to count the amount of times one column is greater than another?","excerpt":"For example, in my Smartsheet I have two columns that I would like to compare data. \"Sprinkler Head Count (Estimated)\" versus \"Sprinkler Head Count (Actual).\" I would like to count how many times in my sheet where the Actual head count is greater than the Estimated head count. Any ideas how we can achieve this? Thanks in…","categoryID":322,"dateInserted":"2022-10-06T17:10:54+00:00","dateUpdated":null,"dateLastComment":"2022-10-06T17:16:52+00:00","insertUserID":151299,"insertUser":{"userID":151299,"name":"lcain","url":"https:\/\/community.smartsheet.com\/profile\/lcain","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-06T20:25:53+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":145151,"lastUser":{"userID":145151,"name":"Mike TV","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20TV","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AItbvmniEdReOVTwaHHrhgrOiwux3krYT43KIqrvf5FW=s96-c","dateLastActive":"2022-10-07T00:06:50+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":26,"score":null,"hot":3330154666,"url":"https:\/\/community.smartsheet.com\/discussion\/96312\/can-i-use-the-countif-function-to-count-the-amount-of-times-one-column-is-greater-than-another","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96312\/can-i-use-the-countif-function-to-count-the-amount-of-times-one-column-is-greater-than-another","format":"Rich","lastPost":{"discussionID":96312,"commentID":346312,"name":"Re: Can I use the Countif function to count the amount of times one column is greater than another?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/346312#Comment_346312","dateInserted":"2022-10-06T17:16:52+00:00","insertUserID":145151,"insertUser":{"userID":145151,"name":"Mike TV","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20TV","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AItbvmniEdReOVTwaHHrhgrOiwux3krYT43KIqrvf5FW=s96-c","dateLastActive":"2022-10-07T00:06:50+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/XULU5EB0Y7VE\/estimate-v-actual.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Estimate v Actual.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-10-06T17:15:39+00:00","dateAnswered":"2022-10-06T17:14:49+00:00","acceptedAnswers":[{"commentID":346310,"body":"

create a checkbox column with this formula: <\/p>

=if(Sprinkler Head Count (Actual) >Sprinkler Head Count (Estimated),1,0)<\/p>

Then you can do a countif statement counting the checkboxes: =countif([checkbox column]:[checkbox column],1)<\/p>"},{"commentID":346312,"body":"

@lcain<\/a> <\/p>

I'm not sure if it can be done with a single formula. Here's what I would do.<\/p>

Create a helper column that's a checkbox column called something like \"Sprinkler (helper)\". Write this formula into it:<\/p>

=IF([Sprinkler Head Count (Actual)]@row>[Sprinkler Head Count (Estimated)]@row, 1)<\/p>

Then hide that column since you don't need to look at it on your sheet. Then in the column you want the count use this formula:<\/p>

=COUNTIF([Sprinkler (helper)]:[Sprinkler (helper)], 1)<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-06 17:15:39","updateUser":{"userID":151299,"name":"lcain","url":"https:\/\/community.smartsheet.com\/profile\/lcain","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-06T20:25:53+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","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 Community Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">