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

Forum Posts

Resolved! Calculation Percent yes/no in one field

I am looking for a way to calculate some percentages in my base. There are a few things I need to do first:1. I want to only include records listed as "Budgeted" or "Not Budgeted", not any "N/A" records. (this removes TEST 1 and TEST 4 from my calcul...

KevinTC91_0-1707511298379.png
KevinTC91 by 5 - Automation Enthusiast
Solved
  • 3180 Views
  • 4 replies
  • 4 kudos

Allocate information based on post number

Hello, I just started with Airtable, and to be able to use it, I need solve this problem. I am having a database of volunteers on a national level. I would like to make them write their post number when they apply, and in the base allocate a decided ...

LauraF by 4 - Data Explorer
  • 514 Views
  • 0 replies
  • 0 kudos

Multi likes help me

I'm using a no-code tool and I want to have a multi-like with Airtable.On the no-code side, we've set up GET, POST and PATCH to make the like work, but the problem is that it's not attached to a single user. In other words, let's say user A posts a l...

Sarahhh1 by 4 - Data Explorer
  • 581 Views
  • 0 replies
  • 0 kudos

Ingredient stock rollup

Hello,We are a vitamin supplement company and we buy ingredients from all over the world. We have 178 different ingredients which are used to create 17 products.  Sometime the same ingredients will be used for five different products.We want to creat...

MoniK by 4 - Data Explorer
  • 1179 Views
  • 3 replies
  • 0 kudos

How to Insert a Line Break in a Long-Text Column

I'm working with a long-text column in Airtable and need to insert line breaks into my text to help improve readability. Could anyone guide me on how to add a break (\n) in my text within a long-text field in Airtable? Any help or guidance would be m...

serdar by 4 - Data Explorer
  • 1327 Views
  • 1 replies
  • 1 kudos

Resolved! Empty Space in search formula

I am using a mid formula to extract a string of text. The string appears as expected in the cell, but when Make (Integromat) runs the search it is adding an extra space before the string. " <string>" If the empty space is present, wouldn't I see it i...

Screen Shot 2023-09-13 at 11.25.55 AM.png Screen Shot 2023-09-13 at 11.26.45 AM.png Screen Shot 2023-09-13 at 11.27.24 AM.png Screen Shot 2023-09-13 at 11.28.14 AM.png
Jaxtraw by 4 - Data Explorer
Solved
  • 1037 Views
  • 2 replies
  • 1 kudos

Difference in Date for For Different Records w/ Same Serial Number

I am importing customer support tickets from another database (Hubspot) in an attempt to calculate the following:1) What is the duration between each ticket date (single field) for the same product serial number? The goal is to understand the average...

blankman by 4 - Data Explorer
  • 677 Views
  • 0 replies
  • 0 kudos

How to automated functions

Hello community I have been trying to solve an issue. I am looking for the correct formula to automatically fill the columns, (CCC Loads, variable expenses, fixed expenses) in the cost per mile calculator listed below. Those entries will be pull from...

screenshoteasy (3).png screenshoteasy (2).png screenshoteasy (1).png screenshoteasy.png
Jghost1800 by 4 - Data Explorer
  • 2087 Views
  • 7 replies
  • 1 kudos