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

Formulas Activity

Count how many times a row is linked in another table

Hi everyone!I'm new to Airtable so I need a bit of help.I have two bases with one main table named the same. "Students" and "Mentors"The "Mentors" base is published as a sync table in the "Students" base, and vice-versa.In the "Students" base, I have...

  • 2 Views
  • 0 replies
  • 0 kudos

Updating Airtable IF something new exists in Podio

Hi everyone, Thank you in advance for any suggestions you may have I'm working on creating an always up-to-date Airtable that consists of records being updated in Podio. So within Podio, I have an app with a sheet consisting of people; my colleagues...

  • 2 Views
  • 0 replies
  • 0 kudos

Finding info / Splitting to columns based on delimter?

Hello all, I'm hoping for some help with formulas that will allow me to achieve below. I have scoured all the brilliant responses to similar questions, but none quite meet with this. The format will always be the same but character lengths with vary....

Libby_0-1679731964885.png
  • 15 Views
  • 2 replies
  • 0 kudos
Libby by 5 - Automation Enthusiast

Regex or Subsitute Formula? Or Both?

I have a field that has a ton of linked records and I'm trying to format that into a nice list for use in the Pages extension.  It's generally coming through with commas and quotation marks separating it.  I found this formula in another thread, whic...

  • 41 Views
  • 8 replies
  • 0 kudos

Need help with IF formula for negative numbers

I am trying to have a formula that says the following: 1) If the value in this $ field is greater than 0, 'Do this'2) also, the value in this $ field is 0, 'Do this instead'3) also, if the value in this $ field is a negative number, 'Definitely do th...

  • 25 Views
  • 1 replies
  • 1 kudos

Check if value is added more than once per date

Hi everybody!I'm trying to move our Excel spreadsheet to Airtable to simplify things ans automate something.The spreadsheets is just a list of activity that we need to do (we rent stuff), have a look at the screenshot.Question: is there a way to tran...

24-03-2023_10-36-00_2_Logistica_partenza_CSV_5.csv_-_Excel.png
  • 15 Views
  • 0 replies
  • 0 kudos

Time is wrong in NOW()

I have a formula field containing NOW() and nothing else. The field is showing the wrong time. Right now it's 3:02 a.m. in the desired time zone (Eastern Daylight Time), but the field shows 2:59 a.m. I've attached a screenshot showing the difference ...

  • 23 Views
  • 2 replies
  • 0 kudos

Returning New Entries as a Summary Table

I organize a Run group that uses Airtable to login runners each week, via a form entry from a "Check-Ins" table. This form pulls data (names) from a larger "Runner List" that keeps track of all registered runners that have ever logged in. The "Check-...

  • 27 Views
  • 2 replies
  • 0 kudos

Comparing dates

I am trying to compare dates across 4 different columns. Here is the formula I need help with  - IF(DATETIME_DIFF(({Start (from Roadmap)}, {M's Start Date}) /This is trying to compare dates in two columns OR / This is to ensure the second set of date...

  • 30 Views
  • 2 replies
  • 0 kudos

Correcting Date Translations

Hi there,Using the formulaDATETIME_FORMAT(SET_LOCALE({Clinic Date}, 'es'), 'dddd D MMMM YYYY')to translate dates into Spanish, however, the translations are missing "de" between date, month, year. I'm having trouble adjusting the formula so that date...

  • 26 Views
  • 1 replies
  • 0 kudos

Resolved! Formula to create yearly calendar of dates

Hello,I'm really new to Airtable and completely inexperienced with formula options.I'm looking to set up a formula so I can easily create a list of dates for the calendar year. Right now I used # option but I think a formula is more in line with what...

Estelle_0-1679583596558.png
  • 41 Views
  • 5 replies
  • 0 kudos

When criteria is not met, leave field blank (help)

Hello everyone! I have this formula:  IF(AND(DATETIME_FORMAT({Trækdato (FarPay)}, "D")<10, DATETIME_FORMAT({Dato for udløb}, "D")<10), IF(WEEKDAY(DATETIME_PARSE(DATETIME_FORMAT({Dato for udløb}, "YYYY-MM-10"),"YYYY-MM-DD"))=3, DATEADD(DATETIME_PARSE...

  • 18 Views
  • 0 replies
  • 0 kudos

Character counting with conditions

I am using the LEN(string) function but I want it to exclude commas, is there a way to do that? I have a list of items with commas in between, I would like a character count of the letters but not the commas.

  • 33 Views
  • 3 replies
  • 0 kudos
IIAL by 5 - Automation Enthusiast

How to create a button to call and mail?

I am trying to create a button to make calls and mail using URL "mailto:xyz@abc.com" but I am not able to use that. Can you suggest me something?  The email address and phone number are stored in different columns.

  • 37 Views
  • 0 replies
  • 0 kudos

Help With Rollup (SUM) linking Formula (datetime_diff)

Looking for some help. I have a table were I utilize "last modified time" to be inputed based on the Specific field ("Checkbox").This sequence works well for what I am doing, which is; creating time logs for when we "Start" and "Stop" work on a speci...

  • 40 Views
  • 0 replies
  • 0 kudos

Resolved! How to create list of dates for the year

Hello,I'm completely new to Air Table and very unfamiliar with the available formulas.I want to have rows display dates for the whole of 2023. Yes, a long list of every day of the year. I'm including a picture as an example.I'm sure I can achieve thi...

Estelle_0-1679500930921.png
  • 45 Views
  • 1 replies
  • 0 kudos

Formula to create sequential numbers based on Date field

I am using a Formula field as my Primary Field for a schedule table (each record is a time slot).Among my formula for naming each time slot, I would like to add a number (ie. 001, 002) which is generated based on the Date field.ie. Record X: March 5,...

  • 24 Views
  • 1 replies
  • 0 kudos

Resolved! Replace "," by "&" in a lookup field

Hi there! I've been trying to replace  "," by "&" in a lookup field using Substitute and IF statements but I still receive an error or the result is not giving me what I want. So the result I want is IF First name contains  "," then replace by &..  

Yvia_0-1679407184729.png
  • 52 Views
  • 6 replies
  • 0 kudos
Yvia by 5 - Automation Enthusiast
Solved

Add 5 Days to a date field while skipping weekends

I am trying to create formulas that skips weekends, showing 5 days after a date field called Sendt (and then two other formula fields for 14 days later and 30 days later)I tried using the workday function, however it is displaying a Sunday, as you ca...

  • 46 Views
  • 2 replies
  • 0 kudos