附件和讨论的背景颜色

我最近提交了一个功能请求,我很好奇其他人是否也会喜欢它。
原因我正在努力提高我的同事对新功能的采用。我相信这个功能会增加附件和评论的可见度和知名度。
请求:我希望能够使用条件格式更改附件和注释列的背景颜色。
只要一个简单的1,0就可以了。
1 =至少有1个附件
0 =有0个附件
观察附件和评论的背景颜色可以通过“高亮更改”来改变,所以这个功能已经以另一种形式存在了。
条件格式用例1-一般意识
如果Attachments不为空,则将此格式(黄色)应用于Attachments列。
条件格式用例2-所需附件
如果Column1为Checked并且Attachments为空,则将此格式(红色)应用于Attachments列。
评论
-
J.克雷格·威廉姆斯 ✭✭✭✭✭✭
我可以用这个。
加我一票。
克雷格
-
克莱尔·迪纳 ✭
只要默认没有颜色,我就可以利用我的这个+1 !
-
特拉维斯 员工
很棒的建议,我会把它添加到我们的增强列表中!
-
帕特里克·加尔文 ✭
对我来说+1,如果有这个就太棒了
我工作的用户并不总是看到有附件或评论添加
类别
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":"