Hi all,
Little bit of background: I work in corporate company's HR department, and to be more specific in 'Mobilization Team' which I look after on-boarding process of nationals & expatriate employees. I have this mobilization spreadsheet to keep track of new starters and already mobilized personnel to company. I use this spreadsheet to report our progress.
Main point: The spreadsheet is completely 100% manual where I have to edit every single details to make it look right and it's not a nice thing to do. I want to improve this to keep better track of everything, up-to-date record etc.
What I want to improve:
1. Editing/modifying - when I change date, or input a data, it reflects the change to that whole row for that person to.
2. Adding formula/function - I can only see IF function. How do I add IFS for multiple conditions and values?
3. Multiple choice drop down list - If the personnel has completed first stage and currently stuck at second stage I want the STATUS to show : Medical Stage (First stage being : Contract Signing Stage; Third stage : SAP ID activation; Fourth stage : Mobilized). This is tied to 1 & 2 like when the person has signed the contract : IF(F7>=DATE(2016,9,13),'Mobilised'),F7 4. If the later stages are not confirmed, without given date and the cell is empty, the STATUS cell counts whatever cell has date or data in it. Example: If the Medical completed date has date and SAP number provided date is empty ; the status shows: Medical Stage
5. I want the STATUS cell to show 4 different colors in gradient bar. If it's stage 1: yellow ; stage 2: orange; stage 3; blue or something ; stage 4; green
Please help me as much as you can. English is not my native and first language - apologies if it doesn't make sense at all. But can you please edit and modify my attached (somehow I cant attach file) spreadsheet as close as possible to things I mentioned above?
Your assistance is greatly appreciated.
Mobilsation Spreadsheet Template.xlsx
Bookmarks