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

Formulas Activity

Add 5 Days to a date field while skipping weekends

I am trying to create formulas that skips weekends, showing 5 days after a date field called Sendt (and then two other formula fields for 14 days later and 30 days later)I tried using the workday function, however it is displaying a Sunday, as you ca...

  • 27 Views
  • 2 replies
  • 0 kudos

How to set a date based on a single-select field

I am trying to create a payment due date based on adding days (either 15 or 30) depending on what kind of vendor type is selected. Both 'if' parts of the formula work if I place them in separate formula fields but I would like this to all come throug...

  • 29 Views
  • 3 replies
  • 0 kudos

SUM formula returning negative currency values - why?

Hi Airtable Wizards, I have the following formula which is formatted in currency and occasionally returns a -$0.00 result, where to my untrained eye, I cannot see why.  {PM: TOTAL BANK ALL EFTPOS}-{PM: TOTAL EFTPOS SALES}"PM: TOTAL BANK ALL EFTPOS" a...

  • 22 Views
  • 2 replies
  • 0 kudos

Difference in attachment url

Hi, I have many rows with multiple attachments. Some attachment urls are having https://v5.airtableusercontent.com/v1/ format. Some of them have https://dl.airtable format.How do i tweak the script if possible to get https://dl.airtable format? I nee...

  • 56 Views
  • 4 replies
  • 0 kudos

Creating a default message for a field if it's left empty

Hello! I'm creating an Airtable form, and I want to enable a default text to fill in a field if the field is left empty by whoever is filling the form. Example if name is not filled in, then it will default to anonymous instead of being blank. How do...

  • 51 Views
  • 4 replies
  • 0 kudos
cbg by 4 - Data Explorer

Need help creating a formula

Hello All,I am trying to figure out how to perform a calculation if possible.I have jobs that are sorted by date. Currently, data is grouped by date. I want to take the flat rate for example $500 and divide that by the number of jobs. So that I can h...

  • 31 Views
  • 1 replies
  • 0 kudos

Resolved! CONCATENATE with prefix for multiple values in the column

If you look at my attached images below, I'm struggling with the CONCATENATE function. I want to add the COMPANY as a  prefix to each of the multiple items listed in the PRODUCTS column, but concatenate only adds it as prefix to the first item.I am d...

airtable 1.png airtable 2.png
  • 38 Views
  • 2 replies
  • 0 kudos

Day of Week and Date

How can i create a field that reads, for example, "Friday March 17, 2023" ?

  • 29 Views
  • 2 replies
  • 0 kudos

Resolved! Create URL for filtered Gantt view?

Hi, I'm trying to create a formula that will direct to a Gantt view filtered by a ProjectID field (So I can create a "Open Gantt Chart" button in an Interface using the "go to url in record" action that will open a Gantt view filtered by a specific p...

  • 41 Views
  • 4 replies
  • 0 kudos

Formula returns "true" if number field divides exactly by 180

I'm trying to build a formula that returns "true" every 180 days (and subsequent 180 days) after a record was created.  I'm heading down a very complicated route involving dividing  {Days Since Created}/180 and checking the length of the return resul...

  • 26 Views
  • 1 replies
  • 0 kudos
BobH by 5 - Automation Enthusiast

Filter records based from a certain time to a certain time

HII have  "Creation Time" column for my records. The records are created when user submits the form.Everyday at 9 am or 10 am in  morning meeting, i need to show all records created between  " Yesterday 8am to Today 7:59am".Is there a formula to achi...

  • 26 Views
  • 0 replies
  • 0 kudos

Resolved! Question re using Substitute

I imported a financial report from PayPal. All of the Negative amounts in the "Amount" field use a "-" in front of the value. I want to create a new field that removes the "-" and just lists the value of the Amount field.  If the amount doesn't have ...

  • 58 Views
  • 3 replies
  • 0 kudos

Resolved! IF statement with first day of 6 months ago

Hello everyone, I'd like to make a formula with an IF statement that shows "OK" if a date is in the last 6 complete months. For example, if today is the 17th of March, it would show "OK" for every record since the 1st of September.Is this something p...

  • 39 Views
  • 2 replies
  • 0 kudos

Rollups: geting array values

I am trying to figure our how to use rollups. Let's assume I have a list of applicants and associated interviews. The interview has "interviewer name" field.Soapplicant1 -> (interview1; interview2)Interivew1: JohnInterview2: RebeccaI am creating a ro...

  • 27 Views
  • 0 replies
  • 0 kudos

Resolved! Multi-year "Season" off date range

In the theatre world our "fiscal years" are actually seasons that start in the fall and end in the spring.  And specifically, there are two big "quarters" = a fall/spring season, and a summer season. More complex than just "quarter 1" plus "year." an...

  • 43 Views
  • 3 replies
  • 0 kudos

Average based of single select options

Hi! I need help creating a formula and not sure if it is possible. I have a table that has several tasks with a single select option of completed, missing, or n/a. I want to get the average score of the tasks that are marked as completed. Example: Ta...

  • 27 Views
  • 1 replies
  • 0 kudos

Find the next Wednesday based on an already given date

Hey everyone! I need help making a formula that gives me the date of the next coming Wednesday based on another date in a date field. So for example if the date field shows 3/4/23, I want the formula to return 5/4/23. Thanks in advance!

  • 89 Views
  • 7 replies
  • 0 kudos