欢迎来到Smartsheet论坛档案


在这个论坛的帖子不再被监控的准确性和他们的内容可能不再是最新的。如果这里有你感兴趣的讨论，你想找到(或创建)一个更最新的版本，请访问当前论坛。

工作区中的颜色

苏珊派克
苏珊派克 ✭✭✭✭✭✭
编辑12/09/19 在2017年发布的文章

你好,

我有一套自定义的颜色，我们的整个网站和第二套特定的工作空间。当我查看工作区中的工作表时，当前打开的工作表的所有选项卡都会变成那种颜色，即使它们不是工作区的一部分。当我查看不在工作区中的工作表时，当前打开的工作表的所有选项卡都会变为另一种颜色。

似乎改变工作区颜色的一个原因是，当你打开多个选项卡时，你可以通过选项卡的颜色快速看到哪些工作表在工作区中，哪些不在。是我做错了什么，还是这不是这个功能的工作方式?

谢谢你的帮助。如果看到截图让我的问题更清楚，我可以上传一些。

苏珊

标签:
· 在Facebook上分享 在Twitter上分享

评论

  • 斯蒂芬妮·泰勒
    斯蒂芬妮·泰勒 ✭✭✭✭✭✭

    你没有做错任何事。所有的标签都变成了相同的颜色。但我喜欢每个选项卡保持其工作区的颜色，以帮助确定工作表在哪个工作区内。你为什么不把它作为增强版提交呢?

    · 在Facebook上分享 在Twitter上分享
  • 迈克Wilday
    迈克Wilday ✭✭✭✭✭✭

    当然，将其作为改进提交。尽管我认为主题正在变化，因为主题将应用于工作区中的所有元素。当你在工作空间中活动时，呈现所有选项卡的主窗口也存在于该工作空间中，因此当你打开工作空间时打开的任何选项卡都是根据你的设置进行主题化的。

    您可以通过“提交产品改进请ob欧宝娱乐app手机下载求链接在这里或任何社区页面的快速链接部分。

    · 在Facebook上分享 在Twitter上分享
  • 苏珊派克
    苏珊派克 ✭✭✭✭✭✭

    谢谢你的快速回复。我肯定会把它作为一个改进提交。

    Mike，我明白你的意思，所以我怀疑根据打开的标签/不同的工作空间来维护颜色可能有点困难。但是，在过去的几年里(我们从2011年开始使用Smartsheet)，我们已经成功地提出了最终实现的增强功能。

    至少我知道我没有做错什么。只是不确定这个特性是否值得我们花时间来实现。

    苏珊

    · 在Facebook上分享 在Twitter上分享
  • Richard Rymill，收缩压
    Richard Rymill，收缩压 ✭✭✭✭✭✭

    苏珊，如果它有帮助，你可以有两个浏览器选项卡打开不同的智能表工作区，这应该解决颜色问题?

    希望这对你有帮助?

    RichardR

    · 在Facebook上分享 在Twitter上分享
这次讨论已经结束了。

类别

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

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":[]}">

热门文章

  • 查找工作表B中的多个列值以匹配工作表A中的值以返回工作表B中的值

    你好，我试图使一个公式，计数从表a对表B中的多个列的值，如果只找到1个总匹配，然后查找值从表a对表B，并根据结果，从状态列拉值。如果有太多相同的结果或没有找到结果返回一个文本…

  • 我试图使用SUM来添加由IF公式填充的多个单元格中的值

    我试图使用SUM来添加由IF公式填充的多个单元格中的值。2个IF公式的例子:=IF([成员2注册类型]@row =“高尔夫和晚餐-一般公众”，“135”)和=IF([成员2注册类型]@row =“仅限晚餐”，“60”)IF公式正在工作，因为他们应该是……

  • SUMIF横跨三行

    大家好，我试图创建一个公式，将所有三行加在一起。我试过:=SUMIF([已注销的金额]:[已注销的金额]，[已免除的费用]:[已免除的费用]，[律师费]:[律师费])我也试过=SUM([已免除的费用]:[已免除的费用]，+=SUM([已写的金额…