- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 22, 2024 09:37 AM
Hello everyone,
I am trying to get my formula to recognize numbers >= $0.00 in all of the columns listed:
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 22, 2024 09:44 AM
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}
))

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 22, 2024 09:44 AM
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}
))
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 22, 2024 12:53 PM
This worked. Thank you so much!
