Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Aug 07, 2019 02:23 PM
If the cell is BLANK I want it to show up as blank in the field rather than ERROR
For example: IF ({Date of Donation} = BLANK()," “) but this isn’t working and right now I do not have the if statement so it is showing up as error.
I also want another IF statement that says : IF {{First Name} & {Last Name} = BLANK(), " {Organization }"}
So if the first name and last name are blank enter the organization name instead.
Aug 08, 2019 10:03 AM
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.
Aug 08, 2019 10:04 AM
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.
Aug 08, 2019 10:28 AM
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.
Aug 08, 2019 11:12 AM
I still can’t get it to work?
Aug 08, 2019 11:57 AM
Also Organization is a field so shouldn’t it be {Organization}
Aug 08, 2019 01:22 PM
No. Only field names with multiple words need to be wrapped in braces. See Formula field reference.
Aug 08, 2019 01:23 PM
“I still can’t get it to work?”
Sorry to hear that. It works for me.
I don’t have any other suggestions.
Aug 08, 2019 02:45 PM
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
)
)
Aug 09, 2019 07:45 AM
Thank you for your help but it still isn’t working?
Aug 09, 2019 07:50 AM
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.