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

Formulas Activity

Resolved! Return a numerical value based on a Single Select Dropdown

Hi there. I'm trying to create a formula that returns a numerical value (price) based on a dropdown field. So, if "Option Zebra" is selected in the dropdown, the formula returns a value of 250. If "Option Lion", then the formula returns a value of 30...

  • 27 Views
  • 3 replies
  • 0 kudos

Formula to return text and URL

I have a table of books with the following columnsBook Titleyear publishedAmazon LinkBookshop.org LinkI want to create a field that returns Book Title (Year Published) Amazon Bookshop, where the "Amazon" is linked abd "Bookshop.org" is linked.Is it p...

  • 31 Views
  • 3 replies
  • 0 kudos

FilterByFormula - Exact match for Multi-Value Columns

Hello Airtable Community!I'm facing a challenge with constructing a filterByFormula and came across a similar issue discussed here: https://community.airtable.com/t5/formulas/formula-with-multiple-values/td-p/174768.I have a column named Klasse, whic...

  • 88 Views
  • 3 replies
  • 0 kudos

Formula to show the date on which a certain threshold was crossed

Hey there,Thank you for your time helping me !So i'm a mushroom farmer. I cultivate different batchs simultaneously. Each time I harvest one, I create a record for it, with the date of harvest, the batch harvested and the weight harvested. There is a...

  • 84 Views
  • 3 replies
  • 0 kudos

Extract data from a form email

Hi, we receive form emails in our airtable base. what's the best regex to use to extract information?Email looks like this:*Your Name* Jane Doe*Organization* Best Company*Your Job Title* Sales Manager Thank you!

  • 96 Views
  • 5 replies
  • 0 kudos

Resolved! Formula to validate single-line text field input

I need a formula to verify a single-line text field only contains productId's separated by commas with <=30 comma separated productId's.OK: <=30 comma separated 8-character productIdsNot OK: >30 productId's; <8 or >8 character productId's, not comma ...

  • 226 Views
  • 4 replies
  • 0 kudos

Resolved! Rollup: attributing value to multiple sources

Hi there,I have a team of account executives and I'm trying to rollup the amount of revenue each person manages during a 12-month period. Revenue is generated on a per project basis. Each project has a start and end date and a monthly retainer fee, w...

Screenshot 2025-02-14 at 9.14.39 AM.png Screenshot 2025-02-14 at 9.22.39 AM.png
  • 205 Views
  • 4 replies
  • 0 kudos