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

Formulas Activity

Help with nested if/and formula

Hi there -  I am attempting to track contract breach status (pending, resolved, or n/a) depending on the source of the breach and whether there is a specific response date. My formula will be 5 if statements, of which 4 are also if/and. I've been abl...

Screenshot 2024-11-14 165257.png
  • 6 Views
  • 0 replies
  • 0 kudos

Replacing \n with carriage returns

Hi all, I am importing JSON into Airtable and parsing it into fields using REG_EXTRACT.Some of the JSON data are blocks of text that have "\n" (without the quotes) in place of carriage returns. Airtable treats the \n as text rather than carriage retu...

  • 57 Views
  • 1 replies
  • 0 kudos

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

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

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

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

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

  • 117 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
  • 158 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...

  • 136 Views
  • 1 replies
  • 0 kudos