Formulas
cancel
Showing results for
Did you mean:

## Formulas Activity

### Trying to organize sales data

Hi everyone!I'm trying to organize my sales data in my Airtable base.I add the data through CSV upload. For every day of sales I add I add a new column to my sales data table.Now I want to run automatic calculations on the data. To give an example: i...

• 6 Views
• 0 replies
• 0 kudos
by 5 - Automation Enthusiast

### I would like to find the cumulative balance by referring to the previous record value.

Hello, I am a user who studies airtable. I would like to inquire about the function of using airtable.In Excel, a fomula can be calculated by referring to previous row (previous record) values.So it's easy to implement how to get the following balanc...

• 31 Views
• 0 replies
• 0 kudos

### Calculate Number of Days between two date fields and exclude weekends

We are implementing time tracking fields in multiple bases and need to calculate the total amount of time between two date fields (in days, hours & minutes) but also excluding weekends and possibly holidays. I've tried the following but the calculati...

• 46 Views
• 1 replies
• 0 kudos

### Need help on something hard to describe

So let's say I have a table that is going to have different numbers in rows listed in a single column, like below.2331618And in another table, I have some ranges filled into two columns, with a min column and max column, and a third column with a nam...

• 93 Views
• 3 replies
• 0 kudos

### Need help with complicated date based formula

Hi all - I need help with this formula as I was able to use Chat GPT to get me close to where I need to be, but it still doesn't work.Can someone rewrite this formula so it works: IF({End Date} > "7/1/2024" , {Latest Revenue Projections} * ("6/30/202...

• 88 Views
• 2 replies
• 0 kudos

### Display a linked field in the Name field

Hi everyone!Following problem: I have a table where each record is represents a deployment of a worker, sick leave, a project or Vacation. We differentiate between them with a single select field. Each record has a start and an end date + is linked t...

• 79 Views
• 1 replies
• 0 kudos
by 6 - Interface Innovator

### Shiftplan with formula and counter

Hi there, im new to airtable and need some help. I would like to create a form in which people can register for a work shift. There are four shifts with a maximum number of participants. For example:Shift A = Max. 5 participantsShift B = Max. 2 parti...

• 81 Views
• 1 replies
• 0 kudos

### Tracking how long a record is stuck in the same status

Hi, does anyone have any tips on how to create a formula that  would calculate the number of days something was in each stage? We track various stage gates for our content: Draft, Proposal, Ready for Production etc. Thanks!

• 97 Views
• 1 replies
• 0 kudos

### Resolved!Recreate UNIQUE function

Hello! Im looking to recreate this function in Airtable=COUNTA(UNIQUE(Masterlist!C5:C))Where the column in Airtable I'm looking to count unique entries in is called CLIENT NAME. Unfortunately, it doesn't look like the UNIQUE function works, is there ...

• 139 Views
• 3 replies
• 0 kudos

### "Modified At" Formula Not In Parity With Revision History

Hi! Currently I have a field which is returning a "Modified At" date. This field is a standard field (no formula) and it is returning the modified date of another field (our "Feedback" field).This is what it is returning in a problematic record:Howev...

• 80 Views
• 0 replies
• 0 kudos