Formulas
cancel
Showing results for
Did you mean:

## Formulas Activity

### Formula that turns a number into itself and all previous numbers/integers???

How do I make a formula that turns a number into itself and all the previous numbers?I.E. the number in the field is 8The formula should turn the field into:1, 2, 3, 4, 5, 6, 7, 8Please help!!! Thank you

• 53 Views
• 2 replies
• 0 kudos

### Use a formula to generate values that are formatted like a multiple select list

I want to create an IF formula that converts a single select to a multiple select.For example, in column 1 I want the value 'Primary Care Physician' to turn into a multiple selection of 'Internal Medicine Physician' and 'Family Medicine Physician'. I...

• 32 Views
• 1 replies
• 0 kudos

### Calculate difference between 2 dates and return answer in Years and Days

Hello AT Community, I am trying to write a formula that returns the number of years and days in between two dates. So for example, assuming {DoB} is 18 FEB 1994, DATETIME_DIFF(TODAY(),DoB,'years'),"y ") returns 30 which is correct.I would also like t...

• 52 Views
• 3 replies
• 0 kudos

### Resolved!IF AND BLANK formula not working for attachment field

Hi. I'm struggling with a formula to include a blank attachment field as part of 3 AND conditions. I'm testing this in my base before I put the AND part into a make.com airtable trigger module.At the moment, I have this:  IF( AND( {Ind Doc}!=BL...

• 78 Views
• 4 replies
• 0 kudos
by 6 - Interface Innovator
Solved

### Copy Column with large amount of data

I have a Long Text column in my table with a lot of text, likely 20K plus pages. I used formulas to clean this text, removing undesirable characters, extra spaces, etc.  Is there any way to copy the contents of the Formula column back to the Long Tex...

• 84 Views
• 3 replies
• 0 kudos

### Resolved!Formula in primary field To create id: Autonumber-year

I'm super new to airtable and I've been searching for the answer to this and I can't seem to find what I am looking for- likely because I don't know the right terminology but I have a table in my base and I want the primary field to auto populate eac...

• 127 Views
• 2 replies
• 0 kudos
by 4 - Data Explorer
Solved

### Resolved!How to join multiple rollups into one big array with only unique items?

I'm using my airtable to attached keywords images. I have one big keywords table with multiple categories of different keywords. Then i have multiple linked columns to the different categories. However some of the keywords overlap into different cate...

• 290 Views
• 10 replies
• 0 kudos

### How to create formula that extract user assigned?

HiI have a base with a column for User.I want to build a formula that extracts the user email of the User assigned and shows it in a new column.How can I make it?

• 76 Views
• 1 replies
• 0 kudos

### countdown in hours

Hello,we would like to find a formula to count down 24 hours and end at 0 or if possible marked "canceled".if anyone can help us i will be really gratefulthanks in advance

• 69 Views
• 1 replies
• 0 kudos

### Prefilling forms with Link to another record

I am facing difficulty in prefilling forms with 'Link to another record data type'Data is occasionally getting printed when the data type is 'Link to another record' with 'Allow linking to multiple records' switched 'ON' What changes should I make so...

• 122 Views
• 5 replies
• 0 kudos

### Date formula help!

Hi! I'm trying to set up a formula for a "Production Slack Reminder" that would be based on the "Send Date." If the "Send Date" falls on a Tuesday, Wednesday, Thursday, or Friday, the "Production Slack Reminder" should happen the day before the "Send...

• 78 Views
• 1 replies
• 0 kudos

### Resolved!workback from date field using Dateadd, Workday, and a Holiday String

I am struggling to add a holiday string in an existing worback formula that changes the date based on another field. I applied Workday successfully but cannot apply {Holiday String}&"" SWITCH({Channel Size},'Large Email', WORKDAY(DATEADD({Launch Date...

• 119 Views
• 4 replies
• 0 kudos

### Resolved!Using IF, and AND and OR formula using emojis

I struggling to correct a formula where I want the return value to appear based on IF AND statements.Goal I am trying to achieve:I DO NOT want the phone emoji to appear in the “follow-up” column if the “lead score” is below 5 (Eg: 0, -5, -15).Here is...

• 113 Views
• 2 replies
• 0 kudos

### Separating multiple data entries in field

Hey,I imported my contact database into a table and am trying to separate these years so that "2019; 2020" would turn into multiple datapoints that can be filtered accordingly like "2019, "2020" etc. Is there any easy way to do this? Thanks!

• 114 Views
• 3 replies
• 0 kudos

### Resolved!Using Formulas to create a Task status based on status of Sub Tasks

I have 2 linked tables, Tasks and Sub Tasks. I want the Sub Tasks' status to define the status of the Task. I currently have a rollup that makes an array of all the statuses in a given Task's Sub Task. Then I have a formula that reads these arrays an...

• 165 Views
• 3 replies
• 0 kudos

### Adding a date to an IF statement

Hey all, I could use some help and I'm hoping this isn't too difficult. I am trying to add a formula that compares an event date to the date of the next time change. If it is before the date of the time change, it runs one formula, if after, it runs ...

• 240 Views
• 5 replies
• 0 kudos

### Calculate Friday of the week before start of next month

Hiya! I'm relatively new to Airtable and need help with this formula. I need to find a formula that displays the date for the Friday of the week before the start of the next month based on a date in another field. Would also love to know what each el...

• 97 Views
• 1 replies
• 0 kudos

### Trim and Substitute '

I am working on a formula that1. Trims2. Replaces Double Quotes (") with Apostrophes Quote (')3. Replaces Ampersands (&) with 'and'.TRIM(SUBSTITUTE(SUBSTITUTE(DESCRIPTION, '"', ''),'&','and'))The above works, except, if I change it to include the Apo...

• 93 Views
• 1 replies
• 0 kudos

### connection of softr and airtable.

we have a problem with the connection of softr and airtable. We have a part in softr where people can add new data and we need that data to be in airtable. However, in airtable the place where the data should go to is linked with other tabs.Since it’...

• 180 Views
• 1 replies
• 0 kudos

### Count number of times a word comes up in a linked records list

How can I count the number of records in the list "Attended Session & Challenge" that are specifically only from 2023? The attendance is based on a form they fill in that is in a different tab in the same workspace. help would be very appreciated! Th...

• 102 Views
• 2 replies
• 0 kudos