If Then formula help

  • 0
  • 1
  • Question
  • Updated 9 months ago
  • Answered
I need help with an If then statement.  I would like a formula that says If the [Inventory Number Field] is blank then use the value from the [Asset Number] field.
Photo of TIm

TIm

  • 90 Points 75 badge 2x thumb

Posted 9 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,842 Points 50k badge 2x thumb
The answer depends on he field type of the [Inventory Number Field]

If it is a numeric field type and the setting is to treat blank as zero, then use:

IF([Inventory Number Field]<>0, [Inventory Number Field], [Asset Number])

If the [Inventory Number Field] is a numeric field but the setting is unchecked so not to treat blank as zero, then use :

IF(not IsNull([Inventory Number Field]), [Inventory Number Field], [Asset Number])

and lastly if the field is in fact a text field type then use:

IF(Trim([Inventory Number Field])<>"", [Inventory Number Field], [Asset Number)
Photo of TIm

TIm

  • 90 Points 75 badge 2x thumb
Thank You!  The text Field solution is exactly what I needed!