Automate an "Active" field



I have a sheet wherby i have statuses, start and end dates, and also an Active field

I would like the "active" field to populate whenever a status is either

  • In Progress
  • Review
  • Sign Off

And when the date is either Today, or in the past.

I'd like the field to also clear, if none of the above is met.

I have set up the below, but this doesnt seem to work…. any ideas??


Best Answer