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

Forum Posts

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

Lisa_H by 6 - Interface Innovator
  • 91 Views
  • 1 replies
  • 1 kudos

Resolved! Combine multiple fields based on certain conditions

Hi,I have a formula that almost works. I'm trying to make my primary field a formula where it looks at "Column A" and looks at "Column B". If a there's a value in "Column A", enter that value as the primary field. If there's a value in "Column B", en...

Danny_Mohill by 5 - Automation Enthusiast
Solved
  • 1331 Views
  • 13 replies
  • 8 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...

Dpond by 4 - Data Explorer
  • 158 Views
  • 4 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...

KateR1 by 4 - Data Explorer
  • 100 Views
  • 2 replies
  • 1 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...

SenRath by 5 - Automation Enthusiast
  • 106 Views
  • 3 replies
  • 0 kudos

Conditionally update a single select field

Hi!I have a table where I am tracking when a certain item (Lot) needs to have its lab testing updated. Each record has a {Lab Status} single select field, a {Latest Lab Date} date field, a {Next Lab Due} field that calculates a date 6 months out from...

ranunculus by 4 - Data Explorer
  • 305 Views
  • 6 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...

littlex by 4 - Data Explorer
  • 66 Views
  • 0 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...

J_C by 5 - Automation Enthusiast
Solved
  • 201 Views
  • 4 replies
  • 2 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...

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

Phaderon by 5 - Automation Enthusiast
Solved
  • 170 Views
  • 5 replies
  • 2 kudos