Color code the cells

Lahcene

Hi All,

I have a question regarding color coding the cells on Smartsheet.

How can I color code column (Actual Delivery date) to highlight the following:

Dark green : for when the Actual date is equale or less than Date committed

Light Green : for when the Actual Date is after the date committed

Red : for when Actual date is empty

Many thanks :)

Find more posts tagged with

Formulas

Conditional Formatting

Accepted answers

All comments

Paul Newcome

You are going to need a helper column that can be hidden after getting it set up. I would suggest making it a dropdown column and using the various color descriptions as the options within the column settings. In this column you would use a formula to output each of the different color descriptions then finally use conditional formatting to actually change the cell colors.

Carson Penticuff

@Paul Newcome jumped in before I got this posted, but I would use the same approach.

And here is the formula for the format helper column:

=IF(ISBLANK([Date committed]@row), "", IF(ISBLANK([Actual delivery date]@row), "Not Entered", IF([Actual delivery date]@row <= [Date committed]@row, "On Time", IF([Actual delivery date]@row > [Date committed]@row, "Late", ""))))

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.