Help
Formulas
cancel
Showing results for 
Search instead 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
UrbnJ by 5 - Automation Enthusiast

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

Screenshot 2024-05-15 at 11.00.00 AM.png Screenshot 2024-05-15 at 11.01.48 AM.png
  • 80 Views
  • 0 replies
  • 0 kudos