PROCESS TRACKING-Process status should be Displayed base from the next blank Cell

HELLO,

It's been a week since i'm trying to solve this problem.

i am trying to track a process.

Table Details:

Row 2-Header
B2- Job Number
C2- Process 1
D2-Process 2
E2-Process 3
F2-Process 4
G2-Process 5
H2-Status

under the Status, H3, i want to create a formula that displays which process is now ongoing.
if Cell C3,D3,E3,F3 has value (date completed), then H3 (with formula) should display that the current process is now on Process 5 (since G3 is Blank)

or

if Cell C3,D3,E3 has value (date completed), then H3 (with formula) should display that the current process is now on Process 4 (since F3 is Blank)

OR

if Cell C3,D3 has value (date completed), then H3 (with formula) should display that the current process is now on Process 5 (since E3 is Blank)

ETC.....

Hi

I suggested a simpler formula in H2

Formula:

Please Login or Register  to view this content.

Based on @JeteMc file

Hi

I suggested a simpler formula in H2

Formula:

Please Login or Register  to view this content.

Based on @JeteMc file
Note: I'm not been able to use edit post to correct the formula #3.