Help

Re: Error in formula field

786 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Jill_Holland
5 - Automation Enthusiast
5 - Automation Enthusiast

Is there a problem using a formula field in another formula field ? I have 2 calculated fields that I want to derive from 2 number fields. The 2 raw number fields are {Seeds per g} and {Plan2023}.
I derive an {adjusted Plan} field using 1.1*{Plan2023}. I then want to derive the {wt of seeds required} field using {adjusted plan} /{Seeds per g} but this gives an error for every record.
Even if I make the {wt of seeds required} formula something really simple like {adjusted plan}/2 or 0.5*{adjusted plan} it gives all errors.
I can make the formula just = {adjusted plan} but as soon as I do any numeric operation on it it gives errors.

4 Replies 4
Jill_Holland
5 - Automation Enthusiast
5 - Automation Enthusiast

OK I sorted it out. The first calculated field used an if statement with an option that if a record was empty, the result was " ". So airtable classified this field as being not numeric, even though it looked like it was. I changed the " " option to 0 and its all OK. Is there an option to have the result being “blank” rather than 0 when a preceding field is also blank ?

Leave off the third parameter of the IF function.

IF(
  {adjusted Plan},
  {adjusted plan} /{Seeds per g} 
)

Thanks kuovonne. I also found there is a Blank() option for formulas.

Yes, there is. I personally do not find it useful. Other people may find it easier to understand.