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
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,522 Points 50k badge 2x thumb
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","")
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,522 Points 50k badge 2x thumb
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!