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

Formulas Activity

Tag a record based on event title

Hello!I would like to tag some records based on the text content in a column (ie: if Title contains "Tour" tag Tours). Feels like it should be pretty straightforward but I can't figure out how? Thanks! For more context: I imported all of my team's ev...

  • 37 Views
  • 2 replies
  • 0 kudos

DateAdd Function

Hello,  I am trying to create a formula to put together a date we expect something to be completed.Date to Client is entered by my team and is the first part of the equation.Client Timing is pulled as a lookup field from another table dependent on ea...

  • 35 Views
  • 2 replies
  • 0 kudos
Zak1 by 5 - Automation Enthusiast

Can a formula reference it's own field's name?

I'm wondering if a formula has a way to reference the field name.  For example I want to name a field the number 10 and then use a formula which calculates if {other field} < {thisfield.name}.Is that possible?

  • 32 Views
  • 1 replies
  • 0 kudos

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

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

  • 97 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:...

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

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

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

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

  • 231 Views
  • 4 replies
  • 0 kudos