Help
Formulas
cancel
Showing results for 
Search instead for 
Did you mean: 

Formulas Activity

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

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

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

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

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

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

  • 106 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? 

  • 86 Views
  • 3 replies
  • 0 kudos

How can I assign one expense between various business units?

Hey there! I am trying to allocate monthly expenses across our business units (BUs)  based on pre determined splitting criteria, some of those criteria change month over month, such as the percentage of revenue each business unit is producing. What I...

  • 66 Views
  • 1 replies
  • 0 kudos

Airtable Rollup Field Bug Report

DescriptionThere appears to be an issue with Rollup Fields when used in conjunction with Linking Records and date columns. The problem occurs when the Rollup formula becomes more complex.How to ReproduceCreate a Rollup Field that references a date fi...

icese7en_0-1725930874279.png icese7en_2-1725930944806.png
  • 113 Views
  • 1 replies
  • 0 kudos