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

Forum Posts

Formula to identify diacritics

Hello,I am working on a base that includes artists' names and a lot of them have diacritics in their first and last name. Is there a formula that I can use that could identify if there are diacritics used? It can be a simple True or False formula tha...

AcDemas by 5 - Automation Enthusiast
  • 85 Views
  • 2 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...

Nawaf by 4 - Data Explorer
  • 104 Views
  • 1 replies
  • 0 kudos

Resolved! Insert a space before a capital letter

Hi I have a file name / string of texte.g. 'ThisIsTheFileName'I would like to insert a space before each capital letter. Is there a formula to do this?Thanks 

JM1234 by 6 - Interface Innovator
Solved
  • 288 Views
  • 2 replies
  • 1 kudos

Formula If client is married, primary field will show spouses name.

I have the primary field set as a formula right now as CONCATENATE({Client Last Name},', ', {Client First Name}). I want the formula to include the spouses name after the client's name if the marital status (separate field) is married. What would be ...

tahsinh by 4 - Data Explorer
  • 445 Views
  • 1 replies
  • 0 kudos

Need help regarding advanced formula usage

Hello there,I am trying to create a formula that calculates the total cost of items based on their quantity and unit price; while also factoring in a discount percentage if applicable. I have tried using nested IF statements; but I am running into so...

elija6266 by 4 - Data Explorer
  • 277 Views
  • 2 replies
  • 0 kudos

Resolved! Complicated lookup field's Type causes formula to fail

I have two tables Experiments and Readings.Each experiment is linked to two or more reading records. Each reading has a DateTime field, and some readings such as pH and temperature. The pH and temperature readings are number fields.I want to use the ...

jethroc by 5 - Automation Enthusiast
Solved
  • 600 Views
  • 6 replies
  • 2 kudos

Resolved! Number separators formula

Looking for some help regarding a formula. Here's a little context of what I am trying to do. I am working on importing my teams marketing budget plans into Airtable, and so far everything is working well. As a final step, and in order to avoid have ...

AcDemas by 5 - Automation Enthusiast
Solved
  • 634 Views
  • 2 replies
  • 1 kudos

Help with Forms and Formula's

Can anyone recommend an Airtable Consultant, preferably in the UK, who can help me with some fairly simple formulas which for some reason, I cant work out why, are not working and/or producing missing data in some rows. I feel very scrooge-like and m...

Resolved! SUM multiple calculations in one field.

Here's what I want to do. I have a field that lists percentages for the fees my company wants to add to a contract. Admin fee 10%, Late fee 5%, etc. If I were to stack these fees, I want to have a field that returns the sum of each percentage multipl...

gabumstead by 4 - Data Explorer
Solved
  • 435 Views
  • 1 replies
  • 0 kudos