Formulas | Airtable Community

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

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

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

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

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

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

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

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

177 Views
4 replies
0 kudos

Resolved! FILTER BY NEXT WORK DAY, LAST WORK DAY

I'm sure this an easy one - but I am stumped. Here is the scenario: I want to create a view so I can send out a daily report that shows all records that are on tomorrow's service schedule, yesterday's service schedule, and 2 weeks ago service schedu...

134 Views
2 replies
0 kudos

Resolved! Prevent formula from rounding

Hello,I have a very simple formula that is taking the values calculated from other fields and giving a total. The problem I am running into is unless I have the formatting set to 5 decimal places the results will round. For the work we are doing we...

201 Views
4 replies
0 kudos