Formula to automatically update cell entry based on whether other cells are empty or not

Hi All,

I work on a lot of projects and at the moment I'm updating the status on each project by hand depending on which stages are completed or not. In an ideal world I'd love for this to automatically update itself.

I've tried looking at nested IF formulas with and/or but I'm not getting very far with it.

The attached example workbook lists three projects and their status based on whether there is an entry under each stage. If anyone can help me - even just to point me in the right direction for how to put something like this together I'd really appreciate it.