Displaying #Missing with Smart Lists

Administrators set the values that are displayed in Smart Lists and data cells, including what is displayed when there is no data in the cell. When there is no data in a cell, the cell can display no value (that is, the cell is blank), #Missing, or—for cells associated with Smart Lists—another value that you specify.

Use these options to control the display of #Missing in such cells when they are not in focus:

Option Description

Blank

When designing the data form, select Display Missing Values as Blank.

When setting Smart List properties, select Grid.

#missing

When designing the data form, do not select Display Missing Values as Blank.

When setting Smart List properties, select Grid.

A custom label, such as “No Change”

When setting Smart List properties, enter the custom label in the #Missing Drop-Down Label field (for example, No Change). Select DropDown.