Skip to Content
0

Formula for: If 1 field isnull then show 2 fields

Apr 20, 2017 at 02:26 PM

32

avatar image

Hello!

I'm trying to write a formula that would show two fields, next to each other, if 1 field is null. Something like this (though this doesn't work)

"If isnull ({field 1})

then ({field 2} and {field 3})

else {field 1}

Can this be done? Thanks! Rich

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Abhilash Kumar
Apr 20, 2017 at 03:04 PM
1

Hi Rich,

If Field1 is a string field, try:

If isNull({Field 1}) OR {Field 1} = '' then
{Field 2} & " " & {Field 3}
Else {Field 1}

-Abhilash

Share
10 |10000 characters needed characters left characters exceeded