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

Formulas Activity

Formula to create yearly calendar of dates

Hello,I'm really new to Airtable and completely inexperienced with formula options.I'm looking to set up a formula so I can easily create a list of dates for the calendar year. Right now I used # option but I think a formula is more in line with what...

Estelle_0-1679583596558.png
  • 7 Views
  • 1 replies
  • 0 kudos

When criteria is not met, leave field blank (help)

Hello everyone! I have this formula:  IF(AND(DATETIME_FORMAT({Trækdato (FarPay)}, "D")<10, DATETIME_FORMAT({Dato for udløb}, "D")<10), IF(WEEKDAY(DATETIME_PARSE(DATETIME_FORMAT({Dato for udløb}, "YYYY-MM-10"),"YYYY-MM-DD"))=3, DATEADD(DATETIME_PARSE...

  • 8 Views
  • 0 replies
  • 0 kudos

Character counting with conditions

I am using the LEN(string) function but I want it to exclude commas, is there a way to do that? I have a list of items with commas in between, I would like a character count of the letters but not the commas.

  • 17 Views
  • 2 replies
  • 0 kudos
IIAL by 5 - Automation Enthusiast

How to create a button to call and mail?

I am trying to create a button to make calls and mail using URL "mailto:xyz@abc.com" but I am not able to use that. Can you suggest me something?  The email address and phone number are stored in different columns.

  • 28 Views
  • 0 replies
  • 0 kudos

Help With Rollup (SUM) linking Formula (datetime_diff)

Looking for some help. I have a table were I utilize "last modified time" to be inputed based on the Specific field ("Checkbox").This sequence works well for what I am doing, which is; creating time logs for when we "Start" and "Stop" work on a speci...

  • 30 Views
  • 0 replies
  • 0 kudos

Resolved! How to create list of dates for the year

Hello,I'm completely new to Air Table and very unfamiliar with the available formulas.I want to have rows display dates for the whole of 2023. Yes, a long list of every day of the year. I'm including a picture as an example.I'm sure I can achieve thi...

Estelle_0-1679500930921.png
  • 27 Views
  • 1 replies
  • 0 kudos

Formula to create sequential numbers based on Date field

I am using a Formula field as my Primary Field for a schedule table (each record is a time slot).Among my formula for naming each time slot, I would like to add a number (ie. 001, 002) which is generated based on the Date field.ie. Record X: March 5,...

  • 20 Views
  • 1 replies
  • 0 kudos

Resolved! Replace "," by "&" in a lookup field

Hi there! I've been trying to replace  "," by "&" in a lookup field using Substitute and IF statements but I still receive an error or the result is not giving me what I want. So the result I want is IF First name contains  "," then replace by &..  

Yvia_0-1679407184729.png
  • 45 Views
  • 6 replies
  • 0 kudos
Yvia by 5 - Automation Enthusiast
Solved

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

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

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

  • 53 Views
  • 5 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...

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

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

  • 46 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
  • 68 Views
  • 2 replies
  • 0 kudos

Day of Week and Date

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

  • 37 Views
  • 2 replies
  • 0 kudos