Formulas
cancel
Showing results for
Did you mean:

## Formulas Activity

### Resolved!IF AND For Email Reminder

I am trying to add an AND statement to this formula:IF(     {Date Received} = "",     "Unsure of due date",     IF(        DATETIME_FORMAT({Date Received}, 'MM/DD') = DATETIME_FORMAT(DATEADD(NOW(), -14, 'day'), 'MM/DD'),        "TRUE",        "No mat...

• 75 Views
• 2 replies
• 0 kudos

### Detecting duplicate tags and tag limit in a text string

I have a somewhat complicated formula I wish to create, and as a formula n00b, I don't know where to start. Here's the problem I'm trying to solve:1. I have a series of tags I enter into a single text field, where each tag is separated by a comma. I ...

• 68 Views
• 1 replies
• 0 kudos

### Resolved!Extracting Telephone From Text field

Hello, I have a lot of text in a cell LONG TEXT (I extract a little bit of this), I need to create a new Formula column to extra only the telephone number, what can i do? Buonasera, Chiedevo disponibilità per parziale permuta con mia autovettura MASE...

• 95 Views
• 3 replies
• 0 kudos

### Resolved!Calculating Night Shift Allowances in the Staff Schedule

Hello everyone, In Germany, there is a regulation in the Occupational Health and Safety Act that states workers who work between 11 PM and 6 AM receive an additional allowance on their salary. This involves a complex formula, which even ChatGPT strug...

• 96 Views
• 2 replies
• 0 kudos

### DATETIME_DIFF is killing me...

Problem formula: DATETIME_DIFF({Task Due}, TODAY(), 'hours') Short Version: It's currently 5pm Pacific. The Task Due is due tonight at 12:00am Pacific. DATETIME_DIFF reflects -24. Why is this hours calculation reflecting 24 hours instead of 7? Long V...

• 168 Views
• 4 replies
• 0 kudos

### Rollup fields not working

I created a rollup field for my leadership score column but it only is showing the sum of one of the projects (project A) and not the other (project C).

• 183 Views
• 5 replies
• 0 kudos

### Formula for Scoring Multiple Select Field

Hi,I need help creating a formula for scoring a quiz that I am making in Airtable. The questions are a combination of single select and multiple select. There are 100 questions total and each question is worth 1 point if answered correctly. The multi...

• 95 Views
• 1 replies
• 0 kudos

### Order Quantity Formula Field

Hi,I need some help with an issue I'm facing. I have a formula field called "Order Quantities" and a "Meal Quantities" field (Long Text) that references it. I'm using the Fillout form to gather customer information. However, the quantity field in Fil...

• 138 Views
• 0 replies
• 0 kudos

### Resolved!If 1 column is blank, pull in text from others.

Hi! I'm trying to create a formula for the following columns:1: First Name2: Last Name3: Pen Namewhere If "Pen Name" is blank, use "First Name + Last Name". I keep getting stuck somewhere and getting invalid formula errors.

• 128 Views
• 2 replies
• 0 kudos

### Resolved!Nested IFs and SWITCH function

Hi all,Using Make, Airtable and an API, I built an automation that scrapes reviews of a cultural event from Google Maps. On Google, the date on which a user left a review is not given. Instead, Google provides us with a time period that matches the a...

• 159 Views
• 2 replies
• 0 kudos
by 5 - Automation Enthusiast
Solved