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

Formulas Activity

Resolved! Formula calculation using date fields

I am using a formula to calculate a date in one field, and then trying to use another formula field to determine whether a contract is current, future, or expired using that date and another manually entered date field.  The field I'm using to determ...

Screenshot - 2_13_2025 , 11_08_53 AM.png
  • 20 Views
  • 1 replies
  • 0 kudos

HELP WITH FORMULAS

I am trying to build a table to calculate pricing. But, every column (which is its own product) has different price points under it, based on square footage. How can I set up a formula that will calculate each drop-down option (multiple selection), p...

  • 135 Views
  • 2 replies
  • 0 kudos

need help with a formula to scan values in 3 fields in Table B and

Hi - first timer here!I have 2 tables in 1 base.  Table A contains info about Recipes I'm creating. Table B is where I schedule those recipes for newsletter publication. Recipe names are pulled from Table A into Table B by linking fields. There are 3...

  • 64 Views
  • 4 replies
  • 0 kudos
jym by 4 - Data Explorer

Resolved! If/And with Blanks and Not Blanks

Hi there. I am trying to write a formula ("Duration of Pending Repayment") that calculates how long an unpaid repayment is overdue.Essentially, it will be:If "Repayment Due Date" is not blankAnd "Repayment Received Date" is blankThen calculate Today-...

AndreaR_0-1739291281597.png
  • 53 Views
  • 2 replies
  • 0 kudos

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

  • 94 Views
  • 3 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...

  • 93 Views
  • 4 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?

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

  • 208 Views
  • 8 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...

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

  • 189 Views
  • 2 replies
  • 0 kudos