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-08-26T17:58:01+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":20,"countViews":1827,"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-08-25T15:22:52+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-09-18T23:19:19+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":56,"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":6704,"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-09-01T19:53:47+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-09-01T19:53:47+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":51,"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-09-21T21:11:35+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":71,"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">