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

Forum Posts

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 4 - Data Explorer
  • 102 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
  • 127 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
  • 186 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
  • 349 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
  • 289 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
  • 400 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 ...

Resolved! Formula to display most recent input based on multiple field

Hi there - I am looking to create a column that will essentially lookup the field values of columns Q1 - Q4 and output the latest number.We input quarterly projections and want to be able to identify the most recent number by looking at 1 field ("lat...

ta2530 by 5 - Automation Enthusiast
Solved
  • 185 Views
  • 2 replies
  • 0 kudos

Resolved! Table for Long Text field

Can I add a table to “long text” field?I want to add table that include columns " code - description - price" example:code - description - price“1167 - bike tire - 75”

Pulling pieces of information from one field to another

I currently have a 'Date' field that shows year, month and date. I am trying to create a new 'Year' field that is just for the year. Is it possible to create a formula or automation that allows for my new 'Year' field to automatically pull the year f...

ivy by 4 - Data Explorer
  • 181 Views
  • 1 replies
  • 0 kudos

Having birthdays show up on a calendar view in Airtable

I have a field where people can enter a birthdate. I want that to show up on a calendar view in Airtable. Unless the year is the current year, it's not showing up on the calendar. I tried using a formula field but then I can't get the formula field t...

akidz2 by 4 - Data Explorer
  • 147 Views
  • 0 replies
  • 0 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
  • 192 Views
  • 0 replies
  • 0 kudos

Date is just ... inexplicably wrong (today() formula)

I have a complicated string of formulas that is setting due dates. The short of it is I have a "complete" column (checkmark) and "Date completed" (static field). A task is completed and marked with a checkmark in complete where it stays visible all d...

list all records mathing a condition in another linked table

Hi to all,This is my question:I have a table "table#1" whith a list of records. In this table i have a colum named "project" of type Link with 'allow multiple link', linked to another table "Table#2" with a list of project.In another table "Table#3" ...