Formulas | Airtable Community

Resolved! Date Add formula, but with specific parameters

Hello!I am wanting to add a DATEADD formula to my base to set deadlines for different tasks based on a hiring date. I've done this in a previous base, but have since lost access. Can someone help me with the formula I need? For reference, some of the...

17 Views
6 replies
0 kudos

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

37 Views
6 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...

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

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

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

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

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

239 Views
6 replies
1 kudos