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

Formulas Activity

Find duplicates in a rollup

Hi there - I schedule shipments to be picked up on specific dates from specific sites at specific times, and I need a way to identify if I've scheduled any shipments to be picked up on the same date/site/time to make sure I'm not double booking a sit...

  • 94 Views
  • 5 replies
  • 0 kudos

Formula for date that cell was updated

Hi, is there a formula to pull the date that a specific cell was updated?For context; I use Airtable to confirm bookings for my business, and do weekly reports on these. The reporting is currently based on 'created date' as I only add them to the sys...

  • 169 Views
  • 10 replies
  • 0 kudos

Resolved! Query data from another table

I have two tables:Table one shows a list of tasks done on different computers and when the task has been marked as finished:TaskId, FinishDateTime, Computername.In table two I have information who was logged in when on on which computer:DateTimeStart...

  • 128 Views
  • 3 replies
  • 0 kudos

REGEX Combining multiple columns as comma separated

Hi community,I have a formula to combine emails from multiple columns, that generally contain multiple linked records (but not always).  This REGEX formula works really well for the first 3 columns, but is failing on the final.  Any help on what I'm ...

  • 89 Views
  • 2 replies
  • 0 kudos
KFIL by 5 - Automation Enthusiast

Resolved! Find and replace specific line and turn into UPPERcase

We have a load of addresses in a database. They are individually pasted into a Long Text field.The issue:Some addresses are in this format - 51A Wigton RoadCarlisleCA2 7AYAnd some addresses are in this format- 51A Wigton RoadCARLISLECA2 7AY So the di...

  • 87 Views
  • 2 replies
  • 0 kudos
DM115 by 5 - Automation Enthusiast
Solved

Forecasting Help

Hi Everyone,I am trying to create a forecasting table that will tell me how many months of cover I have based on current stock on hand. In the image you can see the fields Sock Holdings and Outbounds Forecast. What I need is to create a field where I...

lachlanmclean_0-1731018463597.png
  • 110 Views
  • 3 replies
  • 0 kudos

Resolved! Airtable App not working with prefilled forms

Hello!I'm using a prefilled form URL field. When a customer submits a button it opens the prefilled form in the corresponding URL field.The problem is that it works perfectly on desktop, but when using App, the prefilled form formula does not work.Is...

  • 111 Views
  • 1 replies
  • 0 kudos

Resolved! DATETIME_DIFF gives wrong number of months

I am trying to calculate the number of months between today's date and the "Test Date" field. When I use the DATETIME_DIFF formula it does not calculate it correctly for all values.  In the Test copy column I have this formula:DATETIME_DIFF({Test Dat...

Screenshot 2024-11-07 at 9.05.34 AM.png
  • 170 Views
  • 3 replies
  • 0 kudos

View field in form based on previous data

Hi, I' trying to figure out something with the form.I need my salesteam to submit sales info in the form.Lets suppoer we have to submit 2 field:1) sale price2) costI would like that after the user typing the 2 infos above, a field called "profit" wil...

  • 108 Views
  • 2 replies
  • 0 kudos