Calculation Error when checking for empty field

asked on April 5, 2024

I thought this would be very simple and straightforward, but apparently I thought wrong.

My original intent was to check to see if there was a nickname returned by a lookup on the previous form. If there was then I would build a full name using this formula =IF(nickName='',CONCATENATE(firstName,' ',lastName),CONCATENATE(firstName,' "',nickName,'" ',lastName))...but that didn't work.

So I simplified it as far down as I could as a test. Now the formula looks like this =IF(nickName="", 'Hello'). That errored as well. I've tried every combination of quotes. I even created a new field just for testing but still got an error.

Can someone explain what I'm doing wrong?

0 0

SELECTED ANSWER

replied on April 5, 2024 • Show version history

I think part of the issue could just be the use of single quotes instead of double quotes. Additionally, you have an if true option, but not an if false option.

Maybe instead of:

=IF(nickName="", 'Hello')

Try this one:

=IF(nickName="", "Hello", "")

And something like this should work for your original function:

=IF(nickName="",CONCATENATE(firstName," ",lastName),CONCATENATE(firstName," '",nickName,"' ",lastName))

2 0

Question

Question

Calculation Error when checking for empty field

Answer

Replies

Sign in to reply to this post.