Help

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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Formulas Activity

Create a Post

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

  • 65 Views
  • 3 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...

  • 86 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}) ...

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

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

  • 70 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: ...

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

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

  • 145 Views
  • 5 replies
  • 0 kudos
Load more
Airtable Community Guidelines
Looking for tips before asking a question? Make sure to review our Airtable Community Guidelines for best practices.
Labels
Copyright © 2024 Khoros, LLC