Forum Discussion

Brass Contributor

Nov 10, 2023

Force a format on data input in a list column.

How do I force the user to enter a text field in the format #####-#####. The # symbol represents a numeric. Thanks

Brass Contributor

Nov 13, 2023

Use column validation in column settings.

=AND(ISNUMBER(VALUE(LEFT(col;5)));ISNUMBER(VALUE(RIGHT(col;5)));MID(col;6;1)="-")

works for me.