Shift Work ! Need clarification

[Diablozx]

Hello All,

Greetings. ! I m Arun & new to this forum and i would like to go to my problem directly.

I have created a table like the below pasted. 5 set of jobs has been done in 1st shift (Timings from 9 am - 5 pm). In that there are 3 jobs are pending. I need to make these pending jobs as a priority for the next shift (2nd shift . timing 7 pm - 2 am ) . How can i auto-update or these pending cells for next shift when the shift person opens these excel file.

1) What i have made : 1st shift excel file after 5 PM

sl.noDateTimeShiftworkProgressIncharge Name
130-Jan-149.301st shiftwater cans to be filledcompletedJohn
230-Jan-1410.301st shiftmachining workspendingJohn
330-Jan-1411.001st shifttransportationcancelledJohn
430-Jan-1411.301st shiftcleaning of roomspendingJohn
530-Jan-1412.001st shiftrework garden pathspendingJohn

2) What i need is this . when 2nd shift person (jacob) opens the excel, he should get auto updated with the pending progress as his 1st priority.

sl.noDateTimeShiftworkProgressIncharge Name
130-Jan-1419.001st shiftmachining workpendingjacob
130-Jan-1419.001st shiftcleaning of roomspendingjacob
130-Jan-1419.001st shiftrework garden pathspendingjacob

Hope you guys understand. Sorry for my bad english.

~ Arun

 

[Luke M]

Three possible ideas...

a)You could use Conditional Formatting to highlight tasks that are marked Pending.

b)You could define a new list with order "pending, in progress, complete, cancelled", and then sort the Progress column by this list

c)Could use a formula to pull info from Pending rows, like:
=IF(COUNTIF(F:F,"pending")
<ROWS(A$2:A2),"",INDEX(E:E,SMALL(IF(F$2:F$2000="Pending",ROW(F$2:F$200)),ROW($A1))))

Confirm this formula as an array using Ctrl+Shift+Enter, not just Enter, and copy down as far as you think would ever be needed.

 

[SirJB7]

Hi, Diablozx!

As a new user you might want to (I'd say should and must) read this:
http://chandoo.org/forum/forums/new-users-please-start-here.14/

Besides your hurry and straightforward path to your problem, of course.

Regards!