Forum Discussion

AshleyAsante's avatar
AshleyAsante
Qrew Cadet
8 years ago

Formula Help

I am trying to write a formula for a new field.

If [ships in 7 days] a formula field is "yes", then display the number in [pallets outbound]
if not, display 0.


here's what I have -- not sure why I am getting an error.


If([Ships within 7 days?] = "yes", [Pallets Outbound],"0")

9 Replies

  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    In suspect that this is a formula numeric field and you are trying to populate text into it.

    Try this as I removed the quotes

    If([Ships within 7 days?] = "yes", [Pallets Outbound],0)
  • ChrisChris's avatar
    ChrisChris
    Qrew Assistant Captain
    8 years ago
    The 0 should not be within quotes. Also what data type is [Ships within 7 days] ? If it's a check box then the value would be true. if([Ships within 7 days]=true, [pallets outbound],0) 
  • _anomDiebolt_'s avatar
    _anomDiebolt_
    Qrew Elite
    8 years ago
    How about this:

    If([Ships within 7 days?] = "yes", ToString([Pallets Outbound]), "0")
    • _anomDiebolt_'s avatar
      _anomDiebolt_
      Qrew Elite
      8 years ago
      OP>I am trying to write a formula for a new field.

      In the event the OP wanted a text result.
    • QuickBaseCoachD's avatar
      QuickBaseCoachD
      Qrew Captain
      8 years ago
      ToString is actually not a published Quick Base function.

      It seems to revert to ToText though upon saving.