Hey Airtable community,Been hitting my head against the wall for the last hour with this. I'm trying to write a formula for:If {Donor First Name} is not empty, then the field would read: {Donor First Name}&" "&{Donor Last Name}And if {Donor First Nam...
Hey AT community,
I can’t figure out why this formula isn’t working – AT is telling me it’s an invalid formula:
CONCATENATE({Full Name copy}, IF(NOT({Full Name copy}), Org), " - $", {Received Amount}, " - ",DATETIME_FORMAT({Date Received}, “D/M/YYYY”...
Hello! I am currently using the below formula to pull together a list of cities that correspond to a record. I have City 1, City 2, City 3, City 4, City 5, Cities 6 fields. Formula looks like this:
CONCATENATE({BP City 1}, ", ",{BP City 2}, ", ",{BP ...
