I have a union workforce and they rely heavily on seniority for scheduling and mandatory overtime, etc. I've developed a seniority tracker/calculator that keeps track of seniority through status and title changes. I can easily pull reports filtered and grouped by lists (Full Time RN, Part Time RN, etc.) for them to see their seniority. Unfortunately, once put in the dashboard for them to access, the row numbers from the report disappear. I need to use the dashboard view to strip formatting, which is used by management staff to see who's on leave or in training, etc.
The workaround seems to be a column to calculate their "seniority number" that would survive even as management sorts the source sheet every which way. I can't figure out the formula. I would need the numbering to be title/status specific (Full Time RN starting at one and then Part Time RN starting at one, etc.). The ordering is based on accumulated days of seniority, which is how they're sorted in the reports now.
Any ideas? (I have already voted on the addition of row numbering to the dashboard report views)
