Help

CONCATENATE w/ multiple IF statements

Topic Labels: Formulas
827 2
cancel
Showing results for 
Search instead for 
Did you mean: 
xLindsey21
4 - Data Explorer
4 - Data Explorer

Hey there!

I am an Airtable novice looking for formula help. 🙃

I have a table with columns: Year, Candidate, Entity/Org, Side, Race Level, State, District

Right now, my formula is:

IF(Candidate !="", CONCATENATE({Candidate},", ",State," ",District),

CONCATENATE({Entity/Org}," - ", Side))

which will pull the Entity/Org & Side when the candidate field is empty. However, there are instances where

  1. the District field is empty (in which case I want to pull in the {Candidate},", ",State," ",{Race Level})
  2. & instances where the District field AND the Candidate field are empty (where I want to pull in the {Entity/Org}," - ", Side))

Any help is greatly appreciated!

Thanks!

2 Replies 2
Sho
11 - Venus
11 - Venus

How does it work if Candidate is empty and there is a Distrcit? (FALSE() part)

IF(NOT({Candidate}),
  IF(NOT({District}),
    CONCATENATE({Entity/Org}," - ", {Side}),
    FALSE()
  ),
  IF(NOT({District}),
    CONCATENATE({Candidate}, ", ", {State}, " ", {Race Level}),
    CONCATENATE({Candidate},", ",{State}," ",{District})
  )
)
IF(Candidate,
CONCATENATE({Candidate}, ", ", State, " ", IF(District,
District,
{Race Level}
)
),
CONCATENATE({Entity/Org}, " - ", Side)
)