Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

If a field is blank use another field

Topic Labels: Formulas
324 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Very new to this so apologise if its a simple question. I have a field that is “cost”, a field that is “cost over-ride” and then a feild that is “actual cost”. What i want to do is to use the cost over-ride field but if blank use “cost”. Any tips will be much appreciated.

1 Reply 1

Welcome to the forums @Liam_Woolley!

You should be able to do this by making {actual cost} into a formula field with an IF() statement. The formula would look something like this:

IF({cost over-ride}, {cost over-ride}, cost)

This simply checks if {cost over-ride} has a value, and if it does, it uses that value. If not, it uses {cost}.

Make sure to also edit the Formatting on the {actual cost} formula field, you’ll need to change it to Currency.

Hope that helps.