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...
Forum Discussion
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
------------------------------
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
Qrew Legend
Qrew LegendTry 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
------------------------------
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
------------------------------
- Yes! Thank you! It works. I really appreciate the assistance.
------------------------------
Kim Gardner
------------------------------