Courier Delivery Process Flow / Tracker | HR Hiring an Employee Tracker in Excel 365 Version (Insert Tab | Check Box) Progress % =COUNTIF(C4:F4,TRUE)/COUNTA(C4:F4) Status =IF(I4=TRUE,"Returned",XLOOKUP(FALSE,C4:F4,$C$3:$F$3,"Delivered")) Conditional Formatting for Highlight!
Courier Delivery Process Flow / Tracker | HR Hiring an Employee Tracker in Excel 365 Version (Insert Tab | Check Box)
Progress % =COUNTIF(C4:F4,TRUE)/COUNTA(C4:F4)
Status =IF(I4=TRUE,"Returned",XLOOKUP(FALSE,C4:F4,$C$3:$F$3,"Delivered"))
Conditional Formatting for Highlight!