Currently the priority column is blank, but I would like to have it look like below. Trying to figure out how to get the order of importance starting from 1 and up and then 1 again once it goes to a different " Line #" only when the "status" is listed as OverDue otherwise it will just transfer over what is in the "Status" column. Gave up after not being able to get this to work
[TABLE="width: 382"]
<tbody>[TR]
[TD]Line[/TD]
[TD]Setup[/TD]
[TD]Status[/TD]
[TD]Work #[/TD]
[TD]Priority[/TD]
[/TR]
[TR]
[TD]Line 2[/TD]
[TD]8867[/TD]
[TD]Done[/TD]
[TD]abc123[/TD]
[TD]Done[/TD]
[/TR]
[TR]
[TD]Line 2[/TD]
[TD]8869[/TD]
[TD]Done[/TD]
[TD]abc124[/TD]
[TD]Done[/TD]
[/TR]
[TR]
[TD]Line 2[/TD]
[TD]8869[/TD]
[TD]At Line[/TD]
[TD]abc125[/TD]
[TD]At Line[/TD]
[/TR]
[TR]
[TD]Line 2[/TD]
[TD]8870[/TD]
[TD]OverDue[/TD]
[TD]abc126[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Line 2[/TD]
[TD]8870[/TD]
[TD]OverDue[/TD]
[TD]abc127[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Line 2[/TD]
[TD]8871[/TD]
[TD]Done[/TD]
[TD]abc128[/TD]
[TD]Done[/TD]
[/TR]
[TR]
[TD]Line 2[/TD]
[TD]8875[/TD]
[TD]Ready[/TD]
[TD]abc129[/TD]
[TD]Ready[/TD]
[/TR]
[TR]
[TD]Line 2[/TD]
[TD]8875[/TD]
[TD]Ready[/TD]
[TD]abc130[/TD]
[TD]Ready[/TD]
[/TR]
[TR]
[TD]Line 2[/TD]
[TD]8875[/TD]
[TD]Ready[/TD]
[TD]abc131[/TD]
[TD]Ready[/TD]
[/TR]
[TR]
[TD]Line 2[/TD]
[TD]8875[/TD]
[TD]Ready[/TD]
[TD]abc132[/TD]
[TD]Ready[/TD]
[/TR]
[TR]
[TD]Line 2[/TD]
[TD]8876[/TD]
[TD]OverDue[/TD]
[TD]abc133[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Line 2[/TD]
[TD]8877[/TD]
[TD]OverDue[/TD]
[TD]abc134[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Line 2[/TD]
[TD]8877[/TD]
[TD]OverDue[/TD]
[TD]abc135[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Line 2[/TD]
[TD]8877[/TD]
[TD]OverDue[/TD]
[TD]abc136[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Line 2[/TD]
[TD]8877[/TD]
[TD]OverDue[/TD]
[TD]abc137[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Line 2[/TD]
[TD]8883[/TD]
[TD]OverDue[/TD]
[TD]abc138[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Line 2[/TD]
[TD]8883[/TD]
[TD]OverDue[/TD]
[TD]abc139[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Line 2[/TD]
[TD]8884[/TD]
[TD]OverDue[/TD]
[TD]abc140[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Line 8[/TD]
[TD]9366[/TD]
[TD]Done[/TD]
[TD]abc142[/TD]
[TD]Done[/TD]
[/TR]
[TR]
[TD]Line 8[/TD]
[TD]9367[/TD]
[TD]At Line[/TD]
[TD]abc143[/TD]
[TD]At Line[/TD]
[/TR]
</tbody>[/TABLE]
Code:
=IF(C2<>"Scheduled",C2,IF(A2<>A1,1,IF(B2<>B1,IF(ISNUMBER(E1)=TRUE,E1+1,1))))
[TABLE="width: 382"]
<tbody>[TR]
[TD]Line[/TD]
[TD]Setup[/TD]
[TD]Status[/TD]
[TD]Work #[/TD]
[TD]Priority[/TD]
[/TR]
[TR]
[TD]Line 2[/TD]
[TD]8867[/TD]
[TD]Done[/TD]
[TD]abc123[/TD]
[TD]Done[/TD]
[/TR]
[TR]
[TD]Line 2[/TD]
[TD]8869[/TD]
[TD]Done[/TD]
[TD]abc124[/TD]
[TD]Done[/TD]
[/TR]
[TR]
[TD]Line 2[/TD]
[TD]8869[/TD]
[TD]At Line[/TD]
[TD]abc125[/TD]
[TD]At Line[/TD]
[/TR]
[TR]
[TD]Line 2[/TD]
[TD]8870[/TD]
[TD]OverDue[/TD]
[TD]abc126[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Line 2[/TD]
[TD]8870[/TD]
[TD]OverDue[/TD]
[TD]abc127[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Line 2[/TD]
[TD]8871[/TD]
[TD]Done[/TD]
[TD]abc128[/TD]
[TD]Done[/TD]
[/TR]
[TR]
[TD]Line 2[/TD]
[TD]8875[/TD]
[TD]Ready[/TD]
[TD]abc129[/TD]
[TD]Ready[/TD]
[/TR]
[TR]
[TD]Line 2[/TD]
[TD]8875[/TD]
[TD]Ready[/TD]
[TD]abc130[/TD]
[TD]Ready[/TD]
[/TR]
[TR]
[TD]Line 2[/TD]
[TD]8875[/TD]
[TD]Ready[/TD]
[TD]abc131[/TD]
[TD]Ready[/TD]
[/TR]
[TR]
[TD]Line 2[/TD]
[TD]8875[/TD]
[TD]Ready[/TD]
[TD]abc132[/TD]
[TD]Ready[/TD]
[/TR]
[TR]
[TD]Line 2[/TD]
[TD]8876[/TD]
[TD]OverDue[/TD]
[TD]abc133[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Line 2[/TD]
[TD]8877[/TD]
[TD]OverDue[/TD]
[TD]abc134[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Line 2[/TD]
[TD]8877[/TD]
[TD]OverDue[/TD]
[TD]abc135[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Line 2[/TD]
[TD]8877[/TD]
[TD]OverDue[/TD]
[TD]abc136[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Line 2[/TD]
[TD]8877[/TD]
[TD]OverDue[/TD]
[TD]abc137[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Line 2[/TD]
[TD]8883[/TD]
[TD]OverDue[/TD]
[TD]abc138[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Line 2[/TD]
[TD]8883[/TD]
[TD]OverDue[/TD]
[TD]abc139[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Line 2[/TD]
[TD]8884[/TD]
[TD]OverDue[/TD]
[TD]abc140[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Line 8[/TD]
[TD]9366[/TD]
[TD]Done[/TD]
[TD]abc142[/TD]
[TD]Done[/TD]
[/TR]
[TR]
[TD]Line 8[/TD]
[TD]9367[/TD]
[TD]At Line[/TD]
[TD]abc143[/TD]
[TD]At Line[/TD]
[/TR]
</tbody>[/TABLE]