Formulas
cancel
Showing results for
Did you mean:

## Formulas Activity

### What are the health benefits of water?

Water is your body’s principal chemical component and makes up about 50% to 70% of your body weight. Your body depends on water to survive.Every cell, tissue and organ in your body needs water to work properly. For example, water:Gets rid of wastes t...

• 8 Views
• 0 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...

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

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

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

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

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

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

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

• 69 Views
• 1 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...

• 81 Views
• 1 replies
• 0 kudos