How can I block symbols in appsheet form _-":';?)/(#)-:,

Can anyone tell how can I stop the specific symbols from being entered in my sheet?

0 2 75
2 REPLIES 2

Steve
Platinum 4
Platinum 4

There is no good way to do it.

Something like this as a valid IF formula if its a single item in say an ENUM column

IN([ColumnName],LIST("_","-",":))

Or this if its a string

OR(
CONTAINS([ColumnName],"_"),
CONTAINS([ColumnName],"-"),
CONTAINS([ColumnName],":")
)

Simon@1minManager.com

Top Labels in this Space