How do you obtain GUID ID numbers for batch loading objective sets? I have over 3050 objectives to load into 13 different objective sets and cannot batch load the objective sets without GUID ID numbers for each objective. How do obtain the GUID ID numbers?
2.) Highlight all the cells in the Guid ID column (less the title) copy the cells and then paste back in as text without formating (this removes the formula and keeps the Guid ID).
3.) Copy Guid IDs over to appropriate parent cells, to create nesting of objectives.
Comments (1)
I figured it out, here are the steps:
1.) Paste the following formula into the Guid ID cell, then copy and paste to all of your cells in the Guid ID column.
2.) Highlight all the cells in the Guid ID column (less the title) copy the cells and then paste back in as text without formating (this removes the formula and keeps the Guid ID).
3.) Copy Guid IDs over to appropriate parent cells, to create nesting of objectives.