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

Forum Posts

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

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
  • 155 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
  • 520 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
  • 93 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
  • 591 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
  • 180 Views
  • 5 replies
  • 2 kudos

Deduplicating names in a text array

Hi,I hope you can help me, I've searched everywhere and I can't find an answer to my problem.I work for a training organization. I have a table with students. A table with training session dates. And a table with speakers.In the dates table, I make a...

Resolved! Extract email from User Field

Is there a way to extract a users email address from their account info?Context...I have a form built in "interfaces" and have toggled on "see who submitted response".Ideally I'm trying to extract the domains for the users as a method to sort with di...

chrisberry by 6 - Interface Innovator
Solved
  • 111 Views
  • 2 replies
  • 1 kudos

Formula: dividing a column by a number

Hi, I’m trying to add a formula where I divide one column by a number. Like: Column A: 5000 Column B: result Formula: Column A(5000) / 365 Any idea? Been trying to find a solution to make this work…really don’t want to go back to excel… :sob: :frow...

Resolved! Converting word responses into intergers

Hi everyone, I am new to the Airtable and I'm excited to be part of this community. May I apologise in advance if I don't use the correct technical terminology.  I design surveys, impact assessments and evaluation tools for a criminal justice charity...

Resolved! Make.com formula for Airtable

Hi! I have data coming in from a webhook to Make. I am trying to create a formula in Make to search Airtable for number of times an email appears in a field on a table and limit the number of submissions to Airtable. For example, I want to limit the ...

lmac by 5 - Automation Enthusiast
Solved
  • 239 Views
  • 8 replies
  • 2 kudos

Statute of limitations countdown

Hello, I am setting a legal case tracking base and I am trying to do something where:1: When I input the date of incident, it automatically calculates two years from that date2: I would like to have a table that also has a countdown until we reach th...