I want to do a if null statement with a multi select text field but keep getting an error If(not IsNull(ToText([ESCALATION_OVERRIDE])),[ESCALATION_OVERRIDE])

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
Photo of Shontay

Shontay

  • 490 Points 250 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Is that your whole formula?  What is it that you are trying to do?  What is the field type result that you are looking for?
Photo of Shontay

Shontay

  • 490 Points 250 badge 2x thumb
if the [Escalation_Override is not null then display the text in the multi selection field Escalation Override

Entire Formula-
If (Contains([MSS_EWO_OPEN],"-CD") or Contains([MSS_EWO_COMPLETE],"-CD"),"CRITICAL DSLAM") &" " &
If (Contains([MSS_EWO_OPEN],"-NG") or Contains([MSS_EWO_COMPLETE],"-NG"),"NORTH GEORGIA") &" " &
If (Contains([MSS_EWO_OPEN],"-CP") or Contains([MSS_EWO_COMPLETE],"-CP"),"CRITICAL PINS") &" " &
If (Contains([MSS_EWO_OPEN],"-HO") or Contains([MSS_EWO_COMPLETE],"-HO") or [# of PSR Orders]>0,"HELD ORDERS") &" " &
If (not IsNull (ToText([ESCALATION_OVERRIDE])),[ESCALATION_OVERRIDE) &" " &

If(    [SITE_EXCH_ST]="CLBRGA"     or [SITE_EXCH_ST]="BTVLGA"
   or [SITE_EXCH_ST]="CRTOGA"     or [SITE_EXCH_ST]="CMRCGA"  or [SITE_EXCH_ST]="cmrcGA"
   or [SITE_EXCH_ST]="COMRGA"    or [SITE_EXCH_ST]="DWVLGA"
   or [SITE_EXCH_ST]="DWVLGA"     or [SITE_EXCH_ST]="DLRDGA"
   or [SITE_EXCH_ST]="DEVLGA"      or [SITE_EXCH_ST]="CRNVGA"
   or [SITE_EXCH_ST]="CYTNGA"      or [SITE_EXCH_ST]="DHLNGA"
   or [SITE_EXCH_ST]="ENLLGA"       or [SITE_EXCH_ST]="HELNGA"
   or [SITE_EXCH_ST]="SCHSGA"      or [SITE_EXCH_ST]="MYVLGA"
   or [SITE_EXCH_ST]="HOMRGA"     or [SITE_EXCH_ST]="NCSNGA"
   or [SITE_EXCH_ST]="HWSSGA"      or [SITE_EXCH_ST]="LAKSGA"
   or [SITE_EXCH_ST]="LAKSGA"       or [SITE_EXCH_ST]="PNDRGA"
   or [SITE_EXCH_ST]="JSPRGA"       or [SITE_EXCH_ST]="JFSNGA"
   or [SITE_EXCH_ST]="JFSNGA"       or [SITE_EXCH_ST]="LAVNGA"
   or [SITE_EXCH_ST]="ILA_GA"         or [SITE_EXCH_ST]="ILAGA"  or [SITE_EXCH_ST]="ILA-GA"
   or [SITE_EXCH_ST]="BLVIGA"         or [SITE_EXCH_ST]="WNVLGA"
   or [SITE_EXCH_ST]="TOCCGA"       or [SITE_EXCH_ST]="BGCNGA"
   or [SITE_EXCH_ST]="BATNGA"        or [SITE_EXCH_ST]="YNHRGA"
   or [SITE_EXCH_ST]="CLEVGA"        or [SITE_EXCH_ST]="CRNLGA"or [SITE_EXCH_ST]="CLVLGA"

,"GA -DISTRICT 9","")
Try just using
ToText([ESCALATION_OVERRIDE])

in your formula.  You do not have to check if it is not null.
Photo of Shontay

Shontay

  • 490 Points 250 badge 2x thumb
Thanks, perfect!