Project Wizard has a hidden sheet called ‘Rules’ that enables the user to make columns required either in ‘Create’ or ‘Update’ mode. It is specific to the workbook and is not stored in the instance, so you have to do this configuration step before handing the spreadsheet out to users:
Right-click on any sheet tab and click ‘Unhide’.
Unhide the ‘Rules’ sheet and click ‘OK’.
The following sheet will be visible:
Enter ‘Mandatory’ or ‘Ignore’ in the appropriate column - Row 11 for creating projects and Row 12 for updating projects.
The columns will now be required by the tool during project creation. This worksheet is not kept up to date, but any column provided on the templates can be added to this worksheet and the rules applied.
The ‘Rules’ sheet can be hidden again by choosing ‘Hide’ from the right-click-menu on the sheet name.
