Start dates and status formula

Michael 6585

Hello Community,

I am attempting to write a formula that automates my task status based on the date and current state (Started, Not Started, Complete".The columns are 3=State, 4=Status, 5=Start Date, 6=End Date. I want the status to change to Yellow is the task has reached (or passed) the Start Date and the Status is "Not Started", and "Red" if the End Date as exceeded the planned end date and the status is "Not Started" or "In Progress".

kowal

hi @Michael 6585,

=if(AND([start date]@row < = today(), status@row="Not Started"), "Yellow", if(AND([end date]@row>[baseline end date]@row, status@row<>"Complete"), "Red", "Green"))

This shall work for you according to the logic you asked.