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

Formulas Activity

How to Format Dates in a Rollup field with multiple dates

Hi everyone,I've been searching airtable forums for hours yet I can't find a solution that clearly explains what I need to do to achieve my desired results. There are different answers talking about using MIN() or something other formula, but I can't...

Scribbles__0-1686012770090.png
  • 29 Views
  • 1 replies
  • 0 kudos

Markdown code showing in email body for some recipients

Hi all,I'm sending out emails via Airtable and some (but not all) recipients are noticing a very weird problem. The URL code shows the markdown text instead of the URL link, ie., it shows [TEXT](url) instead of TEXT.I thought it might just be a probl...

  • 28 Views
  • 0 replies
  • 0 kudos

Extract info from a Long Text field

Hi, I have a long text field with the info bellow and would like to extract the infos in bold to different field but cant find a formula to help me with. Thanks in advance for any help guys.This is the text I have in the long text field (its in portu...

  • 39 Views
  • 1 replies
  • 0 kudos

Turning <p> and </p> into line breaks in a field

Hello, all. I am importing a CSV file into Airtable. Some of the CSV data ends up as Long Text fields in Airtable, and consists of blocks of text with multiple paragraphs. It comes in with <p> and </p> indicating these paragraphs.In Airtable, the <p>...

  • 57 Views
  • 1 replies
  • 0 kudos

Resolved! Extract 0-1000 number from a url after a pattern

From the below URL, I am attempting to extract the number that comes after the pattern "page%5Bnumber%5D="https://api.leadfeeder.com/accounts/133259/leads?end_date=2023-01-01&page%5Bnumber%5D=39&page%5Bsize%5D=1&start_date=2023-01-01In this case, the...

  • 66 Views
  • 2 replies
  • 0 kudos

Open URL to Anydesk doesnt work

Hi everyone, I have a base that keeps Anydesk ID's of our staff, and I want to open Anydesk automatically from Airtable, using the saved Anydesk ID. There is a URL Handler from Anydesk, the problem is, that the link doesnt open in Airtable.Thats the ...

  • 66 Views
  • 2 replies
  • 0 kudos

Resolved! Formula that shows "Yes" if date is in the previous year

Hello everyone, I have currently the following formula in my table that shows "Yes" if the date in "Fin contrat" is in a future month. I am trying, but with no success, to adapt this formula to show "Yes" in another column if the same date is in the ...

  • 80 Views
  • 2 replies
  • 0 kudos

Resolved! IF contains nested formula help

We have a system for reviewing new tools where they are checked for meeting accessibility standards and security standards. These are two separate teams with different workflows. The integration team needs to know when a tool review is considered com...

  • 75 Views
  • 3 replies
  • 0 kudos

Resolved! Help with formula if from another column, then calculate...

New to Airtable... Trying to create formula that will calculate 6.25% tax but ONLY if the "State" column is "MA" (for Massachusetts)... I figured out the tax part (Price*0.0625), but not getting the If State=MA, only then calculate tax for the tax co...

  • 83 Views
  • 3 replies
  • 0 kudos

Dynamic ratio on a table

Hello,let us say that I have a simple table containg a list of products and the sale amount of each product. Now i want to add the share of sales of each product in this table.The only way I found to do that is to create a new table called "Total". T...

  • 59 Views
  • 0 replies
  • 0 kudos

Resolved! Adding formula fields for recurring dates, including SET_TIMEZONE

Hi, I'm sure the answer to this is really simple and I'm just missing it, but could someone please take a look at this formula and let me know why some records would be throwing an ERROR, but others are working? I'm thinking I've got something in the...

  • 93 Views
  • 6 replies
  • 0 kudos

Making a single selection from within a multiselect field range

Hi, I have a field of clothing sizes which varies for each garment record. Ideally I'd like to be able to set up a single select field with options that vary depending clothing sizes held in the multiselect or linked field for that particular record....

  • 95 Views
  • 4 replies
  • 0 kudos

Resolved! IF AND for Status Change

Hello, I'm trying to create a Formula that will change Status according to the fields "Start Date" & "End Date". If Today > End Date = "Delayed"If Today < End Date = "In Progress"If Today < Start Date = "Planning"I have written the following formula ...

  • 129 Views
  • 5 replies
  • 0 kudos

Formula to find the first instance of a meeting between two people

Hello!I have a table of clients, each of whom has been assigned a coach.I have a second table of appointments which is coming from Acuity. In that table, I have the clients linked so I can see all of the client's meetings with anyone in our company.W...

  • 61 Views
  • 2 replies
  • 0 kudos

Resolved! How to calculate a Date plus/minus X days

Hello, I am looking for a way to calculate a date minus x days based on a date field. I.e. the result should be 31.12.2023 (DD.MM.YYYY) minus 10 days = 21.12.2023. How can I do this? I tried to use this formula, but it returned an error:  DATETIME_FO...

  • 76 Views
  • 1 replies
  • 0 kudos

Automate tick box and Your result type is not a number or a date.

Hello,So currently, we do have a tick box on this view and manually tick it once it is the latest valuation.Do you have any ideas on how can I automate this? without doing the manual ticking?Another issue, I created this formula : IF({latestVal Date}...

Screenshot 2023-06-01 at 12.45.00 PM.png Screenshot 2023-06-01 at 12.47.30 PM.png Screenshot 2023-06-01 at 12.49.51 PM.png
  • 124 Views
  • 5 replies
  • 0 kudos