Formulas
cancel
Showing results for
Did you mean:

## Formulas Activity

### Eliminate time stamp from results of a formula

Hello - I need to calculate a date, in certain circumstances, that is 75 days out from another date in my table. I’m using this formula:SWITCH({S/N}, 'no', DATEADD(DOB, 75, 'days'), 'NOW',DATEADD(DOB, 75, 'days'),'NA')which calculates correctly, but ...

• 84 Views
• 3 replies
• 0 kudos

### How to populate a column based on the selections made on a different column

I'm building a base to help track my company's product lineup and I've built an Interface for each one of us 3 founders have our own To-Do interface, populated from a To-Do table. This To-Do table gathers information from other tables such as custome...

• 123 Views
• 5 replies
• 0 kudos

### Multiple Dates per Entry in Calendar

Hi all--We are a publishing company and we sometimes publish the same content multiple times throughout the year. We have a field set up "Publish Date" that shows all of the dates. The problem is when I try to have these feed into our general publish...

• 137 Views
• 2 replies
• 0 kudos

### Resolved!Multiple amounts for Multi Select Field

So Im pretty new to Airtable and not sure if I am going about this the right way and wonder if someone can point me in the right direction if not. Basically I am trying to use a multi select option to calculate the Extra costs involved in a job with ...

• 114 Views
• 2 replies
• 0 kudos

### Compare Rollup to function

Hello.I am trying to find records where a rollup results is less than or equal to a function. Both are formatted as numbers, and both work when I search for records in each column independently. Is there a solution for this?

• 106 Views
• 3 replies
• 0 kudos

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

• 138 Views
• 2 replies
• 0 kudos

### Resolved!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 ...

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

• 176 Views
• 6 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...

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

• 226 Views
• 4 replies
• 0 kudos