Harvey Ball formula for between two dates

RGarrels

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!

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