You’re missing the last part of the IF statement.

An IF statement has three components:

1. The condition



2. What happens if the condition is true



3. What happens if the condition is false

What do you want if the Date of Donation is not blank?

To build on this, you don’t necessarily need the third part of the statement. If you omit the third part, the formula will implicitly return a blank value if the condition isn’t met.

Additionally, it is usually better to avoid using BLANK() in IF statements. You can write

IF({Field Name}, "Field is Not Empty")

And this is the same thing as writing

IF({Field Name} != BLANK(), "Field is Not Empty")

So if the Date of Donation is blank in the column then I want it to return basically a blank space. Right now without the IF Statement it is giving me an error message.

I tried that if statement and it doesn’t work?

What do you mean “without the IF statement”? What formula are you using?

Right now in this is what I have

DATETIME_FORMAT({Date of Donation}, ‘MM/DD/YY’) & " | " & {First Name} & " " & {Last Name}

And on the cells that don’t have a date it says ERROR. So I need the IF statement to say If there is no date enter nothin or a blank space.

So this is the IF statement I have thus far

IF ({Date of Donation} = BLANK()," “)

but obviously it is wrong because it does not work.

Try this:


IF({Date of Donation},DATETIME_FORMAT({Date of Donation}, ‘MM/DD/YY’) & " | " & {First Name} & " " & {Last Name}," ")

You might consider putting something like “No Date of Donation” instead of " ".

Still not working, even if I put BLANK in the " "

Did you get an error when you tried saving the formula field after you pasted my formula?


If yes, then there’s something wrong with the field names.

If not, are you getting an error for all records where the {Date of Donation} is blank? Do all records have a First Name and Last Name?

When I added your formula and tried to save it, it wound’t let me even save it because it wasn’t formatted correctly.

No all the fields do not have a first name and last name. Thats why I need another IF statement that says IF first name and last name are blank then put organization name.

When I added your formula and tried to save it, it wound’t let me even save it because it wasn’t formatted correctly.

No all the fields do not have a first name and last name. Thats why I need another IF statement that says IF first name and last name are blank then put organization name.

I see what happened: When you paste my formula, it changes the single quotes in ‘MM/DD/YY’ to smart quotes. (The first one is angled up to the left and the second one is up to the right.)


Try pasting again and change the single quotes to get ‘MM/DD/YY’.

Here’s the formula that also takes into account first and last names:


IF({Date of Donation},


IF(AND({First Name},{Last Name}),


DATETIME_FORMAT({Date of Donation}, ‘MM/DD/YY’) & " | " & {First Name} & " " & {Last Name},


DATETIME_FORMAT({Date of Donation}, ‘MM/DD/YY’) & " | " & Organization)," ")

It doesn’t check to make sure that there’s an organization.

I still can’t get it to work?

Also Organization is a field so shouldn’t it be {Organization}

No. Only field names with multiple words need to be wrapped in braces. See Formula field reference.

“I still can’t get it to work?”

Sorry to hear that. It works for me.


I don’t have any other suggestions.

I still found styled quotes in several of the most recent examples above. I cleaned those up, and optimized the formula a little more. Try this:

IF(


    {Date of Donation},


    DATETIME_FORMAT({Date of Donation}, 'MM/DD/YY') & " | " &


    IF(


        AND({First Name},{Last Name}),


        {First Name} & " " & {Last Name},


        Organization


    )


)

Thank you for your help but it still isn’t working?

IF(


    {Date of Donation},


    DATETIME_FORMAT({Date of Donation}, 'MM/DD/YY') & " | " &


    IF(


        AND({First Name},{Last Name}),


        {First Name} & " " & {Last Name},


        Organization


    )


)

Just to clarify I want the code to say if the first name and last name cells are blank then type the organization name. and if the date of donation is blank type a blank space.

This is what I have coded thus far:

DATETIME_FORMAT({Date of Donation}, ‘MM/DD/YY’) & " | " & {First Name} & " " & {Last Name}

I am also in the far left column coding this I don’t know if it makes a difference

Yup, that’s exactly what my formula does. Here’s a screenshot:

My version is in the first field, so that’s not the issue.

What exactly is (or isn’t) happening when you try to use the formula I wrote? Do you see an error message? Do you see a different result than what you expect? If so, what is it? The more details you can provide, the easier it will be to help.

Yeah that’s exactly what I want it to do. Except sometimes there is no date. maybe that’s why it doesn’t work?

It just says error invalid and it won’t let me enter it. Thats exactly what I have my fields as too.

Just to verify this is the full code that should work?

DATETIME_FORMAT({Date of Donation}, ‘MM/DD/YY’) & " | " & {First Name} & " " & {Last Name} IF(


{Date of Donation},


DATETIME_FORMAT({Date of Donation}, ‘MM/DD/YY’) & " | " &


IF(


AND({First Name},{Last Name}),


{First Name} & " " & {Last Name},


Organization


)


)

No, only this code should be used:

IF(


    {Date of Donation},


    DATETIME_FORMAT({Date of Donation}, 'MM/DD/YY') & " | " &


    IF(


        AND({First Name},{Last Name}),


        {First Name} & " " & {Last Name},


        Organization


    )


)