列突出
是否有能力在一列而不是一行中着色，以显示例如英国银行假期或员工假期等。以一种非常快速的视觉方式显示任何可能避免的冲突。
评论
-
她名叫Stara ✭✭✭✭✭✭智能表专家顾问兼合伙人
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时与我联系，了解有关Smartsheet，集成，一般工作流建议或其他方面的帮助。
-
迈克Wilday ✭✭✭✭✭✭您可以使用条件格式只对正在搜索的列中的字段进行格式化，而不是将其应用于整行。如果该列中的字段符合您的标准，它实际上会为整个行上色。还可以通过突出显示整个列和更改背景颜色来手动为行上色。
如果有任何问题请告诉我。
-
她名叫Stara ✭✭✭✭✭✭
我看错了你的问题，你指的是栏目标题。
Mike是对的，我经常在我的解决方案中使用条件格式为整个列和行上色，以使设计更容易保持预期。
最好的
她名叫
智能表专家顾问兼合伙人
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时与我联系，了解有关Smartsheet，集成，一般工作流建议或其他方面的帮助。
-
保罗新来的 ✭✭✭✭✭✭ -
她名叫Stara ✭✭✭✭✭✭
没错，我有时用它来格式化多个月或值。
工作好了!
最好的
她名叫
智能表专家顾问兼合伙人
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时与我联系，了解有关Smartsheet，集成，一般工作流建议或其他方面的帮助。
-
J.Po ✭
ping这个线程…假设列突出显示或格式化尚未实现?有人想出解决办法了吗?
类别
You would need a helper column to indicate if the amount is greater than or less than to indicate in the conditions as the workflow doesn't allow the use of formulas.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":[{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":448,"urlcode":"workflows-in-smartsheet","name":"Workflows in Smartsheet"}]},{"discussionID":105686,"type":"question","name":"Error with smartsheet","excerpt":"Hi we have a recruitment tracker and we have received an error - I need this urgently for a meeting today - can anyone help?","categoryID":321,"dateInserted":"2023-05-25T13:53:24+00:00","dateUpdated":null,"dateLastComment":"2023-05-25T14:06:54+00:00","insertUserID":161789,"insertUser":{"userID":161789,"name":"Alison Kay","url":"https:\/\/community.smartsheet.com\/profile\/Alison%20Kay","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-25T14:13:54+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-05-26T16:21:28+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":34,"score":null,"hot":3370047618,"url":"https:\/\/community.smartsheet.com\/discussion\/105686\/error-with-smartsheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105686\/error-with-smartsheet","format":"Rich","lastPost":{"discussionID":105686,"commentID":377557,"name":"Re: Error with smartsheet","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/377557#Comment_377557","dateInserted":"2023-05-25T14:06:54+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-05-26T16:21:28+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/N0JZB9RNZYI5\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-05-25T14:14:13+00:00","dateAnswered":"2023-05-25T14:02:15+00:00","acceptedAnswers":[{"commentID":377555,"body":"
@Alison Kay<\/a> that's a Smartsheet error. Keep an eye on https:\/\/status.smartsheet.com\/<\/a><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":105606,"type":"question","name":"How can I change the spacing of tick marks on the x axis as one per day is too many?","excerpt":"The daily measurements are too many showing to read the dates. How can I fix this to have the chart adjust to the number of data points?","categoryID":321,"dateInserted":"2023-05-23T19:00:48+00:00","dateUpdated":null,"dateLastComment":"2023-05-26T20:48:09+00:00","insertUserID":161727,"insertUser":{"userID":161727,"name":"m.loeffler","title":"Consultant","url":"https:\/\/community.smartsheet.com\/profile\/m.loeffler","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-26T20:49:41+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":161727,"lastUser":{"userID":161727,"name":"m.loeffler","title":"Consultant","url":"https:\/\/community.smartsheet.com\/profile\/m.loeffler","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-26T20:49:41+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":81,"score":null,"hot":3370006137,"url":"https:\/\/community.smartsheet.com\/discussion\/105606\/how-can-i-change-the-spacing-of-tick-marks-on-the-x-axis-as-one-per-day-is-too-many","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105606\/how-can-i-change-the-spacing-of-tick-marks-on-the-x-axis-as-one-per-day-is-too-many","format":"Rich","lastPost":{"discussionID":105606,"commentID":377793,"name":"Re: How can I change the spacing of tick marks on the x axis as one per day is too many?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/377793#Comment_377793","dateInserted":"2023-05-26T20:48:09+00:00","insertUserID":161727,"insertUser":{"userID":161727,"name":"m.loeffler","title":"Consultant","url":"https:\/\/community.smartsheet.com\/profile\/m.loeffler","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-26T20:49:41+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/C6J8INDNPA2D\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-05-26T20:49:39+00:00","dateAnswered":"2023-05-24T13:43:24+00:00","acceptedAnswers":[{"commentID":377339,"body":"
