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"))))


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!