![Holli_Younger Holli_Younger](https://community.airtable.com/legacyfs/online/avatars/2X/5/5f55cbd7a43201c4e61cb3b49a6674a097ec2334.png)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 11, 2020 10:55 AM
Can someone assist and ‘teach’ me where I’m going wrong, please?
Trying to pull data from Field B if Field A is blank. Here is the formula I’m currently using, which doesn’t return a value.
IF({Field A} < 5000, {Field A},IF({Field A}=BLANK(),{Field B}))
This formula works to pull data from Field A but Field C is blank, not fulling data from Field B. I don’t get a formula error, the field is only empty.
![Jeremy_Oglesby Jeremy_Oglesby](https://community.airtable.com/legacyfs/online/avatars/3X/d/3/d33ffc6c75e62047be139476e37ffce3cd20064e.jpeg)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 11, 2020 03:04 PM
The = BLANK()
operator doesn’t seem to be terribly reliable. You could reverse the logic and make a positive check for a value in {Field A}
first, and then split the paths on the basis of the existence of a value in {Field A}
instead:
IF(
{Field A},
IF(
{Field A} < 5000,
{Field A}
),
{Field B}
)
Just a heads up, though, this returns nothing if there is a value > 5000
in {Field A}
.
![Holli_Younger Holli_Younger](https://community.airtable.com/legacyfs/online/avatars/2X/5/5f55cbd7a43201c4e61cb3b49a6674a097ec2334.png)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 11, 2020 03:15 PM
Perfect! Thank you for the help and for explaining the process.
![](/skins/images/FE00829FDD2AE889FAB731D8F02A8942/responsive_peak/images/icon_anonymous_message.png)