Skip to Content

Formula for: If 1 field isnull then show 2 fields

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Apr 20, 2017 at 03:04 PM

    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

    Add comment
    10|10000 characters needed characters exceeded