为带有附件的行设置条件格式
由于附件(回形针)列在表格的最左边，不能重新定位，所以当附件已经添加到一行时，并不总是很清楚(因为我通常不会滚动到最左边来检查，特别是在有多个列的表格中)。
是否有一种简单的方法可以使用条件格式来识别现有附件的行并对其进行颜色编码?
评论
-
tforslun ✭这也将是伟大的有一个指示，有一个行附件时，一个工作表被导出。导出了一个单独的comments选项卡，只需在该选项卡的另一列中添加附件的名称就足够了。
类别
2023-05-21T01:48:42.000+00:00","expand":["all","-body"],"excludeHiddenCategories":true,"type":"Idea"},"discussions":[{"discussionID":106520,"type":"idea","name":"Automations: Sending Attachments individually, selectably","excerpt":"Currently, automations containing attachments can be sent listing multiple attachments to a given row. It would be very useful to filter or select individual attachments (based on a conditional factor such as if the title of the attachment contained a certain string of text, numbering convention, or even file type) to…","categoryID":349,"dateInserted":"2023-06-15T19:15:56+00:00","dateUpdated":null,"dateLastComment":"2023-06-18T13:12:31+00:00","insertUserID":138637,"insertUser":{"userID":138637,"name":"StevenBlackburnMBA","title":"Director, Informatics Innovation","url":"https:\/\/community.smartsheet.com\/profile\/StevenBlackburnMBA","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/30MFCHQD4VJ8\/nA6GUCC5S5SQG.jpg","dateLastActive":"2023-06-20T20:42:59+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":138637,"lastUser":{"userID":138637,"name":"StevenBlackburnMBA","title":"Director, Informatics Innovation","url":"https:\/\/community.smartsheet.com\/profile\/StevenBlackburnMBA","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/30MFCHQD4VJ8\/nA6GUCC5S5SQG.jpg","dateLastActive":"2023-06-20T20:42:59+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":35,"score":4,"hot":3373952307,"url":"https:\/\/community.smartsheet.com\/discussion\/106520\/automations-sending-attachments-individually-selectably","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106520\/automations-sending-attachments-individually-selectably","format":"Rich","tagIDs":[363],"lastPost":{"discussionID":106520,"commentID":381101,"name":"Re: Automations: Sending Attachments individually, selectably","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381101#Comment_381101","dateInserted":"2023-06-18T13:12:31+00:00","insertUserID":138637,"insertUser":{"userID":138637,"name":"StevenBlackburnMBA","title":"Director, Informatics Innovation","url":"https:\/\/community.smartsheet.com\/profile\/StevenBlackburnMBA","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/30MFCHQD4VJ8\/nA6GUCC5S5SQG.jpg","dateLastActive":"2023-06-20T20:42:59+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":4}],"tags":[{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}]},{"discussionID":106553,"type":"idea","name":"Critical chain method","excerpt":"Good morning, Currently Smartsheet only uses the critical path method, are there any plans to include the option to use critical chain method as well? and to include the fever chart as part of the graphics? These are two ways of managing projects, and adding the critical chain will allow a project manager to choose what…","categoryID":349,"dateInserted":"2023-06-16T15:21:43+00:00","dateUpdated":"2023-06-16T15:24:04+00:00","dateLastComment":"2023-06-16T15:21:43+00:00","insertUserID":158572,"insertUser":{"userID":158572,"name":"noviceuser","url":"https:\/\/community.smartsheet.com\/profile\/noviceuser","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-20T14:02:08+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":158572,"lastUser":{"userID":158572,"name":"noviceuser","url":"https:\/\/community.smartsheet.com\/profile\/noviceuser","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-20T14:02:08+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":28,"score":1,"hot":3373858247,"url":"https:\/\/community.smartsheet.com\/discussion\/106553\/critical-chain-method","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106553\/critical-chain-method","format":"Rich","tagIDs":[363],"lastPost":{"discussionID":106553,"name":"Critical chain method","url":"https:\/\/community.smartsheet.com\/discussion\/106553\/critical-chain-method","dateInserted":"2023-06-16T15:21:43+00:00","insertUserID":158572,"insertUser":{"userID":158572,"name":"noviceuser","url":"https:\/\/community.smartsheet.com\/profile\/noviceuser","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-20T14:02:08+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":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}]},{"discussionID":106451,"type":"idea","name":"Add or Sync Billing Schedules into SmartSheets Resource Management","excerpt":"Currently there isn't a way to add or sync billing schedules into SmartSheets for revenue projections. The revenue is only projected by the system using hours and bill rates. For projects that are not time & materials, this is not useful.","categoryID":349,"dateInserted":"2023-06-14T18:45:14+00:00","dateUpdated":"2023-06-14T18:45:48+00:00","dateLastComment":"2023-06-14T18:45:14+00:00","insertUserID":162377,"insertUser":{"userID":162377,"name":"MicheleL3","title":"Head of PMO","url":"https:\/\/community.smartsheet.com\/profile\/MicheleL3","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-15T13:55:48+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":162377,"lastUser":{"userID":162377,"name":"MicheleL3","title":"Head of PMO","url":"https:\/\/community.smartsheet.com\/profile\/MicheleL3","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-15T13:55:48+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":22,"score":2,"hot":3373537262,"url":"https:\/\/community.smartsheet.com\/discussion\/106451\/add-or-sync-billing-schedules-into-smartsheets-resource-management","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106451\/add-or-sync-billing-schedules-into-smartsheets-resource-management","format":"Rich","tagIDs":[363,468],"lastPost":{"discussionID":106451,"name":"Add or Sync Billing Schedules into SmartSheets Resource Management","url":"https:\/\/community.smartsheet.com\/discussion\/106451\/add-or-sync-billing-schedules-into-smartsheets-resource-management","dateInserted":"2023-06-14T18:45:14+00:00","insertUserID":162377,"insertUser":{"userID":162377,"name":"MicheleL3","title":"Head of PMO","url":"https:\/\/community.smartsheet.com\/profile\/MicheleL3","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-15T13:55:48+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":363,"urlcode":"Idea Submitted","name":"Idea Submitted"},{"tagID":468,"urlcode":"resource-management","name":"Resource Management"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&dateInserted=%3E2023-05-21T01%3A48%3A42%2B00%3A00&type%5B0%5D=Idea&excludeHiddenCategories=1&siteSectionID=0&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser","prevURL":null,"currentPage":1,"total":138,"limit":3},"title":"Trending Ideas","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
