If Fromula

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
I have the following formula created but it won't return the second half of the formula.  So if the formula is null the field is returning empty

If(not IsNull([Novelty Item]),[Novelty Item],[Event - Items])
Photo of Scott


  • 240 Points 100 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,698 Points 20k badge 2x thumb
I'm assuming both fields are text fields: 

When you are finding 'null' values for text fields you have to use the double quotes ""
'Null' is used for numeric or date fields.

So try this:
If([Novelty Item]="", [Event - Items], [Novelty Item])

If([Novelty Item]<>"",  [Novelty Items], [Event - Item])