Forum Discussion
Tracker for workers' promotion criteria
Hello, all. I'm currently in the process of trying to make an all-encompassing tracker for myself and those I'm responsible for. I'm almost at maybe 70-80% solution, but now I am trying to see i...
I can prolly use that to clean up my tracker, but the problem lies in that I'd still end up having to manually put everyone's date on their based on different positions.
dmitriusjoleskevich Somebody needs to put the dates in sometime. Or do you have the dates for all staff and number of months for each position in a table somewhere else already?. Perhaps I'm just misunderstanding the meaning of "auto-populate preset formulas". And maybe you can upload or share a file (Onedrive, Dropbox etc.). That would make it easier to understand.
dmitriusjoleskevich Okay! and what am I looking at?
- Essentially the only thing that matters is the rank DOR, BASD, TIS and TIG. So essentially what I'm trying to do is have formulas that feed into each other so i know the dates of how long a person has been in the organization (BASD), how long they have had the position (DOR). based on position (Rank), I'd like formula that I made (=DATE(YEAR(C4),MONTH(C4)+#,DAY(C4)) that feed into the last two acronyms (TIS based on BASD and TIG based on DOR) so I can know how long until they meet the time requirements for promotion.