jeudi 18 décembre 2014

2010 - Changing #VALUE! error in Calculated Column



I have a calculated column called SUID # that pulls the value from a single line text input called SUID. The formula in SUID # is:



=RIGHT(LEFT(SUID,INT(FIND("=",SUID)-1)),LEN(LEFT(SUID,INT(FIND("=",SUID)-1)))-1)


If SUID is blank, the SUID # column will show #VALUE!


Is it possible to change that error text? I would like it to say "Please Enter the SUID Only on Package Pickup"








0 commentaires:

Enregistrer un commentaire