Formulas
cancel
Showing results for
Did you mean:

Formulas Activity

Concatenate and summarize each rollup value

Hi all, I have a two-table base. The first table/screenshot below is for survey responses; each record is an individual survey response. The second table/screenshot is where the responses roll up for each survey. Is there a way within the rollup file...

• 9 Views
• 0 replies
• 0 kudos

How to Lookup and retern spacific record from Diff Table to the current Table ?

Hello , thanks for taking time for giving a hand  on this Table 1 ( Currency ) for Monthly Foreign Currency Ex RatesUSD Nov 2023SAR Nov 2023EGY Nov 2023 Table 2 ( Budget Line ) which contain the monthly budget line in different Monther Table 2 will h...

• 14 Views
• 0 replies
• 0 kudos

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

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

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

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

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

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

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

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

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

• 59 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?

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

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

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

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

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

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

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

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

• 149 Views
• 2 replies
• 0 kudos