If a field is blank use another field

Topic Labels: Formulas
724 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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
7 - App Architect
7 - App Architect

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.