Phase of Work Formula

Jim Schaffhausen

Hello Community-

I am looking for help with a formula to tell me what phase of work the project is in. The formula will be looking at 5 checkboxes in columns. If I complete the last checkbox in the first phase, but have not completed the last 2nd phase checkbox, I would like the column "Project Phase" to return the 2nd phase name.... Here is a screenshot for what I am trying to do. Any help would be appreciated.

Paul Newcome

So just to make sure I understand correctly...

 

If any boxes between the two blue columns are not checked, it should read "Brief & Strategy Inputs Phase". If all boxes between the two blue columns are checked and any boxes between the yellow columns are not, you want to see "Brief Finalization Phase".

 

What about when all boxes are checked?