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

Formulas are disappearing for no reason

Hello altogether, this is driving me crazy. I am entering some formulas in my field and while I am adding fields, they disappear. This behaviour is consistent for all the fields. What is going on? Is it because there are too many referenced fields?  

  • 200 Views
  • 2 replies
  • 0 kudos

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?

  • 1203 Views
  • 4 replies
  • 0 kudos

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

  • 149 Views
  • 2 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...

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

  • 2168 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
  • 169 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...

  • 223 Views
  • 2 replies
  • 0 kudos