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

Formulas Activity

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

  • 31 Views
  • 2 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...

  • 38 Views
  • 2 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!

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

  • 214 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
  • 194 Views
  • 4 replies
  • 0 kudos

Resolved! Formula calculation using date fields

I am using a formula to calculate a date in one field, and then trying to use another formula field to determine whether a contract is current, future, or expired using that date and another manually entered date field.  The field I'm using to determ...

Screenshot - 2_13_2025 , 11_08_53 AM.png
  • 86 Views
  • 1 replies
  • 0 kudos

HELP WITH FORMULAS

I am trying to build a table to calculate pricing. But, every column (which is its own product) has different price points under it, based on square footage. How can I set up a formula that will calculate each drop-down option (multiple selection), p...

  • 378 Views
  • 2 replies
  • 0 kudos