Hi I need your help. I do have a database of records with a number of columns corresponding to each record. Now I would like to send out an email to the database in order to confirm the data they have given in previous communication (original table) ...
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...
I created a master program plan in hopes to combine all of the project plans on my team, but I couldn't get the start date to auto-adjust based on the end date. My team used to use a spreadsheet in which we used this formula: =WORKDAY(H3,1,Holidays!$...
Hi guys,I currently have the below in a grid view.I would like to have a formula in the "Timeframe Status" column which will do the following:1. Check whether text has been added to the "RFI Resolution" field.2. If the "RFI Resolution" field is not e...
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...
Hi, where do I find completed record when it disappeared in the table?
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...
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...
Hmm, I feel like this should be easier, but I'm running into a stumbling block.I have a Multiple Select column {Dubbing VO (all languages)} that has a list of VO actors. Each name begins with the two letter code for what language they are working in....
Hello everyone! I'm attempting to construct email and Slack automation to remind my team to update specific projects (records) in a project management interface. When we were in data mode, I merely included a link to the Record URL in the automation ...
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...
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...
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...
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 ...
Hello everyone, Pretty new to Airtable but I am enjoying the platform and the features it offers. Currently I have a table with data for when we last saw specific people. The date is being entered as February 13, 2023 for example and I am converting ...
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...
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...
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
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...
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...
