IF statement for Status updates based on dates
So far, I have this as working formula:
=IF(AND([Start Date]@row < TODAY(), [Due Date]@row < TODAY()), "Completed", IF(AND([Start Date]@row <= TODAY(), [Due Date]@row > TODAY()), "In Progress", IF(AND([Start Date]@row >= TODAY(), [Due Date]@row > TODAY()), "Not Started")))
However, I want to add in a condition that if the start date is blank and the due date is today, the status is "In Progress". I would also like to add in another condition that if both the start date and due date are blank, then leave the status blank, because currently it is showing "Completed" if they are both blank and I do not want that.
I have tried several variations and keep getting an #UNPARSEABLE error. Does anyone know how I might add these extra conditions?
Help Article Resources
Check out the Formula Handbook template!