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

Formulas Activity

Automate tick box and Your result type is not a number or a date.

Hello,So currently, we do have a tick box on this view and manually tick it once it is the latest valuation.Do you have any ideas on how can I automate this? without doing the manual ticking?Another issue, I created this formula : IF({latestVal Date}...

Screenshot 2023-06-01 at 12.45.00 PM.png Screenshot 2023-06-01 at 12.47.30 PM.png Screenshot 2023-06-01 at 12.49.51 PM.png
  • 55 Views
  • 4 replies
  • 0 kudos

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

  • 37 Views
  • 1 replies
  • 0 kudos

Resolved! How to 'hide' incomplete, linked parent task from a view

I hope this is the right place for this question, but we'll see!Context: We have a 'Tasks' table where each team member may have a list of hundreds of tasks (thanks to the joys of generating task templates). I would like to have a View for users that...

  • 37 Views
  • 2 replies
  • 0 kudos

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

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

  • 27 Views
  • 2 replies
  • 0 kudos

How to copy a value from last row to all column

Hello,I am working on a property management system and there are contracts in two currencies. For all the data to make sense I need to convert the dllr contracts information to pesos with the current exchange rate. In the table where I have inflation...

Screenshot 2023-05-30 at 21.31.47.png
  • 41 Views
  • 1 replies
  • 0 kudos

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

  • 58 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? 

  • 76 Views
  • 3 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...

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

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

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

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

  • 73 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
  • 118 Views
  • 5 replies
  • 1 kudos