Formulas
cancel
Showing results for
Did you mean:

## Formulas Activity

### Help with Scripting to Add Totals by Commercial and Year in Airtable

Hello Airtable community,I am working on a project where I need to automate some financial reports in Airtable and I would like to ask for your help to solve a specific challenge related to conditional sums in several tables.Context:I have a base wit...

• 18 Views
• 1 replies
• 0 kudos

### Can someone tell me what this formula string would look like?

Hi All I would like to know if someone can assist me with create the formula used in the time off id column for this video at the timestamp 2:04 https://www.youtube.com/watch?v=Q-MEmIHCHU4&t=8s

• 19 Views
• 0 replies
• 0 kudos

### Resolved!Formula between dates

Hello - I have a date column of when an event will occur (Showcase Date) & I am wanting a formula to populate deadlines based on number of days before or after this date. Here is the formula I created but it is not working. Any suggestions? I have tr...

• 84 Views
• 2 replies
• 0 kudos

### Be able to show the previous value for a date field in a formula field....

Hi All! I am hoping this is an easy problem to solve I thought this would be really simple, but I'm struggling.I have a project "Start Date" field. Every time one of my users updates that "Start Date" I would like AT to automatically retain the last ...

• 74 Views
• 4 replies
• 0 kudos

### using sum values in grouped fields for other formulas

How do I use sum values automatically calculated when grouping fields for other formulas?I have to calculate the sum of values of a grouped field in other formulas. Is it possible? someone told about rollup, but I did not manage to obtain any useful ...

• 65 Views
• 6 replies
• 0 kudos

### Resolved!Help with Formula

Hello, wondering if someone could help me correct the formula in the photo.  I am hoping for this to happen:If OLD JOB# is blank, display current 2 digit year (CREATED DATE) & "-" & 4000 + ID#. If OLD JOB# is NOT blank, display OLD JOB#For example, l...

• 104 Views
• 3 replies
• 0 kudos

### Date Formulas

Hi there,Wondering if anyone could help me with a couple of formulas.I have an existing date field (DD-MMM-YY) and I want to create deadlines from this field as follows:1.  23rd day of the 9th month after this date; example - where source field is 31...

• 990 Views
• 3 replies
• 0 kudos

### Title case

I have a column of text I need to convert in to title case for an import into another system.Is there a way to make this title case with Regex?There is things like:"PREPARE FOR PRINT""BLUE/GREEN""WHITE / BLACK"Anyone know if this is possible?

• 281 Views
• 1 replies
• 0 kudos

### Calculating the % of Payments completed where payments are checkboxes

Hiya all! So, I am trying to create a formula that uses each of the checkboxes in my table as a way to track payments that have come in. I need each checkbox to equal/represent to the amount listed in the {Payment Amounts} column and for the number o...

• 206 Views
• 7 replies
• 0 kudos

### Resolved!Copy the info from one field to a formula field, and add todays date on

Morning! This is probable really simple...but I'm struggling to find the formula i need and wondered if you lovely people could assist please?Basically I'm trying to add a date in a formula output, so if the ccf column has a number in it copies the n...

• 86 Views
• 2 replies
• 0 kudos