Conditional Formatting

> see the comparison 😏 How we can get the email notification with the parent row in the same style as the email…","categoryID":349,"dateInserted":"2023-07-18T14:11:40+00:00","dateUpdated":null,"dateLastComment":"2023-07-18T14:11:40+00:00","insertUserID":163608,"insertUser":{"userID":163608,"name":"Ferit","url":"https:\/\/community.smartsheet.com\/profile\/Ferit","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!m3tY3xBV4zw!X0vYH7iqAfw!2izW-8CmQvx","dateLastActive":"2023-07-19T13:32:13+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":163608,"lastUser":{"userID":163608,"name":"Ferit","url":"https:\/\/community.smartsheet.com\/profile\/Ferit","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!m3tY3xBV4zw!X0vYH7iqAfw!2izW-8CmQvx","dateLastActive":"2023-07-19T13:32:13+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":41,"score":1,"hot":1689689800,"url":"https:\/\/community.smartsheet.com\/discussion\/107731\/email-notification-with-parent-row-are-illegible","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107731\/email-notification-with-parent-row-are-illegible","format":"Rich","groupID":null,"statusID":10000,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/ISPMWI6C97AU\/comparison.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Comparison.jpg"},"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"},{"tagID":448,"urlcode":"workflows-in-smartsheet","name":"Workflows in Smartsheet"},{"tagID":507,"urlcode":"enhancement-request","name":"Enhancement Request"},{"tagID":510,"urlcode":"email-notifications","name":"Email Notifications"}],"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":66234,"type":"question","name":"How to add column that shows start\/finish time in minutes?","excerpt":"I see you can list a task in minute increments, e.g. 15min. We are creating a cutover plan and need to list a start & finish TIME: e.g. 9:00, 10:00, etc. Does Smartsheet have this as an \"intelligent\" column or just a text\/number one only? Would be extremely helpful, so that folks can time the work and also, if you add…","categoryID":321,"dateInserted":"2020-02-24T18:01:44+00:00","dateUpdated":null,"dateLastComment":"2023-07-18T01:38:16+00:00","insertUserID":118910,"insertUser":{"userID":118910,"name":"Daniel William Maycock","url":"https:\/\/community.smartsheet.com\/profile\/Daniel%20William%20Maycock","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-02-26T22:47:14+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":151054,"lastUser":{"userID":151054,"name":"celtics345","url":"https:\/\/community.smartsheet.com\/profile\/celtics345","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-18T01:44:17+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":20,"countViews":1786,"score":null,"hot":3272223600,"url":"https:\/\/community.smartsheet.com\/discussion\/66234\/how-to-add-column-that-shows-start-finish-time-in-minutes","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/66234\/how-to-add-column-that-shows-start-finish-time-in-minutes","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2020-02-25T17:39:21+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":319,"urlcode":"functionality","name":"functionality"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"},{"tagID":440,"urlcode":"project-management","name":"Project Management"}],"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}]},{"discussionID":107428,"type":"question","name":"Conditional Formatting Date Range","excerpt":"Hi! I am trying to conditionally format a row if the date range of Start and Finish columns contains today's date. In the example below, I would like \"Pilot Run Material Prep\" to automatically highlight and for it to adjust as we move through a project. It seems I can only conditionally format the Start column for a…","categoryID":322,"dateInserted":"2023-07-11T00:02:57+00:00","dateUpdated":null,"dateLastComment":"2023-07-11T00:52:15+00:00","insertUserID":163305,"insertUser":{"userID":163305,"name":"sarah_specialized","title":"Sr. Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/sarah_specialized","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-11T01:24:18+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":122388,"lastUser":{"userID":122388,"name":"Matt Johnson","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Matt%20Johnson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/ZX2A39HRG0VO\/nLJJDDQXUVD4H.JPG","dateLastActive":"2023-08-18T14:35:03+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":40,"score":null,"hot":3378071112,"url":"https:\/\/community.smartsheet.com\/discussion\/107428\/conditional-formatting-date-range","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107428\/conditional-formatting-date-range","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/MK25RN29K9PR\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-07-11T00:52:15+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"}],"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}]},{"discussionID":51776,"type":"discussion","name":"IF AND Statement for Color Statuses","excerpt":"I am trying to do something that I thought was fairly simple, but I keep running into an issue and receive an \"#Unparceable\" with my current formula. I am trying to build a Task Status based on Red, Yellow, Blue, and Green Circles. My challenge is getting the proper formula\/syntax for my Yellow Status. =IF([Status]1 = ???,…","categoryID":322,"dateInserted":"2019-06-28T13:40:50+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2023-07-09T12:36:17+00:00","insertUserID":94376,"insertUser":{"userID":94376,"name":"RC-MTAS","url":"https:\/\/community.smartsheet.com\/profile\/RC-MTAS","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-07-01T09:37:18+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":140637,"lastUser":{"userID":140637,"name":"Kerri S","url":"https:\/\/community.smartsheet.com\/profile\/Kerri%20S","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-23T12:14:53+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":20,"countViews":6574,"score":null,"hot":3250647427,"url":"https:\/\/community.smartsheet.com\/discussion\/51776\/if-and-statement-for-color-statuses","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/51776\/if-and-statement-for-color-statuses","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"}],"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}]},{"discussionID":107328,"type":"question","name":"Multiple columns condtional furmola\/formate","excerpt":"Hi , I have fleet of cars my drivers manually on daily basis type the KM\/Millage reading in Column (Km\/Today) I need formulla for column Alert as follows: - - - - - - - - - - - - - - - - - - -- - - - If number in col (Oil Next) is less than col ( Km\/Tiday) the alert Col is (Green) AND If number in col (Oil Next) is Higher…","categoryID":322,"dateInserted":"2023-07-07T09:43:32+00:00","dateUpdated":"2023-07-07T09:44:32+00:00","dateLastComment":"2023-07-07T22:21:44+00:00","insertUserID":17186,"insertUser":{"userID":17186,"name":"Waleed","url":"https:\/\/community.smartsheet.com\/profile\/Waleed","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2017-06\/ce\/e9\/ncee9b7c30afb1950c8ceab7d50979ef6.jpg","dateLastActive":"2023-08-04T17:44:26+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":17186,"lastUserID":17186,"lastUser":{"userID":17186,"name":"Waleed","url":"https:\/\/community.smartsheet.com\/profile\/Waleed","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2017-06\/ce\/e9\/ncee9b7c30afb1950c8ceab7d50979ef6.jpg","dateLastActive":"2023-08-04T17:44:26+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":52,"score":null,"hot":3377492716,"url":"https:\/\/community.smartsheet.com\/discussion\/107328\/multiple-columns-condtional-furmola-formate","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107328\/multiple-columns-condtional-furmola-formate","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/X1JCSDRXHTJK\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-07-07T11:14:01+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":319,"urlcode":"functionality","name":"functionality"},{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"}],"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}]},{"discussionID":107246,"type":"question","name":"Forumlas that have shading to alternate every other row which also update when rows are deleted\/adde","excerpt":"Good afternoon! I did use a pair of formulas based of digging I did on the forum, both a =ISODD and =MATCH, with an AUTOID column, but I think I'm making it harder. This sheet is based off a form which will add a row per submission. I'm wanting to alternate the shading every other row via conditional formatting, which it…","categoryID":322,"dateInserted":"2023-07-05T18:29:29+00:00","dateUpdated":null,"dateLastComment":"2023-07-06T00:18:35+00:00","insertUserID":162178,"insertUser":{"userID":162178,"name":"Jason F","url":"https:\/\/community.smartsheet.com\/profile\/Jason%20F","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-06T00:28:50+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":142964,"lastUser":{"userID":142964,"name":"Ray Lindstrom","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Ray%20Lindstrom","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/5Y0KP6UKIBTU\/nY3615V0DPRZV.jpg","dateLastActive":"2023-08-19T15:40:01+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":76,"score":null,"hot":3377187484,"url":"https:\/\/community.smartsheet.com\/discussion\/107246\/forumlas-that-have-shading-to-alternate-every-other-row-which-also-update-when-rows-are-deleted-adde","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107246\/forumlas-that-have-shading-to-alternate-every-other-row-which-also-update-when-rows-are-deleted-adde","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-07-05T19:33:28+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"}],"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}]},{"discussionID":105046,"type":"idea","name":"Ability to Change Column Type When Conditional Formatting Exists","excerpt":"I would like to be able to change column types without having to delete conditional formatting rules. Currently I have 20 columns that I want to change from Text\/Number to Dropdown List. They each have 5 Conditional Formatting rules applied to them. I can't change the column types without deleting the rules first. I can…","categoryID":349,"dateInserted":"2023-05-10T13:54:05+00:00","dateUpdated":null,"dateLastComment":"2023-07-05T16:01:17+00:00","insertUserID":142964,"insertUser":{"userID":142964,"name":"Ray Lindstrom","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Ray%20Lindstrom","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/5Y0KP6UKIBTU\/nY3615V0DPRZV.jpg","dateLastActive":"2023-08-19T15:40:01+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":163152,"lastUser":{"userID":163152,"name":"OCSC","url":"https:\/\/community.smartsheet.com\/profile\/OCSC","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!zMkos2_hxLs!u1sp9wfbmjs!H6YF2djx3WY","dateLastActive":"2023-07-05T15:58:56+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":54,"score":4,"hot":3372301522,"url":"https:\/\/community.smartsheet.com\/discussion\/105046\/ability-to-change-column-type-when-conditional-formatting-exists","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105046\/ability-to-change-column-type-when-conditional-formatting-exists","format":"Rich","groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"},{"tagID":527,"urlcode":"columns","name":"columns"}],"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":106918,"type":"question","name":"Cell formatting issue","excerpt":"Hi, I seem to be having an issue with cell formatting. I have set up formatting for cells to turn red\/green, I then added a rule to make the whole row white if the date in the date column is in the future... For some reason although the white row rule is at the top it is not applying this above the others? Thanks, Will.","categoryID":321,"dateInserted":"2023-06-26T19:47:57+00:00","dateUpdated":null,"dateLastComment":"2023-06-29T12:11:48+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-07-05T19:12:15+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-18T20:45:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":63,"score":null,"hot":3375851985,"url":"https:\/\/community.smartsheet.com\/discussion\/106918\/cell-formatting-issue","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106918\/cell-formatting-issue","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/3TTJR75PCVQT\/comparison2-png.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"comparison2.PNG"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-28T19:11:26+00:00","dateAnswered":"2023-06-26T20:26:43+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"}],"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">