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

Formulas Activity

Counting the Number of Children for Each Mother in the Same Table

I have a table in Airtable with two fields: "Child" and "Mother" (just an example to explain the structure easily). The "Mother" field is a linked record to the same table. Here’s a sample dataset:ChildMotherRaviSnehaKaviSnehaBalliPrernaMalliPrernaSn...

  • 88 Views
  • 5 replies
  • 0 kudos

Merge dates for linked records

I'm managing 5 websites, and have created one base with 5 tables - each reflecting the blog planning for one website (syncing with the website-specific bases). I've now created a table that collects all the posts from all the websites, so I can see w...

  • 70 Views
  • 2 replies
  • 0 kudos

How do I use a formula to pull just the City out of a lookup cell?

Hi,I have one column in my Jobs Table that pulls the Job address from my Table of Customers, its a Formula and seems to work fine it puts the correct Job address into the Jobs Table if the customer has a different Mailing address, it looks like this:...

  • 129 Views
  • 2 replies
  • 0 kudos

URL to Hyperlink

I am working on a job board project and have this challenge. I have gone through some of the community posts but cannot figure out a solution.The marketplace is continuously updated with titles, urls etc.I want to convert the URLs to hyperlink. As we...

  • 141 Views
  • 3 replies
  • 0 kudos

Formula to calculate Actuals as at end of most recent quarter

Hi,Hoping that someone might be able to help me with a formula question (I'm quite new to formulas and have been fumbling along until now, but have reached the limit of my knowledge!)...I have a table of payments that have been made, each with the pa...

  • 136 Views
  • 2 replies
  • 0 kudos

Introducing Formula AI: Instantly Generate Airtable Formulas with AI

Hey everyone,I’m excited to share a new tool I’ve been working on: Formula AI.Formula AI is an AI-powered assistant that helps you create Airtable formulas instantly. No more struggling with complex formulas—just describe what you need in plain Engli...

  • 81 Views
  • 0 replies
  • 0 kudos

Scripting Error

Hi, I am very new to scripting and managing a base for content production.  Want to create a script that will update a series of dates based off the publication date changing.  I'm getting errors and not sure why.  Any help would be appreciated.  Tha...

  • 201 Views
  • 4 replies
  • 0 kudos

Using COUNTIF statements

Hi all,I need to generate a 4 digit code from the year a record was created and how many records have come before in that year.E.g the 5th record that has been created in 2023 = 2305.I have reformatted the referral date DATETIME_FORMAT({Date of Refer...

  • 198 Views
  • 2 replies
  • 0 kudos

Resolved! Prefilling a form with a linked record

Hi there,I have two tables and an interface with a form. The first form is used to add an entry to the table. I have this displayed as a nice gallery.I wanted to add a button on the gallery, so the user can click the button on the record and it will ...

  • 222 Views
  • 5 replies
  • 0 kudos

Resolved! Formulas for dates

I am trying to track when i should expect a project back based on the amount of days given to return. The first return length is 70 days or 10 weeks. The second time it is submitted is 30 days return. Column: Submitted date: (constant)- user entered ...

  • 208 Views
  • 4 replies
  • 0 kudos