AdamTanner
8 years agoQrew Trainee
Using 'not ifnull' formula in a 'formula text field'
I need some help with a formula. I am trying display text if a field is not null. This is my current formula:
If(not IsNull([AP Supplier Type]), "Oracle Hold",
If(not IsNull([CURRENTWORKNODE]), "Rapid Hold",
If(not IsNull([Amt]), "Payment Hold")))
Currently, everything is being listed as an "Oracle Hold". I am not sure what I am doing wrong. Your help is much appreciated!!
If(not IsNull([AP Supplier Type]), "Oracle Hold",
If(not IsNull([CURRENTWORKNODE]), "Rapid Hold",
If(not IsNull([Amt]), "Payment Hold")))
Currently, everything is being listed as an "Oracle Hold". I am not sure what I am doing wrong. Your help is much appreciated!!