Help

Re: Two IF formulas

Solved
Jump to Solution
503 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Angelena_Zeiser
6 - Interface Innovator
6 - Interface Innovator

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.

1 Solution

Accepted Solutions
TheTimeSavingCo
17 - Neptune
17 - Neptune

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!

See Solution in Thread

4 Replies 4
TheTimeSavingCo
17 - Neptune
17 - Neptune

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!

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