Logic to restrict seperator type in cell

smitaranikr04

Hi team,

I have column in which values are separated by different seperator like ":" ,";", "." Etc.

I want to restrict user to enter only one seperator that is ";"

Is it possible in smartsheet?

Paul Newcome

You cannot restrict it during entry, but you can use a helper column with a formula (series of SUBSTITUTE functions) to swap out the incorrect delimiters with the corrects ones.

smitaranikr04

Could you please share one example

Paul Newcome

It would look somethign like this:

=SUBSTITUTE(SUBSTITUTE([Column Name]@row, ":", ";"), ",", ";")