The Airtable Community will undergo scheduled maintenance on September 17 from 10:00 PM PST to 11:15 PM PST. During this period, you may experience temporary disruptions. We apologize for any inconvenience and appreciate your understanding.

Formulas
cancel
Showing results for
Did you mean:

## Formulas Activity

### Help with Formula to calculate milestone date

Please help I need a formula for reoccurring seasonal milestones.  We have seasonal launch dates and milestones in each season that occur at intervals;  -130 wks, -80 wks, -56 wks.  I want to calculate the due date of the milestone based on season la...

• 22 Views
• 1 replies
• 0 kudos

### Resolved!Single select based on 2 different fields

Hi guys,Hey, guys,Please help me solve a problem - I have a table of tennis matches, which has fields Player 1 and Player 2, which are linked to another table Players. In the matches table next to the Player 1 and Player 2 fields, I want to add a sin...

• 81 Views
• 3 replies
• 0 kudos

### Rollup or Sum in Sheet B of Numbers in Sheet A (when name matches)

Hi all! I am attempting to utilize data from "Sheet A" (specifically item names and quantities) and SUM the "Quantity" in "Sheet B" when the "item name" from Sheet A matches the "item name" from Sheet B. Is this possible in Airtable? I've played arou...

• 68 Views
• 1 replies
• 0 kudos

### Resolved!Script for combining information from multiple single select fields

Hello community! I have 15 separate single select fields with the possible answers of: 1. Firsts2. Second3. Third4. No Preference 5. I do not select this UWC I would like to create the individual columns "First" "Second" "Third" "No preference" and h...

• 90 Views
• 1 replies
• 0 kudos

### Help Creating a Script to Match Volunteers to Elders Using Scripting

Hello All,I've been attempting to create a more efficient way for my organization to sort through volunteers and create a matching system to the elderly. So far, I've created two main tables: Volunteers and Old Friends that are populated by a use of ...

• 100 Views
• 1 replies
• 0 kudos

### Button wont pass data on mobile

I'm using a public airtable view with a button that passes data to a web form. Works on desktop but not on mobile.looks like this: "https://myurl.com/bid?bid=" & ENCODE_URL_COMPONENT({Deal Name}) & "&new=" & ENCODE_URL_COMPONENT({Current Bid Value}) ...

• 91 Views
• 1 replies
• 0 kudos

### How to hyperlink text inside a formula?

Hello,I'd like my formula to spit out a paragraph of text. Some of the text within the formula, I'd like to include hyperlinks. Is this possible?Here's an example:If field A = option 1, spit out this text:Lorem ipsum dolor sit amet, consectetur adipi...

• 107 Views
• 2 replies
• 0 kudos

### Next Reminder Date in Airtable ?

Hi All, I am trying to build a Reminder portal to track some key dates within Airtable and was wondering how in Airtable can I use Formula or if there is any other way to find the date that is due to come from a range of dates (sample data below - I ...

• 72 Views
• 1 replies
• 0 kudos

### Formula field creates new records

I have a formula field that gives me a date.then I have a normal date field "current". For example, if I enter a date in the "Current" date field, then the formula field should calculate 2 years from this date and give me the date in 2 yearsExample: ...

• 115 Views
• 2 replies
• 0 kudos

### Rounding or Precision Issues

If you're working with numbers and formulas are returning different results, rounding differences or precision errors could be the cause.Solution:Ensure that both formulas are using the same precision (number of decimal places).Use the ROUND() functi...

• 89 Views
• 1 replies
• 0 kudos