Two IF formulas

[Angelena_Zeiser]

I currently have this:
DATETIME_FORMAT({Date of donation}, ‘M/D/YYYY’) & “—” & IF({On behalf of corporation?}, {Donor’s employer}, Donor)

I have another field named “Member Donor”. If the Donor field is blank then I want it to pull the Member Donor field.

[TheTimeSavingCo · Accepted solution]

Hi Angela, could you try this out?

DATETIME_FORMAT(
  {Date of donation}, 'M/D/YYYY'
) & 
'—' & 
IF(
  {On behalf of corporation?}, 
  {Donor’s employer}, 
  IF(
    {Donor},
    {Donor},
    {Member Donor}
  )
)

Edited to fix the curly quotes issue pointed out by kuovonne!

[Angelena_Zeiser]

Thank you! At first it gave me an error but when I removed the curly brackets from Donor, it worked! I’m not sure why that table doesn’t pull the curly brackets for that field. Thank you again!

[kuovonne]

Adam_TheTimeSavingCo:

DATETIME_FORMAT(
  {Date of donation}, ‘M/D/YYYY’
) & 
“—” & 

Forum curly quotes strike again! Formulas don’t handle curly quotes ‘ ’ “ ” well. Use straight quotes instead ' ' " "

Sounds like the Angelena solved this on her own though.
(This post is mostly a tip for anyone else who finds this thread.)

[TheTimeSavingCo]

Ah man, thanks for this! Have edited my post to fix this issue