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

Forum Posts

Creating Goals by Increasing a Number by a Set Percentage

I am trying to generate sales goals in a formula, I have a column with the previous years result (manually entered), I have a % column with my growth target but I cannot figure out how to create a column with a formula that takes the previous result ...

Screenshot 2023-05-31 at 9.20.14 PM.png
nicole_e by 1 - Visitor
  • 20 Views
  • 1 replies
  • 0 kudos

Calculating Due Dates

Hello!I am creating a list of tasks that need due dates assigned using the following conditions:1. Each task is due one day after the previous task is due (note: dependencies would be nice to have but not necessary)2. The tasks are never due on Frida...

Rollup from Multiselect - Expense Calculator

I am trying to create a tracker for trip expenses. I have a list of Attendees in one table, then Receipts in another with a "Charge To" field (since sometimes expenses wont be shared evenly across the group) that is a link to the Attendees table. Wha...

treverr by 1 - Visitor
  • 21 Views
  • 0 replies
  • 0 kudos

Count of records, matching a criterion, for a group

I have a table named Licenses with a Current? field [Yes|No].  The table is linked to the Employees table by the Employee # field. For each Employee, there could be a License record with:zero or many rows where Current? is Nozero or one row where Cur...

craibuc by 4 - Data Explorer
  • 22 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

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? 

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
hristovm by 5 - Automation Enthusiast
  • 109 Views
  • 5 replies
  • 3 kudos

Resolved! Formula for cutting out numeric values

Hi there! This is a very newbie question, but is there a formula for cutting numbers out of a string? For example, if I have the value 01 Lorem ipsum and I want it to read Lorem ipsum what formula would I use?

Josh_Colina1 by 5 - Automation Enthusiast
Solved
  • 750 Views
  • 11 replies
  • 5 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...

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

MCC by 5 - Automation Enthusiast
  • 54 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...

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

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

NitaiLS by 5 - Automation Enthusiast
Solved
  • 113 Views
  • 7 replies
  • 2 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...

Eli_Kent by 7 - App Architect
Solved
  • 70 Views
  • 2 replies
  • 0 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
cam by 5 - Automation Enthusiast
Solved
  • 113 Views
  • 6 replies
  • 1 kudos