为带有附件的行设置条件格式
由于附件(回形针)列在表格的最左边，不能重新定位，所以当附件已经添加到一行时，并不总是很清楚(因为我通常不会滚动到最左边来检查，特别是在有多个列的表格中)。
是否有一种简单的方法可以使用条件格式来识别现有附件的行并对其进行颜色编码?
评论
-
tforslun ✭这也将是伟大的有一个指示，有一个行附件时，一个工作表被导出。导出了一个单独的comments选项卡，只需在该选项卡的另一列中添加附件的名称就足够了。
类别
2023-05-05T08:48:47.000+00:00","expand":["all","-body"],"excludeHiddenCategories":true,"type":"Idea"},"discussions":[{"discussionID":105956,"type":"idea","name":"Feature Request - Dashboard Line Chart Colour Change","excerpt":"Good Morning, Firstly, the rebrand of the dashboards is fantastic - I had raised this as a feature request late last year and am so excited to use the new background colours and widget colours. Really good - thank you and thank you for listening to user requests :) I do have a further request if I may? On a line chart, the…","categoryID":349,"dateInserted":"2023-06-02T15:04:42+00:00","dateUpdated":"2023-06-02T15:51:17+00:00","dateLastComment":"2023-06-02T16:25:28+00:00","insertUserID":155892,"insertUser":{"userID":155892,"name":"bhiggins","url":"https:\/\/community.smartsheet.com\/profile\/bhiggins","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-02T15:01:37+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":150051,"lastUser":{"userID":150051,"name":"DebRichardson","title":"Senior Administrative Assistant for the Office of Research Operations","url":"https:\/\/community.smartsheet.com\/profile\/DebRichardson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nB5UV6VYA5H58.png","dateLastActive":"2023-06-02T16:26:57+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":22,"score":2,"hot":3371442610,"url":"https:\/\/community.smartsheet.com\/discussion\/105956\/feature-request-dashboard-line-chart-colour-change","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105956\/feature-request-dashboard-line-chart-colour-change","format":"Rich","tagIDs":[292,363],"lastPost":{"discussionID":105956,"commentID":378599,"name":"Re: Feature Request - Dashboard Line Chart Colour Change","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/378599#Comment_378599","dateInserted":"2023-06-02T16:25:28+00:00","insertUserID":150051,"insertUser":{"userID":150051,"name":"DebRichardson","title":"Senior Administrative Assistant for the Office of Research Operations","url":"https:\/\/community.smartsheet.com\/profile\/DebRichardson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nB5UV6VYA5H58.png","dateLastActive":"2023-06-02T16:26:57+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Ideas & Feature Requests","url":"https:\/\/community.smartsheet.com\/categories\/ideas-%26-feature-requests"},{"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas"}],"groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"status":{"statusID":10000,"name":"Idea Submitted","state":"open","recordType":"discussion","recordSubType":"ideation"},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":2}],"tags":[{"tagID":292,"urlcode":"Dashboards","name":"Dashboards"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}]},{"discussionID":105941,"type":"idea","name":"Separate reply-to email address for auto emails","excerpt":"Hello, I'd like to vote for the feature of a separate reply-to email address when setting up auto emails. I'm the owner of a large number of sheets, and despite it not necessarily being a problem that emails appear to come from me, i'm having a huge issue with the large number of replies i receive. Despite adding text in…","categoryID":349,"dateInserted":"2023-06-02T11:25:15+00:00","dateUpdated":"2023-06-02T11:47:43+00:00","dateLastComment":"2023-06-02T11:25:15+00:00","insertUserID":158282,"insertUser":{"userID":158282,"name":"Sophie C","url":"https:\/\/community.smartsheet.com\/profile\/Sophie%20C","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-02T11:55:26+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":158282,"lastUser":{"userID":158282,"name":"Sophie C","url":"https:\/\/community.smartsheet.com\/profile\/Sophie%20C","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-02T11:55:26+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":23,"score":1,"hot":3371411878,"url":"https:\/\/community.smartsheet.com\/discussion\/105941\/separate-reply-to-email-address-for-auto-emails","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105941\/separate-reply-to-email-address-for-auto-emails","format":"Rich","tagIDs":[334,363,510],"lastPost":{"discussionID":105941,"name":"Separate reply-to email address for auto emails","url":"https:\/\/community.smartsheet.com\/discussion\/105941\/separate-reply-to-email-address-for-auto-emails","dateInserted":"2023-06-02T11:25:15+00:00","insertUserID":158282,"insertUser":{"userID":158282,"name":"Sophie C","url":"https:\/\/community.smartsheet.com\/profile\/Sophie%20C","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-02T11:55:26+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Ideas & Feature Requests","url":"https:\/\/community.smartsheet.com\/categories\/ideas-%26-feature-requests"},{"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas"}],"groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"status":{"statusID":10000,"name":"Idea Submitted","state":"open","recordType":"discussion","recordSubType":"ideation"},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":1}],"tags":[{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"},{"tagID":510,"urlcode":"email-notifications","name":"Email Notifications"}]},{"discussionID":105939,"type":"idea","name":"Admin Centre - multiple admins","excerpt":"Allow more than one user the ability to administer the admin centre. It is common for enterprise clients to have more than one administrator, therefore this creates bottlenecks in user management tasks, if that one user is busy or on annual leave.","categoryID":349,"dateInserted":"2023-06-02T10:50:44+00:00","dateUpdated":null,"dateLastComment":"2023-06-02T11:21:21+00:00","insertUserID":139581,"insertUser":{"userID":139581,"name":"darkmatter","url":"https:\/\/community.smartsheet.com\/profile\/darkmatter","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!XHPS3zzuBP4!m3DRfwiLWvQ!vLAErbBT_f5","dateLastActive":"2023-06-02T10:47:50+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-06-05T08:27:55+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":17,"score":1,"hot":3371408825,"url":"https:\/\/community.smartsheet.com\/discussion\/105939\/admin-centre-multiple-admins","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105939\/admin-centre-multiple-admins","format":"Rich","tagIDs":[363],"lastPost":{"discussionID":105939,"commentID":378498,"name":"Re: Admin Centre - multiple admins","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/378498#Comment_378498","dateInserted":"2023-06-02T11:21:21+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-06-05T08:27:55+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Ideas & Feature Requests","url":"https:\/\/community.smartsheet.com\/categories\/ideas-%26-feature-requests"},{"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas"}],"groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"status":{"statusID":10000,"name":"Idea Submitted","state":"open","recordType":"discussion","recordSubType":"ideation"},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":1}],"tags":[{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}]}],"title":"Trending Ideas","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
