IF Function

So what i'm trying to do in this template is to create a formula in the "Status" row (box is outlined) - right below the "On Time" row at the top. The status' are indicated by the black rows with white lettering below: "Information Collection", "Design Queue", "Design Review", etc.

My team uses this template and must check off every single checkbox, so I want to be able to have Info Collection checked, but then when they get down to the Design Queue checkbox, they can check it off as complete and it'll auto-populate the "Status" data cell from Info Collection to Design Queue. Then, when they complete the next step which is design review, they'd check the box and again it'd update the Status cell from Design Queue to Design Review. 

Hey Andree, thank you so much for the help!! Reversing the order like that works perfectly!

Much appreciated!!

Sorry to bother you again, but maybe you can help me with this one too..

I want this "On Time" cell to have a formula:

If no "Completion Date" is filled in, then the On Time column says "Hold".

If the Completion Date is later than the Due Date, the On Time column says No.

If the Completion Date is before the Due Date, the On Time column says Yes.

I've tried:

IF([Completion Date]8 = 0, "Hold", IF([Completion Date]8>[Due Date]8, "No", "Yes")) - It works for the no completion date = hold, but when i fill in dates it goes #Invalid Operation. Maybe it requires an OR function? I've never dealt with those though.