Skip to main content

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.

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!

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!


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!

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!



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


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


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

Reply


Terms & Conditions