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

Formulas Activity

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

  • 23 Views
  • 0 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...

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

  • 32 Views
  • 0 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 ...

  • 41 Views
  • 2 replies
  • 0 kudos

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

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

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

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

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

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

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

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

  • 68 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
  • 118 Views
  • 5 replies
  • 0 kudos

Creating Goals by Increasing a Number by a Set Percentage

I am trying to generate sales goals in a formula, I have a column with the previous years result (manually entered), I have a % column with my growth target but I cannot figure out how to create a column with a formula that takes the previous result ...

Screenshot 2023-05-31 at 9.20.14 PM.png
  • 59 Views
  • 1 replies
  • 0 kudos

Calculating Due Dates

Hello!I am creating a list of tasks that need due dates assigned using the following conditions:1. Each task is due one day after the previous task is due (note: dependencies would be nice to have but not necessary)2. The tasks are never due on Frida...

  • 172 Views
  • 1 replies
  • 0 kudos

Resolved! How to 'hide' incomplete, linked parent task from a view

I hope this is the right place for this question, but we'll see!Context: We have a 'Tasks' table where each team member may have a list of hundreds of tasks (thanks to the joys of generating task templates). I would like to have a View for users that...

  • 68 Views
  • 2 replies
  • 0 kudos

Rollup from Multiselect - Expense Calculator

I am trying to create a tracker for trip expenses. I have a list of Attendees in one table, then Receipts in another with a "Charge To" field (since sometimes expenses wont be shared evenly across the group) that is a link to the Attendees table. Wha...

  • 61 Views
  • 1 replies
  • 0 kudos