Forum Discussion

KimG's avatar
KimG
Qrew Cadet
4 years ago

If formula syntax for if field is blank

Hi I have a formula rich text field to help indicate if a number added in the "Measured" field next to it is within the desired criteria.  It looks like this: This is the example I f...
Formulas and functions
Tables and fields
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago
Can you try changing the field properties for the [Measured] field to deselect (uncheck) to treat blank as zero.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
  • KimG's avatar
    KimG
    Qrew Cadet
    4 years ago
    Thanks for tip! So many little things to remember. I know I've probably noticed that option in the field settings before.  It works fine now.

    Any suggestions for my secondary question regarding the syntax for my warning message to include both a color and pull the data from the other table?

    ------------------------------
    Kim Gardner
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      4 years ago
      Try this in a new formula to test.

      If([Moisture Content]>=[Abrasive - Moisture threshold of Current Incoming inspection],
         "<div style=\"color:white; background-color:#FF0000;\"> The sample is out of spec! It should be < "
       & ToText([Abrasive - Moisture threshold of Current Incoming inspection]*100) & "%" & "</div>",

      [Moisture Content]<[Abrasive - Moisture threshold of Current Incoming inspection],
        "Sample is within the acceptable range of <" &[Abrasive - Moisture threshold of Current Incoming inspection]*100 &"%",

      "The acceptable range is <" &[Abrasive - Moisture threshold of Current Incoming inspection]*100 &"%")


      ..... as for the null issue, I believe that Excel always treats a blank cell as a zero if you are doing mathematical operations but in Quickbase you get to choose whether a blank in a data entry numeric field means zero or a blank means null. 

      ------------------------------
      Mark Shnier (YQC)
      Quick Base Solution Provider
      Your Quick Base Coach
      http://QuickBaseCoach.com
      mark.shnier@gmail.com
      ------------------------------
      • KimG's avatar
        KimG
        Qrew Cadet
        4 years ago
        Yes! Thank you! It works.  I really appreciate the assistance.

        ------------------------------
        Kim Gardner
        ------------------------------