To extend the number of Skills and Skill Profiles tracked in the Training Dashboard, follow the steps below.

Step 1: Unprotect the Sheets


You’ll need to unprotect the Skill Profile and Skills sheets using the password: HRRT.


For detailed instructions on how to unprotect a sheet, please refer to the following support article:

How to unprotect sheets?

Step 2: Increase Skill Profile Limit

  1. Go to the Skill Profile sheet and select cells A52 and A53 as shown in the screenshot below:


  2. Click and drag the bottom-right corner of the selected cells downward to expand the Skill Profile limit.

Step 3: Increase Skill Limit


3.1 Clear Existing Formulas & Values


Delete the contents in the following cells:

  • Skill Profile Sheet: C1 to AA2

  • Skills Sheet: D1 to BA3

3.2 Re-enter the Required Formulas


In the Skill Profile Sheet:

  • C1 →

=SEQUENCE(1,COUNTA(L_SKILLS))

  • C2 →

=IFERROR(INDEX(L_SKILLS,C$1#),"")


In the Skills Sheet:

  • D1 →

=QUOTIENT(SEQUENCE(1,COUNTA(L_SKILLS)*2)-1,2)+1

  • D2 →

=CHOOSE(MOD(SEQUENCE(1, COUNTA(L_SKILLS)*2,0),2)+1,"ACTUAL","EXPECTED")

  • D3 →

=IFERROR(INDEX(L_SKILLS,D1#),"")

3.3 Expand Skill Columns


Add the necessary number of columns to the right of the current skill list and before the error highlight column, maintaining the correct sequence.


Skill Profile Sheet:

  • Use the existing cell AA3 containing SK25 as a reference.

  • Select it and drag right from the bottom-right corner to auto-fill the sequence (e.g., SK26, SK27, etc.).


Skills Sheet:

  • In a blank sheet, use this formula to generate the new skill headers:

="Skill "&SKILLS!D1#&" "&LEFT(SKILLS!D2#,1)

  • (Note: Ensure Step 3.2 is completed first)

  • Copy the generated values and paste them into the Skills table header using Paste Special → Values.

3.4 Add Formulas to New Columns


Copy one of the existing EXPECTED column formulas and paste it into the newly added columns to ensure proper calculation for the new skills.

3.5 Protect the sheet


Once all updates are complete, re-protect the Skill Profile and Skills sheets using the password HRRT to prevent accidental edits or modifications to the formulas and structure.

Let me know if you’d like a downloadable version or if you’re inserting this directly into a help center article.