New rows in tables filtered where a column .Matches() a select list automatically set illegal values for column

Demo doc below. Essentially filtering a table on a criterion that a given column must match a select control with the .Matches() formula causes new rows to have their value for that “filtered on” column set to the value selected in the select list control, which is usually good.

However, when the select list and column are incompatible, the behaviour still happens which is odd. Admittedly, the use case itself is somewhat nonsensical…