Is there a way to have a default value that shows in a cell if the cell's value is not in the cell's value list. Example:
Value List
1 Red2 Blue3 Green
If the cell's value is anything besides 1, 2, or 3 I would like it to show up as UNDEFINED. Can I do this, and if so how?
Do you care what the underlying value is? Typically, in a case like this, you would allow nulls and simply set the NullTextLabel on the column to the strnig you want to show when it's null.
Is there anything I can do if the value is not going to be null? It could be pretty much any integer, but if it's not one of the integers I have a label for I would like it to show as UNDEFINED.