Help w/ Status Formula
I have the below status formula created but when I do not have a start/end date populated, the status is populating as "complete". I want it to be blank until all 4 dates are entered. Any suggestions?
Formula: =IF([Baseline Start Date]@row <> "", IF(AND([Start Date]@row <= TODAY(), [End Date]@row > TODAY()), "In Progress", IF([Start Date]@row > TODAY(), "Not Started", IF([End Date]@row < TODAY(), "Complete"))))
Help Article Resources
Check out the Formula Handbook template!