
- 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.

- 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}
.

- 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.
