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!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!