Help

If this, then this. If blank, then that

Topic Labels: Formulas
Solved
Jump to Solution
805 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Dani_Oliver
6 - Interface Innovator
6 - Interface Innovator

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
kuovonne
18 - Pluto
18 - Pluto

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
kuovonne
18 - Pluto
18 - Pluto

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)