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

Forum Posts

Formula Help!

Hello, I am new to formulas so I was hoping someone can help me with the formula below. I am trying to create two new formula fields.In the first new formula field, I am trying to do the following: If the 'Category' field is Finance and the 'Owner' f...

Sort results of rollup

I have 2 tables with a many-to-many relationship...Companies companyName, companyCountries (linked to Countries table)Countries countryName, projectPhase, countryCompanies (linked to Companies table)The projectPhase is country level, for example...GB...

DanielP by 6 - Interface Innovator
  • 521 Views
  • 1 replies
  • 1 kudos

Resolved! Scoring system where number of criteria scored is variable

Hi,We have a scoring system that rates functionality in an interface. So as not to bias the total score, if the functionality isn't present we ask evaluators to give it a -1.In Excel, the final score is determined by a formula that:Counts the number ...

Lookups, Rollups, and Formulas producing comma after unique values

Hello,I'm pulling in purchase order data for my company, and have a "Vendor Management Team Partner" associated with each purchase order record.I'm also reconfiguring these POs in a separate table, such that the email address of the PO requester is t...

mtardiff_0-1709913200332.png
mtardiff by 5 - Automation Enthusiast
  • 182 Views
  • 5 replies
  • 2 kudos

Resolved! Extract email from User Field

Is there a way to extract a users email address from their account info?Context...I have a form built in "interfaces" and have toggled on "see who submitted response".Ideally I'm trying to extract the domains for the users as a method to sort with di...

chrisberry by 6 - Interface Innovator
Solved
  • 114 Views
  • 2 replies
  • 1 kudos

Limit data submission by user

I would like to limit the number of rows created in a table. I am planning to have a limited data entry period with 100 users where each user can only put in 10 rows of data. How would I achieve this with Airtable?

lmac by 5 - Automation Enthusiast
  • 287 Views
  • 4 replies
  • 1 kudos

Formula to auto generate data in new cell

I am using Air Table to capture costs per garment style and there are 12 versions of the costs that are available to use based on importing tariffs and shipping modes. These 12 costs are hard keyed into the base. I would like to be able to make the c...

amoersen by 4 - Data Explorer
  • 142 Views
  • 1 replies
  • 0 kudos

Resolved! Separate String of Values by Comma

I am trying to separate the values in the "ADKAR numerical value" column so that the first number (2) is inputted into the "Awareness value" column. Then so on where I input the next number after the comma into another column, etc.Any help is greatly...

Screenshot 2024-03-06 at 11.18.06 AM.png
alyssarados by 4 - Data Explorer
Solved
  • 120 Views
  • 1 replies
  • 1 kudos

Resolved! Copy Column with large amount of data

I have a Long Text column in my table with a lot of text, likely 20K plus pages. I used formulas to clean this text, removing undesirable characters, extra spaces, etc.  Is there any way to copy the contents of the Formula column back to the Long Tex...

K_B1 by 4 - Data Explorer
Solved
  • 182 Views
  • 3 replies
  • 0 kudos

Separating multiple data entries in field

Hey,I imported my contact database into a table and am trying to separate these years so that "2019; 2020" would turn into multiple datapoints that can be filtered accordingly like "2019, "2020" etc. Is there any easy way to do this? Thanks!

Screenshot 2024-02-26 164505.png

How to search for what's missing?

Hi all, I'm working on a donor management system for a non-profit org.  Donors make pledges to give $x on x recurring basis, usually something like $50 a month.I've got a table for Donors, one for pledges, and one for donations.I need to have a way t...

Split text to multiple columns

I want to separate the following text in different columns :Column A : @Ben//test-bug//Feb 22, 2024 3:54pm UTC//Budget//Test again//Test again//ModerateColumn B : @BenColumn C : test-bugColumn D : Feb 22, 2024 3:54pm UTCColumn E : BudgetColumn F : Te...

CSM_PF by 5 - Automation Enthusiast
  • 186 Views
  • 1 replies
  • 0 kudos

Adding sums between 2 dates

I need to be able to total up sums per line from an original start date for a full year after.Example:  Original  start date                   Amount paid-1, amount paid-2, amount paid-3, etc.                  This would be calculated for 1 year, the...

Resolved! Counting Data based on Parameters

I have two tables: "Billing" and "Activities". I'm trying to find a way to combine this data so that I can see $ received from bills while only including "TimeEntry's". In this specific scenario, the amount I would need to see is $530, since the $100...

Screenshot 2024-02-15 102610.png Screenshot 2024-02-15 102556.png
zhenson by 5 - Automation Enthusiast
Solved
  • 255 Views
  • 1 replies
  • 1 kudos

Resolved! Different dates in one week turned into the Monday of that week

Hi,Is there a way I can create a formula that will determine the Monday for all these dates and return just one date. For example, in this table it's looking up data from another table, in this case the Monday for this set of dates is the 12th. How c...

Screenshot 2024-02-12 at 9.49.51 PM.png
star_EF by 4 - Data Explorer
Solved
  • 265 Views
  • 2 replies
  • 0 kudos

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 4 - Data Explorer
Solved
  • 528 Views
  • 4 replies
  • 4 kudos

Resolved! Formule pour remplir une liste de selection unique

Bonjour à tous, J'ai un fichier avec une colonne TEXTE LONG et je souhaite remplir une colonne de SELECTION UNIQUE automatiquement en fonction d'un morceau de TEXTPouvez-vous m'aider ?

Mary by 5 - Automation Enthusiast
Solved
  • 403 Views
  • 3 replies
  • 2 kudos

Resolved! Rollup: SUM(values) but only records that are linked with the current Item

Hi everyone. I have a table "receipts" that collects receipts linked to different projects. Every receipt can only be linked to one project. The Receipts table has a Number Field "Amount in Euro". Now I the Project table, I want to have a Rollup fiel...

4N by 6 - Interface Innovator
Solved
  • 609 Views
  • 5 replies
  • 4 kudos

Calculating Average Time of Day

Hi. I’m looking for a way to calculate an average time of day for an average start time and average end time. Airtable has the date and time field, and the time duration field, butI need the average start time and end time, as separate values.I need ...