Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Bring the sales price with two conditions Customer and Route

I need to get the price from another table and bring it to my booking table. The conditions must be based on the company and the route to bring the correct sale price registered in the Routes Price table,My airtable system is already working and I us...

Weekly Events Auto Populates at a range of Dates

Hello I wanted to create a base that will auto populate Week 1, Week 2, Week 3, and so on for a number of date, Date is linked to another base which is synced to that base with a view.The purpose of this is we have a product that has a weekly interac...

Locate Completed Record

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

reign by 4 - Data Explorer
  • 1 replies
  • 0 kudos

Formula to work out business hours between two date fields

Hi guys,I have 2 columns in Grid view, each with date and time. One is a "Created" column, the other is a "Resolved" column.I am wanting to have a formula to put into a 3rd column / field to work out the business hours between the two other fields. H...

Untitled Base_ Table 1 - Airtable and 3 more pages.png
CameronG by 4 - Data Explorer
  • 0 replies
  • 0 kudos

Resolved! Add new text from one cell to an ongoing list in another

Hi everyone,I'm trying to solve a workflow/formula problem I've run into.Goal: I am building a task tracker, and it's important we have a history of steps already completed for each task. I have built a table that lists the tasks, and one of the colu...

Jade_Payne by 4 - Data Explorer
  • 1 replies
  • 1 kudos

Multi-Variable Formula for Calculating Attribution of a Sale

Hello Airtable friends.I have a somewhat simple formulaic excel sheet that becomes very complicated when breaking it up to be used in Airtable.The goal:Based on the type of sale, each of 6 static 'sale stages' should have defaul percentage (out of 10...

Jack_Skinner by 5 - Automation Enthusiast
  • 5 replies
  • 3 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
  • 5 replies
  • 2 kudos

Resolved! How to 'hide' incomplete, linked parent task from a view

I hope this is the right place for this question, but we'll see!Context: We have a 'Tasks' table where each team member may have a list of hundreds of tasks (thanks to the joys of generating task templates). I would like to have a View for users that...

Unique filter

I have read a few discussions on Unique filter - lookup then roll up. But i really can't seem to figure it out. I have my calendar synced - then I have a column of attendees, which is linked to companies. So each row has the different company in the ...

Selimafifi by 5 - Automation Enthusiast
  • 2 replies
  • 0 kudos

Help with Switch formula based on Checkbox field

Can I use the switch formula to choose between the values of two fields based on whether a checkbox field is checked? I have 3 relevant fields in this table:{Contract Amount (distinct)} - a simple currency field showing the amount for this distinct r...

Splitting out values from multiple linked records

Hi everyone,I’m looking to incorporate the tracking of SLA’s into our base to measure performance against timestamps. Currently I have a table of all our SLA’s with descriptions and numeric values for the SLA which will be used in the calculation. We...

please help, urgen

hi i need to copy the formula of the data "campagna" column of the database section in the "candidature" section so the data will appear even in this column. How can i do? I can't find a solution, thank you very much for the help. Please let me know

tommaso by 4 - Data Explorer
  • 1 replies
  • 0 kudos

Finding the closest date in the future from a look up field

Hello all, This is my first time posting here! Apologies if the explanation is not the most succinct. I need help with creating a formula to work within an intricate email and list management system I've set up. I have two tables: Email --> Each reco...

erikdohner by 4 - Data Explorer
  • 1 replies
  • 0 kudos

Need help with a formula lookup/rollup

Hi, I have 2 tables: Table 1 has a list of contractors and a field showing the value of the projects they've gotten. On Table 2 I have a field showing the contractor with the max value that auto updates as other contractors acquire projects with high...

Noochy12 by 5 - Automation Enthusiast
  • 7 replies
  • 0 kudos