Help
Formulas
cancel
Showing results for 
Search instead 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...

Vincent3_0-1701271471929.png
  • 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

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

Schermopname (17).png
  • 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

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

WhatsApp Image 2023-11-24 at 15.53.44.jpeg
  • 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

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

Screenshot 2023-11-22 at 11.14.32 AM.png Screenshot 2023-11-22 at 11.20.12 AM.png
  • 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
ADK 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