图表绘制0
最近，我联系了技术支持部门，想知道在仪表板图表中是否有一个选项可以防止图表绘制为0。我收到了以下回复:
目前我们还没有一个功能，将阻止特定的值显示在图表上。此时，我们能提供的唯一解决方案是从单元格中删除零，这将阻止我们的系统检测数据和绘制数据点，或者修改图表数据以不包括未来月份。
不幸的是，我无法删除0，因为我的数据来自计算，或者修改图表以不显示未来的月份，因为我们希望看到未来的月份与过去一年的数据进行比较。
我想投票选择关闭要在图表中绘制的值，例如0，以便我的图表看起来“更干净”。
评论
-
她名叫Stara ✭✭✭✭✭✭嗨了一只名叫阿玉,
好主意!这将是对Smartsheet功能的一个很好的补充。
希望这对你有帮助!
祝你一周愉快!
最好的
她名叫Stara
工作流程顾问/ CEO @ WORK BOLD
智能表专家顾问兼合伙人
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时与我联系，了解有关Smartsheet，集成，一般工作流建议或其他方面的帮助。
-
保罗新来的 ✭✭✭✭✭✭我经常在计算中“隐藏”零。下面是一个基本的例子。
原来的公式:
=COUNTIFS({Sheet A Range 1}， "In Progress")
显示我有多少个“In Progress”状态，但如果计数为零，我希望该单元格为空白，或者换句话说:如果计数大于零，则填充数字。
因此，我使用IF语句来完成此操作。
。
=如果(计数({表A范围1}，“正在进行中”)> 0,计数({表A范围1}，“正在进行中”)）
。
它基本上是说，如果原始公式大于零，运行原始公式。将IF的"else"部分关闭意味着它将默认为空白。
我在仪表板的报告指标中经常使用它。
thinkspi.com
-
了一只名叫阿玉瓦格纳 ✭✭✭
谢谢!我会试试的。
-
保罗新来的 ✭✭✭✭✭✭
-
保罗新来的 ✭✭✭✭✭✭
插入另一列并使用公式，如
=IF([Column With Count]@row <> ""， [Column With Label]@row)
然后你可以在你的图表中引用这一列。
thinkspi.com
-
保罗新来的 ✭✭✭✭✭✭
-
@Paul新来的如果数据是从Excel表格公式导入的呢?我们用公式导入excel数据。在excel中，我们可以隐藏零值，但当我们导入到Smartsheet时，0确实会显示出来。我们如何去除它们?我们使用导入的数据生成PDF文档，现在所有的0都显示在文档上。
-
保罗新来的 ✭✭✭✭✭✭
-
@Paul新来的嗨，保罗，谢谢你。但是，我还是不清楚我在哪里加的公式?我从excel中导入数据，这会创建一个新的工作表。从新工作表中将该行复制到现有工作表。在我复制到的这张表中，“零”应该被隐藏/去掉。我可以把公式写在整个表格上吗?
-
保罗新来的 ✭✭✭✭✭✭
-
保罗新来的 ✭✭✭✭✭✭
类别
Hi @moraki<\/a> <\/p> There currently isn't a way to remove the Reply button or the reply-to email function for @mentions in Smartsheet. (Here's the Help Article on this functionality: Using @mentions in comments<\/a>)<\/p> Please submit your feature request to the Product team by creating an Idea Post<\/strong> in the Smartsheet Product Feedback and Ideas topic<\/a> here in the Community. This will allow other users to vote on your enhancement idea!<\/p> Cheers,<\/p> Genevieve<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"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":441,"urlcode":"comments-and-conversations","name":"Comments and Conversations"},{"tagID":510,"urlcode":"email-notifications","name":"Email Notifications"}]},{"discussionID":106398,"type":"question","name":"Is there a way to send a multiple-row update request that allows multiple (as-you-go) submissions?","excerpt":"New user and new to the community. Trying to figure out if there's a way to send a multiple-row update request that allows the requestee to submit one row update at a time, save along the way, and\/or use the update request link multiple times vs. the requestee having to provide every row update before clicking submit.…","categoryID":321,"dateInserted":"2023-06-13T20:49:40+00:00","dateUpdated":null,"dateLastComment":"2023-06-14T15:59:53+00:00","insertUserID":162342,"insertUser":{"userID":162342,"name":"mgreenwalt","title":"coordinator","url":"https:\/\/community.smartsheet.com\/profile\/mgreenwalt","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-14T15:22:47+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-06-15T10:24:15+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":39,"score":null,"hot":3373449573,"url":"https:\/\/community.smartsheet.com\/discussion\/106398\/is-there-a-way-to-send-a-multiple-row-update-request-that-allows-multiple-as-you-go-submissions","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106398\/is-there-a-way-to-send-a-multiple-row-update-request-that-allows-multiple-as-you-go-submissions","format":"Rich","tagIDs":[446],"lastPost":{"discussionID":106398,"commentID":380525,"name":"Re: Is there a way to send a multiple-row update request that allows multiple (as-you-go) submissions?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380525#Comment_380525","dateInserted":"2023-06-14T15:59:53+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-06-15T10:24:15+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":"2023-06-14T15:22:45+00:00","dateAnswered":"2023-06-13T22:19:44+00:00","acceptedAnswers":[{"commentID":380402,"body":" Hi @mgreenwalt<\/a> <\/p> I hope you're well and safe!<\/p> Here's a possible workaround or workarounds <\/strong><\/p> Would any of those options 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"},"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":446,"urlcode":"update-requests","name":"Update Requests"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=341&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":5378,"limit":3},"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
