CONCATENATE w/ multiple IF statements

[xLindsey21]

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!

[Sho]

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

[Andy_Lin1]

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