Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Link to another record across multiple tables

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...

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

Making a single selection from within a multiselect field range

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....

jedstrom by 4 - Data Explorer
  • 4 replies
  • 2 kudos

Resolved! regex email validation doesn't work

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...

NitaiLS by 5 - Automation Enthusiast
  • 7 replies
  • 2 kudos

Trying to create an "averageif" in airtable

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...

cs by 4 - Data Explorer
  • 5 replies
  • 2 kudos

Display if the field has a number

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...

fields.jpg Formula.jpg

Resolved! Attachment URLS

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 -...


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...

Formula IF statement pulls data from a specific row + cell

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 ...

Three If formulas not working

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"...

imomarsx by 4 - Data Explorer
  • 3 replies
  • 0 kudos

batch_create: How can I format date for API call

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...

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

Tallying total votes/selections across all records

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 ...

Ace by 4 - Data Explorer
  • 2 replies
  • 3 kudos

Resolved! Get Latest Date Summary based on all records in another table

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...

Schermafbeelding 2023-02-23 om 10.47.07.png Schermafbeelding 2023-02-23 om 11.36.59.png
stenkate by 6 - Interface Innovator
  • 4 replies
  • 2 kudos

Sum up COUNTIF across multiple tabs in a table.

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...

JDC_361 by 4 - Data Explorer
  • 8 replies
  • 0 kudos

Formula to show if a date is within the past year

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...

Hal_Atkins by 5 - Automation Enthusiast
  • 1 replies
  • 1 kudos

Resolved! Date Toggle Automation

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...

Harrry by 5 - Automation Enthusiast
  • 4 replies
  • 3 kudos

Resolved! Airtable Date Calculation

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...

Harrry by 5 - Automation Enthusiast
  • 2 replies
  • 1 kudos

Display Options

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...

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