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

Forum Posts

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
  • 227 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
  • 463 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
  • 582 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
  • 505 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
  • 461 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
  • 315 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
  • 1611 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
  • 1004 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
  • 990 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
  • 1512 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
  • 575 Views
  • 1 replies
  • 1 kudos

Embed Formula Link or attachment

the circled part is the focus… let take for instanceIf the "display attachment field" is not empty and the "cloud hosted field" is empty, a formula to display the display attachment field and not the cloud link fieldIf the "display attachment field" ...

airtable.PNG
Sched_kode by 5 - Automation Enthusiast
  • 1136 Views
  • 4 replies
  • 0 kudos