What a field's text→value step returns.
value: undefined is NOT null: it means "this text yields no opinion" — the last valid value stands and nothing is emitted (a formula field with no workbook degrades this way). null is a real value ("cleared") and IS emitted.
value: undefined
null
A message KEY for invalid text (translated at display), or null when valid.
Optional
The parsed value, null for cleared, undefined for "no opinion" (see the remarks).
undefined
What a field's text→value step returns.
Remarks
value: undefinedis NOTnull: it means "this text yields no opinion" — the last valid value stands and nothing is emitted (a formula field with no workbook degrades this way).nullis a real value ("cleared") and IS emitted.