The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
Aug 08, 2022 03:12 AM
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.
Aug 08, 2022 03:21 AM
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 ?
Aug 08, 2022 05:38 AM
Leave off the third parameter of the IF
function.
IF(
{adjusted Plan},
{adjusted plan} /{Seeds per g}
)
Aug 11, 2022 06:13 AM
Thanks kuovonne. I also found there is a Blank() option for formulas.
Aug 11, 2022 07:30 AM
Yes, there is. I personally do not find it useful. Other people may find it easier to understand.