Formulas
cancel
Showing results for
Did you mean:

## Formulas Activity

### Resolved!Updating A Dropdown Based On Multiple Factors

Doing some work for an ATM Placement Company.When a client signs on, we have a set # of ATMs that we promise to place for them after they set up their bank account.Currently we are looking for a way to update a dropdown status based on a few factors ...

• 23 Views
• 2 replies
• 1 kudos

I have a column named MIN and need to add leading zeros when the value in column is less than 4 numbers:BeforeAfter Formula220022456045610000100008888888888999999999999999999This is what I have right now but is giving me an error for the largest numb...

• 12 Views
• 1 replies
• 0 kudos

### IF function with multiple DATE FIELDS

Hi there,I got trouble with using IF functions across Date field, currently I want my result is:IF({Date field 1} is filled, then "Completed"), IF({Date field 2} is filled, then "Extended"), IF ({Date filed 3} is filled, then "Waiting")How do I make ...

• 41 Views
• 5 replies
• 0 kudos

### Return Multiple Unit Specifiers for DATETIME_DIFF

Sorry if this is a basic question— I am just starting out learning how to use formulas with little/no prior excel experience.I have a formula that calculates the difference between today's date and the date a video was released. I have it returning t...

• 23 Views
• 1 replies
• 0 kudos

### Multiple Select Formula to return 'pending' subscriptions calculation?

Hello Airtable community!Hoping someone can assist with this formula conundrum. In short, seeking to calculate 'pending' (sold but not yet activated) subscriptions within an Airtable base. Subscriptions Table primary field is per nominated subscriber...

• 39 Views
• 1 replies
• 0 kudos

### Resolved!Combine Names with the same and Different Last Names

Hi, everyone! I need help in combining names from two Rollup fields with the result below:First Name                        Last name                        Formula Field (Result I want)Mary                                  A.                        ...

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

### Resolved!Formula works natively in Airtable, but does not work from a Make (Integromat) Airtable Service mod

I am trying to build a module in Make (Integromat) that will find a single Airtable record that matches an AND + OR condition:My formula is:AND( {NMI}="XXXXXXXXX", OR( {Subscription status}="Active", {Subscription status}="Pending", {Subscription sta...

• 44 Views
• 2 replies
• 0 kudos

### Airtable Formulas

Hello all, i'm fairly new to formulas and what not and need a bit of help.I'm trying to make a single select status field's Result show either "done" or "not done" based on a symbol in a separate formula i was thinking of trying use the IF functionTh...

• 50 Views
• 2 replies
• 1 kudos

### Issue with DATETIME_FORMAT is showing the wrong date

Hello everyone,  Quick question, I am using the formula DATETIME_FORMAT(Date, 'dddd d MMMM') to add the day of the week in may table (easier to fill in for the team if they know which day i.e., Monday, Tuesday, ... it is).The issus is that the formul...

• 32 Views
• 1 replies
• 0 kudos

### Roll up and sum values of formula field

I want to measure workload in a week. TABLE 1A) i use google calendarB) In airtable DATETIME dif give me the duration: 02:00C) The weeknumber is a formula week(Start) =  So i get Week 2022_5TABLE 2 This contains only weeknumbers: 2022_552 problems:a:...

• 32 Views
• 2 replies
• 0 kudos

### Combining several Multiple Select fields into a new field

Hello. I'm struggling to find a way to combine the contents of several Multiple Select field into a new field, while retaining the value and color for each entry. Here's a stripped down version of what I'm trying to do: I've got 4 separate multiple s...

• 65 Views
• 6 replies
• 0 kudos

### Custom Formula Help

Hello,I am looking for a custom formula to help me solve the following.Basically: If text in column A is true then add numbers in column B + 50 otherwise null.If {inspection} contains "oil change" then add {engine hours} + 50.0 The problem I have is ...

• 598 Views
• 2 replies
• 1 kudos

### Count how many times a row is linked in another table

Hi everyone!I'm new to Airtable so I need a bit of help.I have two bases with one main table named the same. "Students" and "Mentors"The "Mentors" base is published as a sync table in the "Students" base, and vice-versa.In the "Students" base, I have...

• 64 Views
• 1 replies
• 1 kudos

### Updating Airtable IF something new exists in Podio

Hi everyone, Thank you in advance for any suggestions you may have I'm working on creating an always up-to-date Airtable that consists of records being updated in Podio. So within Podio, I have an app with a sheet consisting of people; my colleagues...

• 66 Views
• 2 replies
• 0 kudos

### Finding info / Splitting to columns based on delimter?

Hello all, I'm hoping for some help with formulas that will allow me to achieve below. I have scoured all the brilliant responses to similar questions, but none quite meet with this. The format will always be the same but character lengths with vary....

• 60 Views
• 2 replies
• 1 kudos
by 5 - Automation Enthusiast

### Resolved!Regex or Subsitute Formula? Or Both?

I have a field that has a ton of linked records and I'm trying to format that into a nice list for use in the Pages extension.  It's generally coming through with commas and quotation marks separating it.  I found this formula in another thread, whic...

• 1289 Views
• 8 replies
• 0 kudos

### Need help with IF formula for negative numbers

I am trying to have a formula that says the following: 1) If the value in this \$ field is greater than 0, 'Do this'2) also, the value in this \$ field is 0, 'Do this instead'3) also, if the value in this \$ field is a negative number, 'Definitely do th...

• 59 Views
• 1 replies
• 1 kudos

### Check if value is added more than once per date

Hi everybody!I'm trying to move our Excel spreadsheet to Airtable to simplify things ans automate something.The spreadsheets is just a list of activity that we need to do (we rent stuff), have a look at the screenshot.Question: is there a way to tran...

• 34 Views
• 0 replies
• 0 kudos

### Time is wrong in NOW()

I have a formula field containing NOW() and nothing else. The field is showing the wrong time. Right now it's 3:02 a.m. in the desired time zone (Eastern Daylight Time), but the field shows 2:59 a.m. I've attached a screenshot showing the difference ...

• 47 Views
• 2 replies
• 0 kudos

### Returning New Entries as a Summary Table

I organize a Run group that uses Airtable to login runners each week, via a form entry from a "Check-Ins" table. This form pulls data (names) from a larger "Runner List" that keeps track of all registered runners that have ever logged in. The "Check-...

• 43 Views
• 2 replies
• 0 kudos