Formulas
cancel
Showing results for
Did you mean:

## Formulas Activity

### Using Concatenate with Multi-selects Leaving an extra comma...?

If I use this formula:IF({Whole-Body Conditions}!=BLANK(), {Whole-Body Conditions}, "") & IF({Body: Left Foot}!=BLANK(),CONCATENATE(", ", {Body: Left Foot}), "")I get this result when {Body: Left Foot} is NOT empty, WHICH IS WHAT I WANT: But when {Bo...

• 9 Views
• 2 replies
• 0 kudos

### Formula to Correct #ERROR! for Empty Date Field

Hello Airtable Community,My table includes an event title field as well as one for an event date.Event Title:The Chemical Regulations LandscapeEvent Date:June 6, 2004Formula:LEFT({Event Title}, 16)&" - "&{Date}Formula Result:The Chemical Reg - 6/6/20...

• 15 Views
• 1 replies
• 0 kudos

### CRM - Probability calculator (value)

Hi,I am using AT for the CRM purposes. I've got a list of proposals we're working on within my Proposals Table: https://airtable.com/appGL773TiIYzLwZD/shrzetl6rN5gnxAYzNow, what I'd love to calculate is: based on the stage selected (and % probability...

• 40 Views
• 1 replies
• 0 kudos

### How to translate this IF formula from Excel to Airtable?

Hi all,wondering if you could help with the below, I need to give 1-5 rating to certain value ranges. Its daily revenue and you get rated based on your daily performance.This is the formula: =IF(AND(K2>=0,K2<=30),"1",IF(AND(K2>30,K2<=80),"2",IF(AND(K...

• 70 Views
• 1 replies
• 0 kudos

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

• 136 Views
• 4 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...

• 161 Views
• 6 replies
• 0 kudos

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

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

• 130 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?

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

• 163 Views
• 2 replies
• 0 kudos