在所有选项都有值之前设置图表颜色。
你好,
我试图显示一系列的数据状态。目前，所有状态都是“Open”(工作尚未开始)。我选择了所有的选项作为图表的数据，但是SmartSheet不允许我分配颜色，直到值大于“0”。
有没有什么方法可以预设这些颜色，这样当数值改变时，所有的图表都使用相同的颜色?
到目前为止，我能够解决这个问题的唯一方法是每当值改变时为自己设置一个警报，这样我就可以看到我是否需要进入仪表板并改变颜色，这显然是不可持续的。
评论
-
保罗新来的 ✭✭✭✭✭✭ -
莉斯南 ✭✭
啊哈，这确实有效。出于某种原因，我假设当一个值降至0时颜色会重置，但经过测试发现它是有效的。添加虚拟数字以使所有值都显示在图表中，这样您就可以更改颜色，并且即使值从图表中删除，也会记住颜色。谢谢你！
类别
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"}]},{"discussionID":106397,"type":"question","name":"Line Item Signature Requests","excerpt":"I have a database of assets, and want to send each asset owner an automated form, which I can do, with their asset listing. What I need to receive is a \"signature\" that the assets are acknowledged. by the owner, and include verbiage that the asset owner agrees to abide by. I can create the form, automate it, but I have not…","categoryID":321,"dateInserted":"2023-06-13T20:39:57+00:00","dateUpdated":null,"dateLastComment":"2023-06-14T14:00:24+00:00","insertUserID":162344,"insertUser":{"userID":162344,"name":"Pauline J","title":"Director of Operations\/IT","url":"https:\/\/community.smartsheet.com\/profile\/Pauline%20J","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-14T15:19:38+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-14T16:16:00+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":27,"score":null,"hot":3373443021,"url":"https:\/\/community.smartsheet.com\/discussion\/106397\/line-item-signature-requests","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106397\/line-item-signature-requests","format":"Rich","lastPost":{"discussionID":106397,"commentID":380488,"name":"Re: Line Item Signature Requests","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380488#Comment_380488","dateInserted":"2023-06-14T14:00:24+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-14T16:16:00+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-14T13:05:40+00:00","dateAnswered":"2023-06-13T22:18:29+00:00","acceptedAnswers":[{"commentID":380401,"body":" Hi @Pauline J<\/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>"},{"commentID":380454,"body":" @Pauline J<\/a> <\/p> Excellent!<\/p> Happy to help!<\/p> Here's an example of how it could look.<\/p> ✅Remember! <\/strong>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":[]},{"discussionID":106358,"type":"question","name":"Remove Reply in Smartsheet Button from Comment Notification","excerpt":"Hello, I use the Comments of the Sheet to communicate with other people regarding the Requests we have in the Sheet. The comment notification that is sent automatically when a user has mentioned another user in a comment is very useful. However, I would like to remove the \"Reply in Smartsheet\" button that is shown at the…","categoryID":321,"dateInserted":"2023-06-13T10:55:28+00:00","dateUpdated":"2023-06-13T10:55:37+00:00","dateLastComment":"2023-06-14T12:32:44+00:00","insertUserID":160277,"insertUser":{"userID":160277,"name":"moraki","url":"https:\/\/community.smartsheet.com\/profile\/moraki","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-14T12:32:09+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":160277,"lastUser":{"userID":160277,"name":"moraki","url":"https:\/\/community.smartsheet.com\/profile\/moraki","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-14T12:32:09+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":29,"score":null,"hot":3373400892,"url":"https:\/\/community.smartsheet.com\/discussion\/106358\/remove-reply-in-smartsheet-button-from-comment-notification","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106358\/remove-reply-in-smartsheet-button-from-comment-notification","format":"Rich","tagIDs":[219,441,510],"lastPost":{"discussionID":106358,"commentID":380452,"name":"Re: Remove Reply in Smartsheet Button from Comment Notification","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380452#Comment_380452","dateInserted":"2023-06-14T12:32:44+00:00","insertUserID":160277,"insertUser":{"userID":160277,"name":"moraki","url":"https:\/\/community.smartsheet.com\/profile\/moraki","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-14T12:32:09+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\/YS8LARGCN51D\/comment.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"comment.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-14T12:27:37+00:00","dateAnswered":"2023-06-14T12:14:50+00:00","acceptedAnswers":[{"commentID":380442,"body":" 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>![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/WLCSO8N85MRQ\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
<\/p>
