Formulas | Airtable Community

Sorting entries by week # - formula not correct

I am trying to sort by the Week # of the year that an entry is assigned on my base. Its sorted by year, then by week - so 2024, week 1 through 52, etc.However, for anything this week up until the 31st, its showing up as the 1st week of Dec 2024 (whic...

61 Views
2 replies
0 kudos

Formula error in grid view

Hi,I've created a formula to calculate my patients' current age based on their date of birth (Lookup field). When I look at the record in grid view, it gives me an error message, but when I check the formula for accuracy, the calculation preview give...

79 Views
2 replies
0 kudos

Resolved! Gathering Data from 1 Table into Another

Hello--We're developing an Affiliate program where the affiliates offer a free month on our app. We're gathering new user data from Typeform forms that are automatically dropping in the information into different Airtable sheets as shown below.I'd li...

156 Views
5 replies
1 kudos

Resolved! Issue with Counting Linked Records in Airtable

Hi everyone, I’m facing an issue with counting linked records in Airtable, and I’d love your help! I’ve created two tables for managing group interviews:1. “Entrevues Dispo” (Interview Slots) – Tracks the availability of each interview slot.2. “Entre...

174 Views
2 replies
1 kudos

Resolved! Filtering

I am new to the free version of Airtable which I am using to keep track of my craft stamps. I have at the moment around 500 items which have sentiments listed. When I try to find a particular sentiment I search for eg has any of, but it gives me "ent...

205 Views
6 replies
1 kudos

how do you retrieve the actual attachment document when rollup only displays the internal URL?

When I do a rollup to get the unique documents, it is correctly retrieving just the unique values - but while a lookup brings up the actual attachment documents, the rollup displays Airtable's Internal URL for the document.How do I then retrieve the ...

193 Views
2 replies
0 kudos

Use value from row 1 in row 2 without automation

Hello dear community,I have already searched but found nothing. I want to use a value from one row (for example, row 1) in a formula in row 2. In row 2, the value from row 1 should be used minus the value from row 2 (same field). How does that work?A...

236 Views
5 replies
0 kudos

Populating a field with data from another table when fields from two different tables are the same.

I have a base with two tables: Employees and Projects.Employees has a primary field of Employee ID and Project IDs.Projects has a primary field of Project ID, Project Manager(s), and Status.In the Employees table I want the field "Project IDs" to be ...

180 Views
5 replies
0 kudos

Timezone not Populating in Fillout PDF correctly

I created a form for our rental car contract in Fillout. Everything is populating correctly into airtable except the time. My issue is that I put the "date - time out" in the form eg 12/19 8:00pm. It will populate to airtable as 12/20 3:00am if I hav...

368 Views
2 replies
1 kudos

Resolved! Wanting to show correct quarter and fiscal year

I have this formula for calculating the quarter and the fiscal year of when an invoice should be paid.Program Start date is 7-4-2024 (which is Q3). I want it to be paid the quarter after (so this one would be be paid Q4, FY24) but its showing Q3 - FY...

253 Views
4 replies
0 kudos