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

Forum Posts

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
  • 1336 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
  • 1602 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
  • 1494 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
  • 1112 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
  • 853 Views
  • 1 replies
  • 1 kudos