Help

If this, then this. If blank, then that

Topic Labels: Formulas
Solved
Jump to Solution
352 1
cancel
Showing results for 
Search instead for 
Did you mean: 

I’m not sure why this one isn’t working, because I’ve tried copying and pasting from another base where this formula DOES work.

Screen Shot 2020-09-02 at 12.37.13 PM

I’m trying to write an IF statement for the Gift ID. If “Donor Account” is not blank, GIFT ID should pull Donor Account after the date. If it IS blank, it should pull Company.

This is my starting point, but it’s telling me it’s not a real formula.

(DATETIME_FORMAT({Date of donation}, ‘M/D/YYYY’) & " — ") & IF(Donor account, Donor account,Company)

Thoughts?

1 Solution

Accepted Solutions

Because Donar account is a multi-word field name, you need to enclose it in braces {}

DATETIME_FORMAT({Date of donation}, 'M/D/YYYY') & " — " & IF({Donor account}, {Donor account},Company)

See Solution in Thread

1 Reply 1

Because Donar account is a multi-word field name, you need to enclose it in braces {}

DATETIME_FORMAT({Date of donation}, 'M/D/YYYY') & " — " & IF({Donor account}, {Donor account},Company)