Help
Formulas
cancel
Showing results for 
Search instead for 
Did you mean: 

Formulas Activity

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

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

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

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

  • 53 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
  • 223 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 ...

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

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

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

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

  • 138 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
  • 145 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 ...

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

  • 196 Views
  • 5 replies
  • 0 kudos

Creating a Service Level Check

Hello,Thanks in advance for any assistance with this.We have a ticket system whereby people submit by form an action and it's completed with a time stamp; with a goal of completing every request within 8 hours.Currently we determine if the time compl...

  • 130 Views
  • 3 replies
  • 0 kudos

Resolved! Formulas > Números Consecutivos > A partir de un número en Especifico

Muy buenas tardes,Estoy montando mi propio gestor de proyectos, estos proyectos quiero numerarlos con números consecutivos, pero que el primer número sea un número en especifico.Por ejemplo:N. de Pedido: P003245 (Esté sería el primer campo de la tabl...

  • 107 Views
  • 1 replies
  • 0 kudos

Formular Error

BackgroundI am using a "Search Records"-module in Make Automation to compare data in a scenario (=item for sale) against records matching specific criteria in Airtable (=user wanting to buy an ite, like a  "search request").Desired BehaviourThe searc...

Bastianbb_0-1700573190743.png Bastianbb_1-1700573514681.png
  • 99 Views
  • 1 replies
  • 0 kudos

Resolved! Conditional Formulas for VAT

Hi, I'm new to airtable and am trying to get a simple conditional VAT formula to work. I feel like I am circling the solution but I'm not quite there. Essentially I am trying to track various hires and purchases for work, some of which have VAT and s...

  • 178 Views
  • 4 replies
  • 0 kudos