Hello community! We use airtable as an ATS (applicant tracking system) and now would like to extend it to project management.I have 2 different tables: candidates and jobs. I now want to create a new task table (classical kanban project management) w...
In our scheduling table for projects (table is called "Deliverables"), we have 6 sequential dates that tend to move frequently:Kickoff DateCreative ConnectRound 1 to ClientRound 2 to ClientRound X to ClientDue DateI've been trying to write a formula ...
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...
Hi, I have a field of clothing sizes which varies for each garment record. Ideally I'd like to be able to set up a single select field with options that vary depending clothing sizes held in the multiselect or linked field for that particular record....
Hi,I'm trying to validate customer's mails, to send them automated mails.I created a column validating another Email column in my relevant table, but the formula shows me that the mail doesn't match the regex, even though I know it's a working mail.t...
Hello team! I am trying to calculate the average weekly attendance in airtable. I downloaded the data from airtable and was able to calculate it in excel using an "averageif" function but I am not sure how I can implement it in airtable. The last col...
I'm working with some data coming from another group and they use both text and dates in a fields that I need to pull apart and use the dates to estimate further due dates down the line. I'm trying to avoid the big #ERROR! when the field has text and...
I know I am late to the game here. I have been ignoring the updates until now. I currently have uploads and the links for the uploads through a formula - which allows me to create a download button.I use these so in the public share link to my base -...
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...
Hello!I cannot figure this out.On one table, I have a table that lists the weights of a package on each row, and the cost to ship.For example, a 1# pkg costs $12.00 to ship, and on the next row, a 2# pkg costs $12.90 to ship.On a second table, I want...
Hi,Not sure if this is possible...I'm looking to create a formula that checks the condition of a single select cell called {Alt Shop}. IF empty use {Discount Code} if it contains "Shop Name" to use data from a particular cell in a particular row.For ...
Hi all,I've ran this code and don't have an error message coming up but when I click ok the final part of the 'If' formula is deleted.I'd like it to run so that all parts of the if formula work (three options): IF({Always On/Miniseries} = "Always On"...
Hi,I am getting this error when I try to upload a string valued date to a "Date" type column in airtable using python script. [Error: {\'type\': \'INVALID_VALUE_FOR_COLUMN\', \'message\': \'Field "Uploaded Date" cannot accept the provided value\'}]Wh...
Hi I have a multiselect that I have parsed out the individual answers to (they are ranked choice votes basically).I want to total the votes, and haven't figured out how to do that though I suspect Rollups and conditional counts could work, this will ...
I've used hours to search for a solution via Airtable support pages, this community, Youtube (interesting video) and even ChatGPT, but I can't seem to find an out-of-the-box solution. Hopefully someone like you can help In an Airtable dashboard inter...
Hi, I have this table in which each tab has a column with a checkmark ('Interested Lead'). I would like to sum up the total number of checkmarks in the 'Interested Lead" column across all the tabs in this table. 1). What should I use? a function? a r...
Good afternoon!I'd like to create a field that would simply show if a date within the record is within the past year. We already have a field "Date Received" for each record. I'd like to have a field that can quickly show if that date is within the p...
Hey all!Currently, I have a client database with start date {start} and finish date {finish} fields.Once I have added a finish date, I then manually update the {status} field from 'In Progress' to 'Done' - it is a single-select field).However, I'd li...
Hi everyone!I am currently setting up a database to calculate how long a project has been active.This means I'd like a formula that calculates the difference between (a) the start and finish dates or (b) the start and current date (if a finish date h...
Hi! I just moved over here from Quickbase. On QB, when I did a search, all the matching results appeared, and no other records were showing.In my new Airtable, my search results in a single highlighted instance of the matching search result, and I mu...
