IF statement, when there is a blank cell

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

Great!

This works, thanks so much.

But I have one more question. If the cell doesn’t have an org name or a date nothing is showing up, I would like for at least their first and last name to show up?

This variation should take care of that. If the date is there, it will format it before the person/org name, whichever is available. If no date, the name will still appear.

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

wow thank you so much for all your help