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

Formulas Activity

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

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

  • 63 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
  • 51 Views
  • 2 replies
  • 0 kudos
AndreaR by • 6 - Interface Innovator
Solved

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

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

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

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

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

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

  • 197 Views
  • 3 replies
  • 0 kudos