Can anyone tell how can I stop the specific symbols from being entered in my sheet?
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],":")
)
User | Count |
---|---|
37 | |
31 | |
29 | |
22 | |
18 |