Forum Discussion

iwannabfishn's avatar
iwannabfishn
Copper Contributor
Aug 03, 2023

Column validation disappears

I am trying to setup some column validation and I hit save, but when I go back and look again it is blank. This is what I am trying to add. I need to make sure the Title field doesn't have characters in that can't be used in the name of document since I rename the document using the Title field as part of the name. If you know what I am doing wrong please let me know. Thanks!

 

=AND(IF(ISERROR(FIND("/",[Title])),TRUE),
IF(ISERROR(FIND("\",[Title])),TRUE),
IF(ISERROR(FIND("<",[Title])),TRUE),
IF(ISERROR(FIND(">",[Title])),TRUE),
IF(ISERROR(FIND(":",[Title])),TRUE),
IF(ISERROR(FIND(";",[Title])),TRUE),
IF(ISERROR(FIND("*",[Title])),TRUE),
IF(ISERROR(FIND(""",[Title])),TRUE),
IF(ISERROR(FIND("|",[Title])),TRUE)

No RepliesBe the first to reply

Resources