Skip to main content

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!

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

 

Reply


Terms & Conditions