Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Two IF formulas

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

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

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

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