Formulas
cancel
Showing results for
Did you mean:

## Formulas Activity

### Split start and end dates which can be formatted differently

Hi there!I am getting start and end date as a text in one field.BUT format could be different in each record (mm/dd/yyyy OR yyyy-mm-dd)I want to find a formula to split A field (which could be formatted in two ways) into start (B) and end (C) datesTi...

• 8 Views
• 0 replies
• 0 kudos

### Utlization summary looks ''across'' multiple weeks

The Utilization Summary works differnt than I expected, and I can't figure out why.I think this image summarizes my question: In short:I have 5 working days (40 hours) per employee as ''Available hours''And my tasks are split into working days, where...

• 8 Views
• 0 replies
• 0 kudos

### Round a time up to nearest 30 seconds

HiI have a field called {Total Duration} where the user enters the length of a video in h:mm:ss format. This formula is going to be used to calculate the costs of video editing. We charge in 30 seconds units. 1-30 seconds is charged as one unit, but ...

• 10 Views
• 0 replies
• 0 kudos

### Formula creating a total for multiplying multiple columns by fixed cost

Hello! I figured this out before and accidentally cleared it a while back without noticing. For context, I am trying to find the total cost associated with ordering additional curriculum books. In the form submitted, customers can select additional b...

• 38 Views
• 1 replies
• 0 kudos

### Remove white spaces at the beginning of all fields

Hello,I would like to not have a space at the beginning of each entriesI think I have to use Trim but My formulas is long and I do not know how to make sure each line and trimmed.Right now with this formulas each lines as a white space at the beginni...

• 32 Views
• 1 replies
• 0 kudos

### Need help on IF formula

Hi,I want to create an IF formula but the result I get is not what I expectedHere is the formula: IF({Date effective de fin du cadrage (from Date effective de fin du cadrage)}<{Date estimée de fin du cadrage (from Date estimée de fin du cadrage)},"In...

• 74 Views
• 3 replies
• 0 kudos

### Resolved!Time change after CONCATENATE formula

Hi there.In a field, I have used the formula below: DATETIME_FORMAT({Datum gesprek}, 'DD-MM-YYYY HH:MM')&", "&{Traject begeleider} Weirdly, the outcome makes the time change by a few minutes. I can't figure out why. Setting timezone, or changing othe...

• 58 Views
• 2 replies
• 0 kudos

### duplicating a recored and its linked filed.

I’m trying to use automation to copy a record and create duplicates of all the linked records in the original record. Here’s what I’m trying to do:Create a new record and update it with all the fields.Search the other table for all the records that a...

• 41 Views
• 1 replies
• 0 kudos

### Resolved!Finding out the maximum number of accounts

I am working with a subscription table and every row is an entry every time a customer subscribed to an account (It is possible for a customer to have more than 1 account). I have a field for Start Date and End Date, and I want to know the maximum ac...

• 57 Views
• 2 replies
• 0 kudos

### Suggestion: Add "Formula Script" field type

How about creating a new field type ("Formula Script" or such), where Script (or at least some subscript) can be used for a field formula?

• 184 Views
• 0 replies
• 0 kudos

### Sum different values

Hello,This table register the time my employes arrive ("Entrata") and leave ("Uscita") using an Airtable database.I managed to have a number that defines the total of hours my employes work during the day using DATETIME_PARSE in the "Worked Hour" Col...

• 228 Views
• 1 replies
• 0 kudos

### Formula for a position in dynamic leaderboard

Hello Airtable Community,I'm currently working on an exciting project using Softr, where I'm creating a ranking system for athletes. Each athlete is assigned a unique score based on their performance in various exercises, and this score is then used ...

• 119 Views
• 1 replies
• 0 kudos

### Formula returning extra character

HiI have a formula that compares a rollup to a text field and then returns any new additions to the rollup. However it seems to be returning an extra character, could anyone help me figure it out please?From this:'Nelson Dance Festival- 2024, Royal T...

• 128 Views
• 2 replies
• 0 kudos

### Getting airtable to suggest from an list of available employees, the one who has the lowest hours

I am building a schedule/time management base where employees can show their interests for shifts by adding their names to a (multiple select) shift calendar. Employees are unionized and have to be prioritized by the lowest monthly hours given and se...

• 108 Views
• 0 replies
• 0 kudos

### Seeking Guidance on Dynamic Ranking System in Airtable

Hello Airtable Community!I'm currently working on implementing a dynamic ranking system for my gaming challenge, and I'd love some guidance on using Airtable for this purpose.Project Overview:I want to create a fluctuating Rank Rating like Elo/MMR in...

• 122 Views
• 0 replies
• 0 kudos

### Resolved!Formula based on Single Select

Hello - Situation: Volunteers on the team have a 2-year tenure and when those 2 years are up, they can opt-in for 1 more year. My table shows their "start date" and then I have a column showing their "end date" using this formula DATEADD({Current WON...

• 216 Views
• 6 replies
• 0 kudos

### Ingredient stock rollup

Hello,We are a vitamin supplement company and we buy ingredients from all over the world. We have 178 different ingredients which are used to create 17 products.  Sometime the same ingredients will be used for five different products.We want to creat...

• 144 Views
• 3 replies
• 0 kudos

### Using IF Formula

I have these two fields Formula on Contract Yield % is this:({Contract Rent PW}*52)/{Purchase Price}I need to replace the formula in the Contract Yield, to an IF formula.More likely:When the result on Contract Yield is 0%,   If Contract yield = above...

• 147 Views
• 2 replies
• 0 kudos

### Resolved!Format Rich Text if (Search)

Hello,Want to strike through text in a cell if a given string is found in another cell in that row.  Is this possible?The cell whose text I want to strike through is already a concatenation of various other field values.  It's looking in a different ...

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

### Resolved!Field needed that displays most recent status based on date field

(Similar to this post though with an additional layer)I have a table with Interactions. There's a Status single-select field and a Timestamp field (since this data is being imported from elsewhere) that shows when the data was captured in the origina...

• 202 Views
• 5 replies
• 0 kudos