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

Forum Posts

Remove date/time from field

I just started using Airtable and I'm trying to remove the date/time from a column or create a new column that has the date/time removed with just the remaining text. The column is linked to another airtable and it is using the primary field, so I do...

JJJ by 4 - Data Explorer
  • 76 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
  • 201 Views
  • 3 replies
  • 0 kudos

Future Inventory & Ship Out Dates

Hello! We operate in an industry dealing with perishable goods, where the timing of receiving products (INBOUND) and the customer's requested shipping date (OUTBOUND) are crucial factors. We are trying to create a base structure/formula so we can kee...

4pine by 4 - Data Explorer
  • 362 Views
  • 1 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...

JuanArLo by 4 - Data Explorer
Solved
  • 199 Views
  • 1 replies
  • 1 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...

cevison2 by 5 - Automation Enthusiast
Solved
  • 232 Views
  • 4 replies
  • 2 kudos

Formula help

Small charity here thank you for reading!  I am trying to make a sign up sheet for volunteers to sign up to wrap Christmas presents for children - that bits sorted.  But I need to sort parking for them. On the main base theres a linked column that pu...

Copy and Paste multiple records from a table to just one cell

Hey there! I have a "Customers" table and a "Projects" table and what I'm trying to achieve is to link them. I wan't to know which customer were in each one of my projects, so a costumer may be in more than one project aswell a project will have more...

Resolved! Automatically adding URL to Attachment Field

Hi everyone,I was wondering if we would be able to automatically add an URL as an "URL-Attachment". This way I would be able to fetch a QR Code image and have it in my table.I could not find anything online. Unfortunately I can't install extensions t...

Eren1_0-1699016886174.png
Eren1 by 5 - Automation Enthusiast
Solved
  • 329 Views
  • 3 replies
  • 2 kudos

Resolved! Field to summarise records with shared column value?

To group records for planning purposes, I use a unique code for each record, then a custom text field to assign one of those codes to records that need to be grouped. This is for planning vegetable plantings with multiple vegetables in a plot. Here's...

oreocereus_0-1698786402729.png
oreocereus by 7 - App Architect
Solved
  • 293 Views
  • 3 replies
  • 2 kudos

calculation on pivot table

SpoilerI'm trying to calculate return rate (items received/ items delivered),  but aggregate them by day.  However, there are multiple receiving lines for each event, and only one input for items delivered.  I'd normally do a formula based off a pivo...

Resolved! Trouble with IF

What is wrong with this IF statement?  IF({Sonrise Home} = "CH", "Sonrise Children's Home"), IF({Sonrise Home} = "MIR", "Mirembe Cottage for Girls"))"Sorry, there was a problem saving this field. Invalid formula. Please check your formula text."  

Extract numbers from field into a new field

My field has a name followed by a number - SAM ADAMS (1234).   I need to put the 1234 in it's own field.   What is the best way to write a formula to do that?   

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?

Resolved! Clickable URL

Hi everyone, I searched through the community posts but could not find anything.Using a formula I created custom URL for every person in our company that will allow prefills in a form.CONCATENATE('https://airtable.com/appxxxx','?prefill_Your Name=',N...

Eren1 by 5 - Automation Enthusiast
Solved
  • 425 Views
  • 7 replies
  • 2 kudos

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
  • 390 Views
  • 3 replies
  • 0 kudos

Resolved! Conditional Coloring for the Record "pills" in a lookup field

Working on costuming for a film - have 4 main tables of Actors, Costumes, Scenes, and Characters.There's a lot of table to table referencing going on w/ lookups...But one thing I would LOVE to be able to do:When looking at the COSTUMES table (charact...

Can these colors be conditional.png
seanpeter2 by 5 - Automation Enthusiast
Solved
  • 325 Views
  • 3 replies
  • 1 kudos

How to view only part of a lookup field in a form?

I have a form that a member uses to search for their name using a lookup from another base. Because of PII Standards, I can't have their full name listed for others to also see. This basically works as a task tracker so (external) users have to enter...

Splitting Expenses as inventory is distrubted

I am looking for a way to split expenses amongst people in our company without duplicating the total. We purchase company merch/promo items and that expense goes under our expense table and is assigned to 1 of our 7 offices, or corporate. We assign a...

Resolved! IF + DATETIME_DIFF Formula Help! 🙏🏼

I have a lot to learn in terms of building formulas, and I'm found myself stuck and not sure what I'm missing.What I'm trying to accomplish:If the Completed column checkbox is ticked, display "Completed"If the checkbox is not ticked, display the time...

Spruce by 6 - Interface Innovator
Solved
  • 356 Views
  • 4 replies
  • 1 kudos