Formulas

Hello, I’m new to Airtable. That’s why I’m asking for help with something I can’t solve. I have two tables. One is Class Attendance and one is Lesson List. The Class Attendance table includes student names, student ID rows and course dates columns. If I write the value of 1 in the course date column, the student is enrolled in that course. If I leave it blank, it is not entered. And I also created a formula column and wrote this formula. ( COUNT({2021-10-05},{2021-10-06},{2021-10-13},{2021-10-23}) / COUNTALL({2021-10-05},{2021-10-06},{2021-10-13},{2021-10-23}) ) *100 This formula is the number of courses taken by the student/total number of courses. The result is the student’s success score. In the Course List table, I wrote the course dates, assuming that the course dates were determined in advance. I opened a new column and put a checkbox. I will tick the checkbox after that lesson is complete. What I want to do is to automatically create a new c

Hi Everyone, I have been trying to accomplish an error check and I have syntax issue on the below formula. May I please know what is the issue with my formula? Thank you so much in advance. IF(AND({est_filing_date_range_start},{est_filing_date_range_end},{actual_or_estimated}!=BLANK())AND({review_type}=BLANK()),“ :stop_sign: ERROR…review_type CANNOT BE BLANK when est_filing_date_range_start, est_filing_date_range_end,actual_or_estimated fields are populated”, ",“ :white_check_mark: GOOD”)

Hi Airtable community! I’m looking for a formula which fetches collaborator IDs The reason is, I want to assign through another formulas a set of teams. So, if user 1 is true in the ID column, return text value “team 1” If that makes s3ense!

Hi! I’m trying to aggregate multilingual survey answers using a formula. I will eventually need this format of formula for more complex data, but I am stumped at the beginning part of getting at least three statements to all say ‘YES’ if there is a ‘yes’ in one column or a ‘Si’ in another or a ‘容易 - Yes’ in another. This formula works :IF({Was it easy for you to order a meal through the current texting system? CHINESE}=‘容易 - Yes’, ‘YES’) But then I want to build upon it by adding the conditions IF or even OR it doesn’t work. For example, this does not work: IF({Was it easy for you to order a meal through the current texting system? CHINESE}=‘容易 - Yes’, ‘YES’) OR(IF( {Was it easy for you to order a meal through the current texting system?}=‘Yes’,‘YES’)) Does anyone have any ideas of how to make what I want to happen/guidance on what I’m doing i

Hi, I need help from your brain because mine is out for this problem ! Actually i have this formula : IF(IS_SAME({Date d’envoi}, TODAY(), ‘day’), ‘YES’) To this formule i want to add 2 things : if the date is after today add “AFTER” if the date is before today add “BEFORE” Finally, i need to have 3 conditions : YES if today AFTER if the date is after today BEFORE if the date is before today Thank’s for your help ! Matthieu

Hello beautiful people. I hope you guys are doing great, I am working on a formula that determines Time (no of dates to be added to ) A start point ( Material receive date) So We are working on localization the titles that we have:: Some of them need En Dubbing others need Ar subtitling only, other need nothing. So This image above, shows how I can indicate which titles need what to be processed. There are some rules estimation for each process, to be taken in consideration this calculation is on 45 Min for each asset So Depending on those Hours given for each episode (45 Min ) Ave I would like to get the Delivery Date for each title depending on the processing time for each title. to add up on the delivery date. Please put in

Hello. I need some help with my Airtable. I would like to do some discount calculation. Column 1: Total price of purchased products Column 2: single select, select Yes if customer is VIP, then will give 5% off Column 3: optional further discount, also a single select Column 4: Discounted price after column 3 and 4 I would like to know if I could create a formula that after I selected “yes” on column 3, then Discounted price would automatically do the calculation for me. Thank you.

I am basically trying to calculate how much a PayPal fee is by multiplying the item price by their fee (3.49% + .49 cents per transaction) I tried using the Airtable guide but it kept saying it was invalid and whatnot. Buuut, of course, the ol’ Google formula does not work because this isn’t Google Sheets. :slightly_smiling_face:

I have a a Multiple Select Field which I am trying to substitute spaces with hyphens. The issue that I am running against is that the is space between items and the formula adds an extra hyphen in the final result. I am using LOWER(SUBSTITUTE(Series, " ", “-”)) See screenshot for field details and results. Thanks for the help!! substitute issue|700x237

Hi everyone :slightly_smiling_face: I’m very new here and I’m still trying to learn this immense platform. I just attached the image of what I am working on. I would love Airtable to pick up the duration of each topic and update the start and end For example “hosting introduction” is 3 mins, starts at 12:00pm and finish at 12:03pm The next topic is “industry updates” and it will last 7 mins starting from 12:03 til 12:10. Does anyone know a formula that will calculate the time? Thank you so much to everyone who will read this :grinning_face_with_smiling_eyes:

Hello All! Not sure I should ask this question in Formulas. On a list of multiple versions of a same item I’d like to only display the last one. Here is what I have: Here what I wish to obtain: Thanks in advance!

Hello community, I have a problem that is when I scan a barcode with my tablet the following characters are displayed like this: 0096 UNIT0855 121F21 I would like it to be displayed like this: 0096UNIT0855121F21 So I would like a formula that allows me to do this task automatically. Could someone please help me?

Hi Everyone, I’ve come across an issue where I can’t seem to get the date to print the correct time within a formula. Please see example, I’ve stripped it down ot its bare bones. On the left is a date (and the time is correct). On the right is that date reprinted as a function. It appears to be an hour off. This is the formula for the function (simply reprinting the date): It also gives the same result (incorrect) if I set the time to my time zone, which is GMT. Any help appreciated

Hello, Trying to populate a single select based on text in another field. Sometimes I want it automatic, sometimes it needs to be manual, so a formula field alone isn’t appropriate. Currently running a nested IF formula, but I just need help with the syntax to make it choose X, Y, or Z from a single select field instead of printing it in the fomula field. Any help greatly appreciated. Thanks! The formula (which is working great for printing XYZ in the formula field): IF( SEARCH("x", {Column A}), "X", IF( SEARCH("y", {Column A}), "Y", IF( SEARCH("z", {Column A}), "Z" ) ) )

I am looking to create a formula where if my date field is between certain dates then my quarter field would tag appropriately. So if the date is between 10/01/21 - 12/31/21 then the field “Quarter” would say Quarter 4. If the date is between 1/1/22 - 4/1/22 then the field “Quarter” would say Quarter 1. I don’t if this can be done with formulas or if there is a better way to do this but would love any help/suggestions to automate the process of manually updating my quarter field.

Hi! I’m trying to display ‘Yes’ on records that fall between Monday and Sunday of the Previous week, no matter what day of the week it currently is. My code works, but only if it you’re looking at it on the Monday of this week, otherwise it’s off. IF( AND( IS_AFTER( {Completed Date}, DATEADD(TODAY(),-8,'days')), IS_BEFORE( {Completed Date}, DATEADD(TODAY(),-0,'days') ) ), 'Yes','No' ) I’ve also tried this, but again it has to be run on the Monday of the current week to be accurate… IF( AND( IS_AFTER( {Completed Date}, DATEADD(TODAY(), -8*(WEEKDAY(TODAY(), 'Monday')+1),'day') ), IS_BEFORE( {Completed Date}, DATEADD(TODAY(), 0-WEEKDAY(TODAY(), 'Monday'),'day') ) ), 'Yes','No' ) I Hope someone can help me out :slightly_smiling_face:

Hi all, The review process for our Creative team typically consists of two reviews prior to the final asset being uploaded to Airtable. Because of our review process, the Project Manager is responsible for assigning three due dates to each line item (asset) within the Creative table: V1 Due Date, V2 Due Date, Final Due Date. I would like to have the option to hide all three of the fields listed above and have a formula field that will display only the Next Due Date in a user friendly format. Please see below for the set up of the date columns mentioned with examples. The “Next Due Date” column is currently blank as I try to come up with this formula. A nested IF statement should do the trick, just haven’t yet figured it out! Any help is greatly appreciated!

if (Check if Not Converted)=1, {Exchange}*{Total} cant seem to get this to work any help appreciated ty

Hello, I have a url type field with the url of an image, and I would like to know if it is possible to create an attachment automatically with a formula to upload the image in Airtable from its url. example : field_image_url: “https: //coolimage.png” field_airtable_image: UPLOAD HERE

Hello! I’m able to make this formula work but I keep getting errors when I try to insert ‘WORKDAY’ into it: IF({Original Release Date}, DATEADD({Original Release Date}, VALUE(’’ & {Days Needed Before Release}), ‘days’, ‘’)) I am trying to return the closest workday after subtracting a formulated number of days from my original release date. Thanks!

Odd thing when creating a formula the help pop to the left no longer appears. Is there some setting I need to enable.

Hello, I am looking for a formula that could help me achieve the same outcome that I could do in Excel using an index & match array formula. I am trying to group classification data based on the hierarchy. You can see from my excel screenshot below, Column1 is what I am trying to achieve. =INDEX([Code tite],MATCH([@[Grouping code]],[Code],0),1) Here is a link to my airtable view: Airtable - Share Here is a link to the excel: AirtableIndexMatchFormulaArray.xlsx Thank you very much!! Alex

my locale format was DD/MM/YYYY i try make it work but it looks like this! Screenshot (3)|652x222 i really wanna know why keep telling March NOT August

Multiple Substitute in Airtable, I have one field that contains jebirish information but it contains one of the information. like ’ Field updated UNDO Your Account Name: Reillence Lester Diocson Your Account Number: 9189160337 Your Pin Number: 860503 I want to make a formula get the Account Number only not the Jiberish character. How should I do this?

Hello, I am trying to use an IF formula to equal a date but can’t find how to do it. I want to create IF({WEEK} = “Wk 1”, “15/01/22” example. wk 1 = 15/01/22 wk 2 = 23/02/22 Wk 3 = 30/02/22 Does anyone know how to do this? Thanks