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

Formulas Activity

DATETIME_FORMAT returning wrong time - 24hours system

I am struggling to get the DATETIME_FORMAT to return the correct time for me. For example, my Start Date is 10 January 2023 00:00 and in my formula column, I just want it to extract the time of the "Start Date". So I put in this formula: DATETIME_FOR...

  • 33 Views
  • 1 replies
  • 0 kudos
MCC by 5 - Automation Enthusiast

Increase field number one when automated date field changes

My table is for students in a tutoring program.  One field is their current grade.  Another is the calculated formula of today's date.  Every August 15th (each year) I want each student's current grade to increase by 1.  Is there a way to do this? 

  • 46 Views
  • 2 replies
  • 0 kudos

Resolved! Holidays - days remeaing counter

hello, I'm trying to make a table where employees upload two dates through a form, when they go on vacation and when they return.So far so good, I was able to make a formula that counts the weekdays and these are subtracted from the number of availab...

  • 56 Views
  • 1 replies
  • 0 kudos

Functions to pull in client email

I will preface with saying I have a hard time with functions. Not my brain thing. So, as much as I have searched for solutions I suspect my search terms weren't correct enough to find the answer. So I am hoping someone here can help.I need my email c...

  • 44 Views
  • 1 replies
  • 0 kudos

Multi-Variable Formula for Calculating Attribution of a Sale

Hello Airtable friends.I have a somewhat simple formulaic excel sheet that becomes very complicated when breaking it up to be used in Airtable.The goal:Based on the type of sale, each of 6 static 'sale stages' should have defaul percentage (out of 10...

  • 74 Views
  • 3 replies
  • 1 kudos

Resolved! regex email validation doesn't work

Hi,I'm trying to validate customer's mails, to send them automated mails.I created a column validating another Email column in my relevant table, but the formula shows me that the mail doesn't match the regex, even though I know it's a working mail.t...

  • 103 Views
  • 7 replies
  • 0 kudos

Resolved! strange behavior using a lookup in a DATEADD formula

Hi all, I figured out an easy workaround, but trying to understand why this is happening.I have three table that matter to this scenario - Employee, Certificate, and EmployeeCertificate (junction table)The Certificate table has a number field {Period...

  • 63 Views
  • 2 replies
  • 0 kudos

How to check if a date is a weekend or a holiday?

Hi expert guys and gals, I am struggling with what appears to be a straightforward mundane issue, but I have scoured the Community and the internet without any luck. I have workers schedules and sometimes they work Monday to Friday, but sometimes the...

hristovm_0-1685143068898.png
  • 70 Views
  • 2 replies
  • 1 kudos

Resolved! Formula in primary field - create record via API (Make) - NaN value

Hello,I am experimenting with Airtable and Make, but I have a table with a Primary key which is a Formula field.I am trying to create a record in Airtable with this primary key as a formula, but the primary key is populated with NaN value.Isn't suppo...

Screenshot 2023-05-26 at 12.19.08.png Screenshot 2023-05-26 at 12.19.00.png
  • 94 Views
  • 6 replies
  • 0 kudos
cam by 5 - Automation Enthusiast
Solved

Unique filter

I have read a few discussions on Unique filter - lookup then roll up. But i really can't seem to figure it out. I have my calendar synced - then I have a column of attendees, which is linked to companies. So each row has the different company in the ...

  • 119 Views
  • 2 replies
  • 0 kudos

Circular reference error when trying to make my formula

Hi all !To explain my project : I want to make a task manager where tasks can be dependant to each other (for example a task will start when the previous one end, and so if I change the end date of this previous task, the start date of the task will ...

Benoit_Lorent_0-1685022089060.png Benoit_Lorent_4-1685022541185.png
  • 49 Views
  • 0 replies
  • 0 kudos

Trying to create an "averageif" in airtable

Hello team! I am trying to calculate the average weekly attendance in airtable. I downloaded the data from airtable and was able to calculate it in excel using an "averageif" function but I am not sure how I can implement it in airtable. The last col...

cs_0-1684959715206.png
  • 100 Views
  • 5 replies
  • 0 kudos
cs by 4 - Data Explorer

Display if the field has a number

I'm working with some data coming from another group and they use both text and dates in a fields that I need to pull apart and use the dates to estimate further due dates down the line. I'm trying to avoid the big #ERROR! when the field has text and...

fields.jpg Formula.jpg
  • 89 Views
  • 3 replies
  • 0 kudos

Tomorrow Formula

Hi, does anyone know how to make a formula that shows tomorrow's date?We send out an automated message with instructions to the team for tomorrow, and we want to be able to say "You appointment time for tomorrow, {tomorrow's date}"Thanks!

  • 83 Views
  • 1 replies
  • 1 kudos

Resolved! Find completion sprint from string

Hello Airtable community!I have created a Jira integration with Airtable. There is a field for Sprint, however, if a ticket was included in more than one sprints, all sprints appears seperated by commas. I want to extract only the sprint that is the ...

Menia_Laina1_0-1684531671043.png
  • 185 Views
  • 4 replies
  • 0 kudos

Button field - clickable telephone link

It appears that "tel:" hyperlinks does not work to create a button that opens a URL to call a phone. The button is not clickable.However, the "mailto:" URL shortcut works, but not "tel:"Are there any workarounds to this that will put a clickable link...

Ian_Ayers_0-1684510354279.png
  • 252 Views
  • 1 replies
  • 0 kudos