Formulas | Airtable Community

Create a formula that prioritizes 1 field to fill in over another.

Hi,I want to create a formula to create a name for a field that consists of "FIELDA" or "FIELDB" If "FIELDA" has no value i would like to show "FIELDB" in the name instead. If "FIELDA" and "FIELDB" both have a value, I would only like to have "FIELDA...

26 Views
5 replies
0 kudos

Cumlative Annual % of P/L based on Quarterly Field $Amounts

I'm stuck. I need a field type and formula to display the cumulative annual profit or loss (P/L) displayed as a percentage (%) and based on a Q1 starting amount and subsequent amounts entered in Q2, Q3, & Q4 fields.This seemed easy until I got starte...

92 Views
4 replies
0 kudos

How to filter to infinity values

I want to filter to the infinity values but am unsure how to do this. I don't want to remove them using an IF statement or the other tricks you can use to have them become zero or empty values. The first screenshot shows the data and that there is on...

120 Views
2 replies
0 kudos

Upcoming dates, #error, and formatting

I have a [Anniversary] field and a field that calculates the next anniversary, so I get reminders and write a card for my volunteers. Here is my problem:The basic formula works fine when there is an anniversary in the field. When there isn't one, I g...

103 Views
1 replies
0 kudos

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

134 Views
5 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...

136 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...

219 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...

186 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...

238 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 ...

209 Views
2 replies
0 kudos