Forum Discussion
Tracking student progress
JeffreyB593 Not sure I follow, but when I select/enter some new Competencies and refresh the pivot table, all seem to be included properly. With respect to adding new assignments, select the last block from the table (i.e. T1:W37). Copy and Paste to X1. The table is expanded with all the formats and data validation in place. Do NOT select entire columns T to W. Then it will not work.
JeffreyB593 Not sure I follow, but when I select/enter some new Competencies and refresh the pivot table, all seem to be included properly. With respect to adding new assignments, select the last block from the table (i.e. T1:W37). Copy and Paste to X1. The table is expanded with all the formats and data validation in place. Do NOT select entire columns T to W. Then it will not work.
Here is the version where I change the Competency row to a pull down menu with the codes that I created on Sheet 4. I'm guessing I need a Concatenatex formula to add to the pivot table similar to the Assessment formula but I'm still learning that one.
- I figured it out. Thanks for all your help and getting me pointed in the right direction.
- I think I figured it out. Learned more about Concatenatex and it wouldn't be helpful. Went into the Query and was able to change the column from Whole Number to Text and it works!