Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
10 years ago

Formula text field isn't working with IfNull()

I have a formula text field with the following formula: If(IsNull([Preferred Vendor(Form)]),[Item List - Preferred Vendor],[Preferred Vendor(Form)]). The [Item List - Preferred Vendor] field is a loo...
Forms
Formulas and functions
Relationships
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
It looks to me that your [invoiceNumberOverride] field is actually a numeric field type.

If so, you would do

If([invoiceNumberOverride] > 0, ToText([invoiceNumberOverride]),ToText(5000 + [Record ID#]))