Skip to main content
Question

If Then formula help

  • March 25, 2018
  • 0 replies
  • 70 views
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.
      This topic has been closed for replies.

      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)
      • TimThornton
      • Author
      • Registered
      • March 27, 2018
      Thank You!  The text Field solution is exactly what I needed!
      Terms & ConditionsAccessibility statement