Help
Formulas
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Resolved! Appending a comma separated field with values from another field?

Hey all! I'm back with a new issue that I'm hoping won't be too hard to solve but I can't seem to find the solution myself. I have two fields that I need to combine. Field 1 contains a variable, such as GKM3, GKM5, etc. Field 2 contains comma-separat...

Screen Shot 2024-03-20 at 2.56.13 PM.png
AaronB by 5 - Automation Enthusiast
Solved
  • 149 Views
  • 2 replies
  • 1 kudos

Resolved! IF AND Remove Text

I'm trying to write a formula to remove the "➟" if the preceeding field is empty.Current Formula:Origin& " ➟ " &{Destination}&" ➟ "&{Backhaul From}& " ➟ "&{Backhaul To\\Return}& " ➟ " &Origin &" - LANE #" & {LANE#}  Here is the output of the above fo...

Smyth_County by 6 - Interface Innovator
Solved
  • 295 Views
  • 4 replies
  • 1 kudos

Resolved! Extracting Earliest Date in a Rollup Field

I looked for other solutions on the forum and either I'm too much of a novice to know how to solve it or it didn't work for my problem. I have a rollup field that is collecting multiple dates. I'd like to have it only return the earliest date in the ...

LaurenMaine by 5 - Automation Enthusiast
Solved
  • 175 Views
  • 4 replies
  • 0 kudos

Converting hyphen into sequential numbers

Hey all! I have a problem that I hope you can help with. I have a massive amount of data that I need to put into Airtable that I received in the below format. However, I need to put each individual instance into a linked record field in AT, so the 1-...

Screen Shot 2024-03-19 at 3.39.58 PM.png
AaronB by 5 - Automation Enthusiast
  • 106 Views
  • 1 replies
  • 0 kudos

Resolved! Extra Lines from Formula using TRIM() and & "\n" &&

I have addresses with several fields, some fields are not always necessary.MemberOrganizationMail Address2nd Mail AddressCityStateZipo CodeTrying to get a multi line field that has no blank lines.Here's the formula I am using. I cannot find a way to ...

Screenshot 2024-03-19 at 10.22.54 AM.png

List of all the Sundays between 2 dates in Formulas

Hi! I am struggling to come up with a formula for this problem I am having:I need to create a formula on Airtable that will list all the Sundays that fall between a field called Created Time (date), and another called Start Date (date that is after t...

mayammine by 4 - Data Explorer
  • 96 Views
  • 0 replies
  • 0 kudos

Formula Help!

Hello, I am new to formulas so I was hoping someone can help me with the formula below. I am trying to create two new formula fields.In the first new formula field, I am trying to do the following: If the 'Category' field is Finance and the 'Owner' f...

coco-chen by 4 - Data Explorer
  • 185 Views
  • 4 replies
  • 0 kudos

Formula for 90 days after, up to a certain date.

Hey! I'm trying to figure out how to add a portion to a formula that would ensure that it's set for 90 days after a particular field, or before June 1st. The current formula pulls from a date field for when they registered (Date Registered), and adds...

Comparing records in different fields in the same table

Hi, I have 3 Fields “Name” “Results” “Position” I will like to compare the values in “Results” Field and position it from ‘1st - last row’ (Field “Position”) If “Field Results” Row 1 or Record 1 is > Row 2, then Row 1 = “1st” else If “Results” Re...

2 3

Formula to look for scheduling conflict

Hey Airtable! I'm looking for some complex scheduling help. I'm using Airtable to schedule a multi stage music festival, and we're hoping to have a formula that will look for scheduling conflicts for individual performers at specific times. I have an...

VFMFKatie by 4 - Data Explorer
  • 239 Views
  • 3 replies
  • 0 kudos

Sort results of rollup

I have 2 tables with a many-to-many relationship...Companies companyName, companyCountries (linked to Countries table)Countries countryName, projectPhase, countryCompanies (linked to Companies table)The projectPhase is country level, for example...GB...

DanielP by 6 - Interface Innovator
  • 543 Views
  • 1 replies
  • 1 kudos

Resolved! Scoring system where number of criteria scored is variable

Hi,We have a scoring system that rates functionality in an interface. So as not to bias the total score, if the functionality isn't present we ask evaluators to give it a -1.In Excel, the final score is determined by a formula that:Counts the number ...

Can Airtable solve equations with variables?

I’m trying to figure out if AirTable can solve equations with unknown variables. For instance, a break-even analysis based on data in the table. (Revenue per unit ⨉ Units sold) − (Fixed costs + Cost per unit ⨉ Units sold) = 0 (200 ⨉ Units Sold) − (10...

Resolved! IF formula assistance using dates

Hello! I'm creating an Airtable base to manage book club meetings. I have a column for the meeting dates (DD/MM/YYYY) which take place once per month. I'd like to have a "Reading Status" column that uses a formula to create the following labels:"All ...

soupdawg22 by 4 - Data Explorer
Solved
  • 159 Views
  • 2 replies
  • 1 kudos

Concatenate with Italic text

Hi All, I want to create a bibliography. I have all the pieces in different columns and want to use the concatenate formula to pull them all together. However the Title of the book needs to be in Italics, how do I carry over the italics from the cell...

Kathy_Lewis by 5 - Automation Enthusiast
  • 616 Views
  • 1 replies
  • 2 kudos

Lookups, Rollups, and Formulas producing comma after unique values

Hello,I'm pulling in purchase order data for my company, and have a "Vendor Management Team Partner" associated with each purchase order record.I'm also reconfiguring these POs in a separate table, such that the email address of the PO requester is t...

mtardiff_0-1709913200332.png
mtardiff by 5 - Automation Enthusiast
  • 253 Views
  • 5 replies
  • 2 kudos