工作区中的颜色
你好,
我有一套自定义的颜色，我们的整个网站和第二套特定的工作空间。当我查看工作区中的工作表时，当前打开的工作表的所有选项卡都会变成那种颜色，即使它们不是工作区的一部分。当我查看不在工作区中的工作表时，当前打开的工作表的所有选项卡都会变为另一种颜色。
似乎改变工作区颜色的一个原因是，当你打开多个选项卡时，你可以通过选项卡的颜色快速看到哪些工作表在工作区中，哪些不在。是我做错了什么，还是这不是这个功能的工作方式?
谢谢你的帮助。如果看到截图让我的问题更清楚，我可以上传一些。
苏珊
评论
-
斯蒂芬妮·泰勒 ✭✭✭✭✭✭你没有做错任何事。所有的标签都变成了相同的颜色。但我喜欢每个选项卡保持其工作区的颜色，以帮助确定工作表在哪个工作区内。你为什么不把它作为增强版提交呢?
-
迈克Wilday ✭✭✭✭✭✭当然，将其作为改进提交。尽管我认为主题正在变化，因为主题将应用于工作区中的所有元素。当你在工作空间中活动时，呈现所有选项卡的主窗口也存在于该工作空间中，因此当你打开工作空间时打开的任何选项卡都是根据你的设置进行主题化的。
您可以通过“提交产品改进请ob欧宝娱乐app手机下载求链接在这里或任何社区页面的快速链接部分。
-
苏珊派克 ✭✭✭✭✭✭
谢谢你的快速回复。我肯定会把它作为一个改进提交。
Mike，我明白你的意思，所以我怀疑根据打开的标签/不同的工作空间来维护颜色可能有点困难。但是，在过去的几年里(我们从2011年开始使用Smartsheet)，我们已经成功地提出了最终实现的增强功能。
至少我知道我没有做错什么。只是不确定这个特性是否值得我们花时间来实现。
苏珊
-
Richard Rymill，收缩压 ✭✭✭✭✭✭苏珊，如果它有帮助，你可以有两个浏览器选项卡打开不同的智能表工作区，这应该解决颜色问题?
希望这对你有帮助?
RichardR
类别
I hope you're well and safe!<\/p>
Yes, absolutely.<\/p>
Here's the structure.<\/p>
=INDEX({ColumnWithTheValueYouWantToShow}, MATCH(CellThatHaveTheValueToMatch@row,{ColumnWithTheValueToMatchAgainsTheCell}, 0))<\/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":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":106342,"type":"question","name":"I am trying to use SUM to add the values from multiple cells in that were populated by an IF formula","excerpt":"I am trying to use SUM to add the values from multiple cells in that were populated by an IF formula. Example of 2 IF formulas: =IF([Member 2 Registration Type]@row = \"Golf & Dinner - General Public\", \"135\") and =IF([Member 2 Registration Type]@row = \"Dinner Only\", \"60\") The IF formulas are working as they should and are…","categoryID":322,"dateInserted":"2023-06-12T21:19:25+00:00","dateUpdated":null,"dateLastComment":"2023-06-13T02:23:40+00:00","insertUserID":162311,"insertUser":{"userID":162311,"name":"Jhinkle","url":"https:\/\/community.smartsheet.com\/profile\/Jhinkle","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!209A_9K4WHo!nZ9On1SJEvo!KaPQ5aRebqf","dateLastActive":"2023-06-13T02:23:49+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":162311,"lastUser":{"userID":162311,"name":"Jhinkle","url":"https:\/\/community.smartsheet.com\/profile\/Jhinkle","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!209A_9K4WHo!nZ9On1SJEvo!KaPQ5aRebqf","dateLastActive":"2023-06-13T02:23:49+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":21,"score":null,"hot":3373228985,"url":"https:\/\/community.smartsheet.com\/discussion\/106342\/i-am-trying-to-use-sum-to-add-the-values-from-multiple-cells-in-that-were-populated-by-an-if-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106342\/i-am-trying-to-use-sum-to-add-the-values-from-multiple-cells-in-that-were-populated-by-an-if-formula","format":"Rich","lastPost":{"discussionID":106342,"commentID":380235,"name":"Re: I am trying to use SUM to add the values from multiple cells in that were populated by an IF formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380235#Comment_380235","dateInserted":"2023-06-13T02:23:40+00:00","insertUserID":162311,"insertUser":{"userID":162311,"name":"Jhinkle","url":"https:\/\/community.smartsheet.com\/profile\/Jhinkle","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!209A_9K4WHo!nZ9On1SJEvo!KaPQ5aRebqf","dateLastActive":"2023-06-13T02:23:49+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":"2023-06-13T02:23:47+00:00","dateAnswered":"2023-06-13T02:23:40+00:00","acceptedAnswers":[{"commentID":380235,"body":" Thanks! That worked!<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"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":106346,"type":"question","name":"SUMIF across three rows","excerpt":"Hello everyone, I'm attempting to create a formula that will add all three rows together. I've tried: =SUMIF([Amount Written off]:[AmountWritten off], [Amount of feesWaived]:[Amount of fees Waived], [Attorney fees]:[Attorney fees]) I've also tried =SUM([Amount of fees Waived]:[Amount of fees Waived],+=SUM([Amount Written…","categoryID":322,"dateInserted":"2023-06-12T21:53:01+00:00","dateUpdated":null,"dateLastComment":"2023-06-12T22:04:57+00:00","insertUserID":162299,"insertUser":{"userID":162299,"name":"Tanishia W","title":"Legal Analyst","url":"https:\/\/community.smartsheet.com\/profile\/Tanishia%20W","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-12T22:04:40+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":162299,"lastUser":{"userID":162299,"name":"Tanishia W","title":"Legal Analyst","url":"https:\/\/community.smartsheet.com\/profile\/Tanishia%20W","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-12T22:04:40+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":22,"score":null,"hot":3373215478,"url":"https:\/\/community.smartsheet.com\/discussion\/106346\/sumif-across-three-rows","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106346\/sumif-across-three-rows","format":"Rich","lastPost":{"discussionID":106346,"commentID":380217,"name":"Re: SUMIF across three rows","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380217#Comment_380217","dateInserted":"2023-06-12T22:04:57+00:00","insertUserID":162299,"insertUser":{"userID":162299,"name":"Tanishia W","title":"Legal Analyst","url":"https:\/\/community.smartsheet.com\/profile\/Tanishia%20W","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-12T22:04:40+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\/9MT4P1FLIGIA\/screenshot-2023-06-12-154205.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screenshot 2023-06-12 154205.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-12T22:04:38+00:00","dateAnswered":"2023-06-12T22:02:22+00:00","acceptedAnswers":[{"commentID":380216,"body":" Try: =SUM([Amount of fees Waived]:[Amount of fees Waived]) + SUM([Amount Written off]:[Amount Written off]) + SUM([Attorney fees]:[Attorney fees])<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"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":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&siteSectionID=0&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":10000,"limit":3},"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
