Smartsheet在线社区指南

Arsineh
Arsineh 员工管理
编辑09/07/22 欢迎来到社区

欢迎来到Smartsheet社区平台!

社区是我们的社区成员、客户、合作伙伴和用户交流和分享最佳实践、提出问题、讨论工作管理的未来以及从其他用户和专家那里获得如何指导的空间。您还可以通过您的反馈直接帮助塑造智能表产品的未来。ob欧宝娱乐app手机下载

我们努力确保这个社区是一个尊重每个人的空间。您必须查看并遵循下面的社区指南。Smartsheet保留在任何时候自行决定修改这些指南的权利。您的参与将受到这些指南和智能表的约束网站上。请确保您已经阅读了适用于您使用的条款。

的指导方针

尊重他人:不接受基于种族、民族、宗教、性别、性别认同、年龄、取向或能力对他人进行暴力攻击、威胁或骚扰的评论、讨论、链接或图片。

不要垃圾邮件:禁止在在线社区直接向我们的用户发广告或电子邮件来推广您的公司、网站、产品或服务。ob欧宝娱乐app手机下载

不要巨魔:旨在制造强烈负面或情绪反应、挑起冲突或为“震惊”而创建的讨论和帖子是被禁止的。

不要再发布:联合内容(即由其他人编写或来自其他来源的内容)将被删除。

遵守法律:不得违反任何地方、州、国家或国际法律,不得发布侵犯他人知识产权、侵犯他人隐私权或公开权的内容。

是安全的:在线社区对公众是可见的——不要发布有关您自己、您的企业或其他社区成员的个人信息,因为您/他们不希望公开。永远不要向任何人提供您的智能表密码。

分享时要谨慎:永远要知道你在和谁分享你的数据。Smartsheet不负责您或其他社区成员在使用Smartsheet订阅服务时产生的数据和信息的分发、出版、显示或其他披露。

不建议为了获得产品帮助而与组织外的个人共享表格、报告或仪表板。ob欧宝娱乐app手机下载

所有帖子和评论都由Smartsheet员工,我们的版主监控,以确保答案准确,有用和适当。

版主有权删除任何讨论或帖子,并禁止违反我们的指南或网站条款的用户进入在线社区。如果你发现一个对话似乎违反了这些准则,请避免参与和标记它代替。版主将审查帖子并决定适当的行动。

如何举报违规行为

如果你看到有人滥用这些准则的证据,请按照以下方式举报:

  1. 单击国旗图标在左下角的帖子。
  2. 选择下列选项之一:
  • 报告(由Smartsheet版主对帖子进行审核并附注)
  • 垃圾邮件
  • 滥用

版主将审查标记的内容并决定适当的操作。

    这次讨论已经结束了。
    @Vane<\/a> <\/p>

    If you only want to add those if the Status is Approved, you'd use this formula:<\/p>

    =SUMIFS([Approved Change Order Amount.]:[Approved Change Order Amount.], Category:Category, CONTAINS(\"Regulatory Submissions\", @cell), Status:Status, \"Approved\")<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-21 21:33:13","updateUser":{"userID":154015,"name":"Vane","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Vane","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-21T22:08:16+00:00","banned":0,"punished":0,"private":true,"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":96887,"type":"question","name":"Help with COUNTIF","excerpt":"Currently I am counting the number of rows assigned to a particular person using a separate sheet. Currently it counts every row based on the value of the adjacent column. The current entry in the cell that displays the count is =COUNTIF({Sheet - Request Tracker Range 9}, Category26). I need to be able to count the number…","categoryID":322,"dateInserted":"2022-10-21T17:48:50+00:00","dateUpdated":null,"dateLastComment":"2022-10-21T17:59:27+00:00","insertUserID":154002,"insertUser":{"userID":154002,"name":"SmartSheet Newbie","url":"https:\/\/community.smartsheet.com\/profile\/SmartSheet%20Newbie","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/ALm5wu1VcnmvyGv6lWBPJmcBlo2-f4c9qfr0HlrcGUdo=s96-c","dateLastActive":"2022-10-21T18:00:34+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2022-10-21T17:57:45+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":12,"score":null,"hot":3332750297,"url":"https:\/\/community.smartsheet.com\/discussion\/96887\/help-with-countif","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96887\/help-with-countif","format":"Rich","lastPost":{"discussionID":96887,"commentID":348294,"name":"Re: Help with COUNTIF","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/348294#Comment_348294","dateInserted":"2022-10-21T17:59:27+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2022-10-21T17:57:45+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,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-10-21T18:04:48+00:00","dateAnswered":"2022-10-21T17:59:27+00:00","acceptedAnswers":[{"commentID":348294,"body":"

    You would switch over to a COUNTIFS to include multiple range\/criteria sets, include the new range, and then include the new criteria.<\/p>

    =COUNTIFS<\/strong>({Sheet - Request Tracker Range 9}, Category26, {New Range}, AND(@cell <> \"Closed\", @cell <> \"Cancelled\")<\/strong>)<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-21 18:04:48","updateUser":{"userID":154002,"name":"SmartSheet Newbie","url":"https:\/\/community.smartsheet.com\/profile\/SmartSheet%20Newbie","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/ALm5wu1VcnmvyGv6lWBPJmcBlo2-f4c9qfr0HlrcGUdo=s96-c","dateLastActive":"2022-10-21T18:00:34+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":96879,"type":"question","name":"Plus sign in front of a cell value","excerpt":"We just noticed a plus sign appeared in front of a value in a sheet and when you click on it, it becomes a minus. How did it get there? What does it mean and how do we remove?","categoryID":321,"dateInserted":"2022-10-21T15:29:50+00:00","dateUpdated":null,"dateLastComment":"2022-10-21T16:48:45+00:00","insertUserID":146968,"insertUser":{"userID":146968,"name":"Alta","url":"https:\/\/community.smartsheet.com\/profile\/Alta","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-21T16:49:12+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2022-10-22T09:46:25+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":11,"countViews":24,"score":null,"hot":3332743715,"url":"https:\/\/community.smartsheet.com\/discussion\/96879\/plus-sign-in-front-of-a-cell-value","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96879\/plus-sign-in-front-of-a-cell-value","format":"Rich","lastPost":{"discussionID":96879,"commentID":348265,"name":"Re: Plus sign in front of a cell value","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/348265#Comment_348265","dateInserted":"2022-10-21T16:48:45+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2022-10-22T09:46:25+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-21T16:42:13+00:00","dateAnswered":"2022-10-21T16:29:04+00:00","acceptedAnswers":[{"commentID":348258,"body":"

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

    If you don't want to click on the + sign to expand the Child Rows, I would suggest right-clicking on the column name, then selecting Expand All<\/strong>. <\/p>

    \n
    \n \n \"Screenshot<\/img><\/a>\n <\/div>\n<\/div>\n

    Then you can see all the rows indented below your current one!<\/p>