Harvey Ball formula for between two dates

I have set up a sheet with a "date min" and a "date max" column.

I have made another column that is a Harvey Ball status column.

I need a formula to drive the status balls if the date entered in a 3rd date column "date actual" is between the dates of the date min. and date max. columns.

Thank you Smartsheet gurus!

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

What would be the requirements and expected outputs?

Genevieve P.

Hi @RGarrels

I agree with Paul that it would be helpful to know what colours you want to appear based on those dates!

I assume that if the 3rd date falls between-or-on your defined date range you want this to be green, is that correct? Then anything outside of those dates is red?

Here's an example of how you could write that formula:

=IF(AND([Date Actual]@row >= [Date Min]@row, [Date Actual]@row <= [Date Max]@row), "Green", "Red")

Cheers,

Genevieve

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.