Formulas
cancel
Showing results for
Did you mean:

## Formulas Activity

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

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

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

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

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

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

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

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

• 79 Views
• 1 replies
• 0 kudos

### Formula to calculate age on next birthday

I have a base with information about students in a music program, including their birthdates (MM/DD/YYYY). I have a formula that calculates their age as of today:DATETIME_DIFF(TODAY(), {Birthdate}, 'years') and a formula that calculates the number of...

• 78 Views
• 1 replies
• 0 kudos

### Formula similar to WORKDAY but working backward from a due date

I receive a due date and have to calculate backward to identify different milestones in our projects. What formula(s) do I need to use to make this work? I've attached a picture of what I'm trying to do.  Thanks in advance for the help!

• 91 Views
• 1 replies
• 0 kudos