Appendix - Project Name Validation Formula

The below Validation formula has been added to the Project Name field to prohibit special characters:

=AND(IF(ISERROR(FIND(",",[Project Name])),TRUE),IF(ISERROR(FIND("&",[Project Name])),TRUE),IF(ISERROR(FIND("{",[Project Name])),TRUE),IF(ISERROR(FIND("}",[Project Name])),TRUE),IF(ISERROR(FIND("~",[Project Name])),TRUE),IF(ISERROR(FIND("#",[Project Name])),TRUE),IF(ISERROR(FIND("<",[Project Name])),TRUE),IF(ISERROR(FIND("%",[Project Name])),TRUE),IF(ISERROR(FIND(">",[Project Name])),TRUE),IF(ISERROR(FIND("*",[Project Name])),TRUE),IF(ISERROR(FIND("(",[Project Name])),TRUE),IF(ISERROR(FIND(")",[Project Name])),TRUE),IF(ISERROR(FIND("-",[Project Name])),TRUE),IF(ISERROR(FIND("|",[Project Name])),TRUE),IF(ISERROR(FIND("+",[Project Name])),TRUE),IF(ISERROR(FIND(":",[Project Name])),TRUE),IF(ISERROR(FIND(";",[Project Name])),TRUE),IF(ISERROR(FIND("?",[Project Name])),TRUE),IF(ISERROR(FIND("'",[Project Name])),TRUE),IF(ISERROR(FIND(".",[Project Name])),TRUE),IF(ISERROR(FIND("/",[Project Name])),TRUE),IF(ISERROR(FIND("\",[Project Name])),TRUE),IF(ISERROR(FIND("""",[Project Name])),TRUE))

For additional information on creating a project item, please refer to How do I create a new project from the Project Center?

Comments

0 comments

Please sign in to leave a comment.