RYG formula based on start/end date columns

Options
mmac
mmac ✭✭✭✭✭

Hello,

I'm looking to accomplish the following and am hopeful that someone will be able to help support. Thank you in advance.

I have a Live, Start Date and End Date column.

What I am proposing to accomplish:

Live = Red, if the Start Date/End Date are in the past (*Sale has expired)

Live = Green if Start Date is today's date and the End Date is in the future (Sale is active, but has not yet expired)

Hopefully they above is fairly straight forward and I was able to make sense of it. This will act as a visual to see what active sales are going on and what sales have come to an end.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!