Can anyone tell how can I stop the specific symbols from being entered in my sheet?
There is no good way to do it.
1 Like
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],":")
)
2 Likes