Showing results for 
Search instead for 
Did you mean: 

Formulas Activity

Resolved! Phone Number to Plain Text Formula

Hello, I think I need a help of Airtable community even though there is built in AI helper in the formula field. Here is what I am trying to do and have no success for some unknown for me reason. I'm creating an automation that with the click of the ...

  • 2 replies
  • 0 kudos
bedjik by 6 - Interface Innovator

Help with Scripting to Add Totals by Commercial and Year in Airtable

Hello Airtable community,I am working on a project where I need to automate some financial reports in Airtable and I would like to ask for your help to solve a specific challenge related to conditional sums in several tables.Context:I have a base wit...

  • 1 replies
  • 0 kudos

Resolved! Formula between dates

Hello - I have a date column of when an event will occur (Showcase Date) & I am wanting a formula to populate deadlines based on number of days before or after this date. Here is the formula I created but it is not working. Any suggestions? I have tr...

  • 2 replies
  • 0 kudos

using sum values in grouped fields for other formulas

How do I use sum values automatically calculated when grouping fields for other formulas?I have to calculate the sum of values of a grouped field in other formulas. Is it possible? someone told about rollup, but I did not manage to obtain any useful ...

Screenshot 2024-04-12 alle 13.06.15.png
  • 6 replies
  • 0 kudos

Resolved! Help with Formula

Hello, wondering if someone could help me correct the formula in the photo.  I am hoping for this to happen:If OLD JOB# is blank, display current 2 digit year (CREATED DATE) & "-" & 4000 + ID#. If OLD JOB# is NOT blank, display OLD JOB#For example, l...

Screenshot 2024-04-10 at 10.40.57 PM.png
  • 3 replies
  • 0 kudos

Date Formulas

Hi there,Wondering if anyone could help me with a couple of formulas.I have an existing date field (DD-MMM-YY) and I want to create deadlines from this field as follows:1.  23rd day of the 9th month after this date; example - where source field is 31...

  • 3 replies
  • 0 kudos

Title case

I have a column of text I need to convert in to title case for an import into another system.Is there a way to make this title case with Regex?There is things like:"PREPARE FOR PRINT""BLUE/GREEN""WHITE / BLACK"Anyone know if this is possible?

  • 1 replies
  • 0 kudos