地位符号的工具提示
是否有可能显示工具提示的地位象征?
虽然公司里经验丰富的用户知道每个符号(红色、贪婪、蓝色、黄色)的含义,但大多数用户并不确定。我们需要在某个地方定义工具提示文本的能力,因为每个公司可能对这些颜色有自己的解释。
评论
-
布雷特•埃文斯 ✭✭✭✭✭✭
不幸的是,没有“OnMouseOver”可用于工具提示。作为一种解决方案,我在横幅中放置了图像,显示我的图标所代表的内容。
-
丽莎 ✭✭
嗨,布雷特。
你指的是什么横幅?你能发个截图吗?
提前感谢!
-
布雷特•埃文斯 ✭✭✭✭✭✭
在创建了定义符号的图像之后,您可以使用工作区属性(右键单击)将其上传到工作区中的所有工作表中。它最终出现在工作区中所有工作表的右上角。
-
如果您只想为特定的工作表设置该设置怎么办?
-
彼得Vennel ✭
谢谢布雷特。这绝对是一个快速而简单的解决方案。但我希望SmartSheet可以开始支持工具提示。
-
约翰·索伯 ✭✭✭✭✭✭
这是个好主意。工具提示已经在那里,当你在符号列的属性,你选择你的符号集…
-
工具提示支持太棒了!
-
J.克雷格·威廉姆斯 ✭✭✭✭✭✭
对于复杂的表格,我创建了一个LEGEND部分来解释各种颜色编码/条件格式的含义。
我要确保包含“符号”。对于标准的“图例”,这可能是一个链接到另一个工作表或只是一个屏幕截图附件。
我喜欢布雷特的变通方法,但我通常会在报告之类的地方看到公司的标志。
托尼,我很确定这个标志是账户设置的工作空间例外。
克雷格
-
这是一个巧妙的解决方法,谢谢你的建议!
类别
Nested IF formulas read from left to right and stop on the first true value. So if you have In Progress in one child row and On Hold in another child row, it will register a true value with the In Progress argument, output that, then stop evaluating. If you want On Hold to \"override\" In Progress, you would need to adjust the order in which your IFs are nested.<\/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":106432,"type":"question","name":"Form drop down selection query","excerpt":"Hi, Is it possible to create a form based off a sheet where you can select an entry already in the primary column which would then allow you to update specific other columns? I would like to have a form where I can select an entry in T Number column, then update Cal Due, In Cal checkbox and comments columns. Is this…","categoryID":322,"dateInserted":"2023-06-14T15:50:22+00:00","dateUpdated":null,"dateLastComment":"2023-06-14T17:40:38+00:00","insertUserID":160222,"insertUser":{"userID":160222,"name":"WillH","url":"https:\/\/community.smartsheet.com\/profile\/WillH","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-14T17:27:04+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":116407,"lastUser":{"userID":116407,"name":"Darren Mullen","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Darren%20Mullen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/9WIC1TB7AJQT\/nP1GU5H4ITA1P.png","dateLastActive":"2023-06-14T19:04:57+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":54,"score":null,"hot":3373526460,"url":"https:\/\/community.smartsheet.com\/discussion\/106432\/form-drop-down-selection-query","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106432\/form-drop-down-selection-query","format":"Rich","tagIDs":[204],"lastPost":{"discussionID":106432,"commentID":380583,"name":"Re: Form drop down selection query","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380583#Comment_380583","dateInserted":"2023-06-14T17:40:38+00:00","insertUserID":116407,"insertUser":{"userID":116407,"name":"Darren Mullen","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Darren%20Mullen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/9WIC1TB7AJQT\/nP1GU5H4ITA1P.png","dateLastActive":"2023-06-14T19:04:57+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\/RUR0T5ZW0YL1\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-14T16:01:15+00:00","dateAnswered":"2023-06-14T15:59:16+00:00","acceptedAnswers":[{"commentID":380524,"body":"