Please enable Javascript to access the support portal. Here are the instructions how to enable JavaScript in your web browser.

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?

Have more questions? Submit a request

0 Comments

Article is closed for comments.