Formulas | Airtable Community

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

9 Views
0 replies
0 kudos

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

40 Views
0 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 ...

88 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}) ...

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

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

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

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

74 Views
1 replies
0 kudos

Resolved! Multiple nested if statements giving me problems

Im trying to write the same formula I have in excel in to Airtable and Airtable erases everything but the first if(and()) statement. IF({Statement} = 1, "3", IF(AND({Statement2}<=50, {Statement2>0),1), IF(AND({Statement2}>50, {Statement2}<=10...

125 Views
5 replies
0 kudos

Formula and Linked?

Is there any way to use formulas and linked at the same time? I want a column to add data from the columns A + B + C to = ABC and then have ABC show up on a different tab. Is that possible?

99 Views
3 replies
0 kudos