Hello,
I have rotating shifts that I would like to create a formula to tell me to review or be blank if the days are showing correctly.
Here is an example
So week 1 I want A shift to look at Mon, Tue, Fri, and Sat
But then week 2 I need it to look at Sun, Tue, and Wed.
My actual formula is this
IF(OR(D12=$T$2,D12=$T$3),IF(OR(ISBLANK($G12),ISBLANK($H12),ISBLANK($K12),ISBLANK($L12),$G12:$H12<12,$K12:$L12<12),"Review",""),IF(OR(D12=$T$4,D12=$T$5),IF(OR(ISBLANK($F12),ISBLANK($I12),ISBLANK($J12),$F12<12,$I12<12,$J12<12),"Review","")
T2 and T3 are A and B Shift
T4 and T5 are C and D Shift
Any help would be great if it's at all possible.
I have rotating shifts that I would like to create a formula to tell me to review or be blank if the days are showing correctly.
Here is an example
Date | A and B Shift | C and D Shift |
14-Jul | ISBLANK($G12),ISBLANK($H12),ISBLANK($K12),ISBLANK($L12),$G12:$H12<12,$K12:$L12<12 | ISBLANK($F12),ISBLANK($I12),ISBLANK($J12),$F12<12,$I12<12,$J12<12 |
21-Jul | ISBLANK($F12),ISBLANK($I12),ISBLANK($J12),$F12<12,$I12<12,$J12<12 | ISBLANK($G12),ISBLANK($H12),ISBLANK($K12),ISBLANK($L12),$G12:$H12<12,$K12:$L12<12) |
So week 1 I want A shift to look at Mon, Tue, Fri, and Sat
But then week 2 I need it to look at Sun, Tue, and Wed.
My actual formula is this
IF(OR(D12=$T$2,D12=$T$3),IF(OR(ISBLANK($G12),ISBLANK($H12),ISBLANK($K12),ISBLANK($L12),$G12:$H12<12,$K12:$L12<12),"Review",""),IF(OR(D12=$T$4,D12=$T$5),IF(OR(ISBLANK($F12),ISBLANK($I12),ISBLANK($J12),$F12<12,$I12<12,$J12<12),"Review","")
T2 and T3 are A and B Shift
T4 and T5 are C and D Shift
Any help would be great if it's at all possible.