Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

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

Formulas Activity

SEARCH() and FIND() functions broken?

I'm trying to use either a SEARCH() or FIND() function to locate a comma within a string. Unfortunately, these seem to be broken on Airtable right now. Am I missing something? This should be pretty straightforward, right?

  • 52 Views
  • 3 replies
  • 0 kudos

Formula to Calculate Date from Linked Table

I have a base that has client names in a table and appointment date on another table that is linked to the specific client. I am trying to create a formula in the client table that will display the last appointment for that that client that was sched...

  • 59 Views
  • 1 replies
  • 0 kudos

Individual Dashboard Universal Link

Hello,I am using Airtable in conjunction with a web app. On my web app, I have a page for a section dashboard that shows communal information. Additionally, I have an individual dashboard, which displays information about a particular user.My problem...

  • 55 Views
  • 1 replies
  • 0 kudos

Resolved! Calculate average in interface

Hey I'm quite new but couldn't find an answer : I'm looking to show the average of a column in the interface. To be specific, I have a set of data from one table and I'm selecting certain data from another table, and I want to calculate the average o...

  • 103 Views
  • 3 replies
  • 0 kudos

Resolved! Formula to Assign Single-Select Value

Hello,I'm moving into the List View Interface, and I am loving the "Prefix" field which allows me to use visual indicators to quickly see the status of records. My current roadblock is this, I haven't been able to figure out:How can I have a Single S...

M_L_1-1728332677253.png M_L_0-1728332655197.png
  • 91 Views
  • 1 replies
  • 0 kudos
M_L by 7 - App Architect
Solved

Formula to Calculate Calendar Months

Hello,Using a last modified field type named "Closed" and a lookup field showing the last one called "Meter Type" and "Repeat Interval" I am trying to calculate and output the appropriate date when closed is 7/17/2024 16:41, meter type is Calendar Mo...

  • 129 Views
  • 2 replies
  • 0 kudos

Help with a formula please!

Hi Just wondering if anybody can help with a formula?I'm trying to set up a task (meeting date) that can occur on a Tuesday of say the 1st week, 2nd week, 3rd week or 4th week of the month. So lets say the due day was  Tuesday 02/10/2024 then i'd lik...

  • 96 Views
  • 1 replies
  • 0 kudos

Resolved! Access a field in another table using a formula

I have master blocks of code in my code table.in another table - main table -I wish to get data from a field in the code table by specifying it’s rec ID. I will then combine this code with other data from the main table. I can do this with a linked t...

  • 132 Views
  • 2 replies
  • 0 kudos