Skip to main content

Hello everyone,

I am trying to get my formula to recognize numbers >= $0.00 in all of the columns listed: 

 
My formula:
 
IF({August FY25 Projections},{August FY25 Projections},IF({FY Start Split Formula},{FY Start Split Formula},{Original FY25 Revenue Projections}))
 
For reference:
The August FY25 Projections column is a currency field
The other 2 fields are formulated fields with a currency format.
Attached you can see the "Updated FY25 Revenue Projections" column is skipping over the $0.00 amount that is listed in the August field. This is incorrect and should have picked up the $0.00 amount as per the order of the IF statement.
 
Any help would be appreciated!
 

In Airtable formulas, a numeric value of zero is a "falsy" value, and thus you cannot check for the presence of a value in a numeric field with only the field name. Instead, convert the value to a text string to test if there is a value.

IF(
{August FY25 Projections} & "",
{August FY25 Projections},
IF(
{FY Start Split Formula} & "",
{FY Start Split Formula},
{Original FY25 Revenue Projections}
))

In Airtable formulas, a numeric value of zero is a "falsy" value, and thus you cannot check for the presence of a value in a numeric field with only the field name. Instead, convert the value to a text string to test if there is a value.

IF(
{August FY25 Projections} & "",
{August FY25 Projections},
IF(
{FY Start Split Formula} & "",
{FY Start Split Formula},
{Original FY25 Revenue Projections}
))

This worked. Thank you so much!

Reply


Terms & Conditions