Row 10 of the Wizard is reserved for Default Values. Any blank data rows below Row10 will be populated with default values. This occurs when validation is initiated on the worksheet and when the data entry form is opened.
Default Values (Row10) where the column is hidden, will still default to your data entry rows.
Standard validation will apply if the defaulted value is not valid for the field.
Default data can be derived from:
A manually entered value.
A formula i.e. =TODAY()
A Profile Option i.e. PROFILE: <Profile Name>
Note: A PROFILE query must be prefixed with PROFILE: otherwise, an error will be returned.
<Profile Name> is the profile name and not the 'User Profile Name' value. For example, the profile: More4Apps: BMW Allow past dates in component effectivity columns has a profile name of ‘M4APS_BMW_ALLOWPASTDATES'. This will populate blank cells in Column 1 with either Y (yes) or N (no), depending on how the Profile is set.
