Internal Mobility Rate Calculation
=COUNTIFS($C:$C,"Internal Move",$A:$A,E$1)/COUNTIF($A:$A,E$1)ADVERTISEMENT - IN-ARTICLE
Implementation Guide
This HR task calculates internal mobility rates by measuring the proportion of employees who change roles within a given period. It supports talent development analysis, succession planning, and retention strategy evaluation. The formula updates automatically as HR events are logged, enabling real-time monitoring. HR leaders can segment results by department, location, or job family to identify barriers or best practices. The metric is easy to communicate to executives and aligns with modern talent mobility frameworks. Used consistently, it encourages internal growth and reduces external hiring dependency.
💡 Expert Q&A Insights
Q: Does this include promotions only?
It can include lateral moves if labeled accordingly. |
Q: Can it be tracked quarterly?
Yes, adjust the period filter.