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

Forum Posts

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 1 - Visitor
  • 48 Views
  • 1 replies
  • 0 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
  • 276 Views
  • 1 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...

MoniK by 4 - Data Explorer
  • 533 Views
  • 3 replies
  • 0 kudos

How to get the index of the link to another table

Let's say I have a table of Invoices and then a table of payments. Each invoice is an aggregate of payments i.e. one invoice can have multiple payments. How can I get the index of each payment in the list of the invoice?

Nested IF plus.... What else do I need? 😳

Hi All! I am still new to Airtable and writing formulas and (hopefully) this is an easy question.I am trying to write a formula that will display text that matches the "checked" state of 3 different checkboxes, and also will display "New" if none of ...

Spruce_0-1696519610393.png
Spruce by 6 - Interface Innovator
  • 683 Views
  • 3 replies
  • 0 kudos

How to Insert a Line Break in a Long-Text Column

I'm working with a long-text column in Airtable and need to insert line breaks into my text to help improve readability. Could anyone guide me on how to add a break (\n) in my text within a long-text field in Airtable? Any help or guidance would be m...

serdar by 4 - Data Explorer
  • 603 Views
  • 1 replies
  • 1 kudos

Resolved! Lookup... Maybe?

Hello below is a table of scores and the corresponding status. I also have a risk register for each risk I want to be able to select the probability (1-5) and the Imapct (1-5) and it automatically returns the status as defined by the table below. Is ...

andrewb9_0-1695141274312.png
andrewb9 by 4 - Data Explorer
Solved
  • 535 Views
  • 2 replies
  • 1 kudos

Decimal Formula Issue

I have a base for timesheets. I have a column which is set to decimal for hours total called qty eg. 9.50 or 10.00. Then I have a formula that will accept the total hours or put something different depending on leave status abbreviation but it won’t ...

Locate Completed Record

Hi, where do I find completed record when it disappeared in the table?

reign by 4 - Data Explorer
  • 346 Views
  • 1 replies
  • 1 kudos

Resolved! Adding certain statuses

Hello Community! I need some guidance... I have a few columns with fields that are Single Select and one of the options is "COMPLETED". I am looking for a way to create a formula for it to add "how many COMPLETED fields" I have for that record... For...

Mike_Lopez by 5 - Automation Enthusiast
Solved
  • 1823 Views
  • 5 replies
  • 2 kudos

Resolved! Help with writing a Formula

I'm thinking I can use a 'formula' field to do this task. Can anyone help with the 'Formula' field... or is there a better suggestion. Thx.IFFirst 4 characters of a record in {Unit & Week} = First 4 characters of a record in {Unit Name} AND {2023 Fee...

Tom_David by 6 - Interface Innovator
Solved
  • 1085 Views
  • 2 replies
  • 0 kudos

DATEADD formula based on variations from two other columns

I have a campaign work back schedule. I need to calculate four date fields based on the Launch Date:Assign Due DateDeveloper Due DateQA Due DateApproval Due DateLaunch DateThe number of days for each due date varies based on the combination of two si...

airballer86 by 6 - Interface Innovator
  • 1122 Views
  • 3 replies
  • 0 kudos

Resolved! Extract URL from text field in Airtable

Hello communityAgain faced with this, hope to get a simple workaround for this where I can get a formula that extracts URL from a text field. Thanks

Sched_kode by 5 - Automation Enthusiast
Solved
  • 1694 Views
  • 4 replies
  • 1 kudos

Resolved! ERROR IN DURATION

I'm new with these and I think i'm having a big mistake but I cannot find it.I'm trying to extract the number of hours for an specific duration record.Obviously I use HOUR command but it doesn't work!As you can see in screenshots, the field Hours wor...

at1.jpg AT2.jpg AT3.jpg
ROYESPINALD by 4 - Data Explorer
Solved
  • 621 Views
  • 1 replies
  • 1 kudos