Formulas
cancel
Showing results for
Did you mean:

## Formulas Activity

### Autonumbering Formula Problem

Hello everyone,Me and my team are working on a database for my business, to be frank we're new to Airtable, and there's something we can't quite figure out. There's this one table that is for recapping all of our clients' consultation sessions. After...

• 29 Views
• 1 replies
• 0 kudos

### Single Select Outputs for Formula fields

bonjour la communauté, la nouvelle mise à jour des champs de formule permet des sorties à sélection unique pour les champs de formule. J'ai un champs ou est concaténé plusieurs informations incluant une sélection unique. J'ai testé cette nouvelle fon...

• 63 Views
• 3 replies
• 0 kudos

### Create a Time Tracker using a formula to count how many times a record appears. Please help!!

I am setting up a new system for our company to track our projects and record how many days each designer has worked on a project and, equally, how many days a project has been worked on. The calendar view doesn't work for us, as date ranges don't wo...

• 79 Views
• 2 replies
• 0 kudos

### Resolved!Using nested IF test with AND tests stacked for multiple criteria in one column

Hello!I am trying to create a formula that categorises ships by type, then size category, and if they meet both of those criteria they are assigned a value that is annual fuel consumption appropriate for the vessel's size category. If not, the IF tes...

• 50 Views
• 2 replies
• 0 kudos

### Resolved!Formula field set to currency with 2 decimal places but getting up to 14 in token

I'm experiencing something weird - I have a formula field ("Cheque 2 amount") set up to subtract different currency fields. All fields, including Cheque 2 amount are set to currency format with 2 decimal places.  Everything looks normal in Airtable:H...

• 86 Views
• 3 replies
• 0 kudos

### #ERROR when dividing a linked record that is currency + setting up reference table

Hi Folks,I am essentially trying to automate quota calculations for the sales team in Airtable. As I explore setting up the tables, I'm running into constant brainfogs.1. Im dividing the "record" (quarterly target) by "3" (to break this into a monthl...

• 105 Views
• 5 replies
• 0 kudos

### Recreate If statement from excel

Hello everyoneI'm NawafI have a long nested if statement that i used to use in excel but I can't figure out how to use it in airtable the idea is i have 3 columns first ( permit status ) second is ( remark ) when the conditions meet, I want the third...

• 68 Views
• 1 replies
• 0 kudos

### Resolved!Find the maximum of three date fields including time stamp

I found this formula in the community. However I want to include a timestamp aswell. Since {date 1}, {date 2}, {date 3} may occur on the same day. I tried adding a format specifier but it wont work... The formula sets the time to a default 12:00am in...

• 85 Views
• 1 replies
• 1 kudos

### How to pull specific text out of a string that could have multiple formats

I have a URL field that I need to grab specific text from (in bold). Does anyone know if there is a formula I could use to easily grab just the string in bold without pulling in additional data from the 3 possible formats?Here are the multiple format...

• 75 Views
• 0 replies
• 0 kudos

### Attachment through Formula

Probably no way of doing this without an Automation right?I'd just like to have an image for my records based on a single select field. Essentially a Single Select field for images! I want to be able to assign a Logo for each record. Then on an inter...

• 86 Views
• 1 replies
• 0 kudos