When adding new fields to an excel template, it is important to update the name range of the template so that all fields in the generated report are filled out. If this is not done properly, you may encounter issues with fields showing on custom reports.
Begin by downloading the custom excel template by clicking on the 'Copy of Excel Template File' link (which for this example, is the 'Copy of Job List' text).
Once downloaded, view the report in excel like so.
To update the name range of the report to include all fields which should appear correctly in the custom report, click on the 'Formulas' tab at the top of the screen. Then proceed to the 'Name Manager' function, as shown in the image below.
From here you can view the existing name manager for the fields. To add additional columns, simply select the field name entry, click into the 'Refers to:' field and then highlight the fields which should appear in the generated report.
Once done, click on the 'upload' button and proceed to save and re-upload the template, which should now correctly display fields when used to generate a report.