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

Formulas Activity

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

  • 56 Views
  • 2 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...

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

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

  • 61 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! 

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

  • 94 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
  • 59 Views
  • 0 replies
  • 0 kudos

Resolved! Different timezone with automation from google sheet to AT

Hi guys!I'm using Ubiqod for attendance tracking in our company. When you scan code, you click on the correct button (arrival, break, going home). After you submit it, the data comes to google sheet and with automation it gets to the Airtable. Now th...

SpelaU_0-1715776296498.png SpelaU_1-1715776335812.png
  • 78 Views
  • 2 replies
  • 0 kudos

Suggest a Retail price to match the profit margin

Hi all,Struggling with this one and I'm not sure if it's even possible.I have a table that works out total cost of a product, total cost of a product inc fees on Etsy total cost of a product inc fees on shopify.Etsy fees are always higher than shopif...

  • 62 Views
  • 2 replies
  • 0 kudos

Resolved! Formula - No text format available?

Hello,I have a very simple request.I simply need to generate a formula to compute the first and last name of my contacts.However, as simple it is, I do not have the text format in the formatting bar. Only Number, Currency, Percent and Duration.Then i...

  • 105 Views
  • 2 replies
  • 0 kudos