Solved

Hello fellow Airtablers! I’m in a bit of a bind trying to put together a formula for what I’m trying to do here. I have 3 different single select fields, which based on if they meet certain criteria, will populate another formula field that’ll show “Complete” or “Incomplete”. That formula is working wonderfully. However, I’m trying to come up with a formula that’ll state the reason as to Why it’s showing as incomplete. I can sort of get it to work for one field, but not multiple. Here is the formula I have for the field that populates with “Complete” or “Incomplete”: IF(AND(Status = "Done", {Billing Status} = "Payment Received", {E-file Status} = "Accepted", {Billed}!=BLANK()), "✔ Complete", "❌ Incomplete") Here’s an image of what it looks like: As you can see, it’s marked as Incomplete, because the billing status is not marked as “Payment Received”. I’m attempting to create a column after the {Final Status} column that will show why it’s marked “Incomplete”. Is this possible? Any hel

I’m wondering how I can transform the formula to date format. I have the date 15/04/2019 20:46, but I got it using formulas. Now I need to add some days, thats why I’m going to use DATEADD. But there is some problem. How I know we can use DATEADD just with date format.

Give me advice please how I can choose just the least sumbol in the cell. Or for example 5 least symbols. Using look up I have many developments, but I want to have just the least one.

I have following table: What i would like to do is append rows, which has identical “Tasks” and sum “Cost” for those. Usually task names could be super unique, so specify their names in formula is no-go. Also Airtable “grouping” functionality is not useful, because afterwards i need to put them in invoice via Page designer. Unfortunately PD don’t provide to group identical columns :frowning: What you would suggest? Thank you.

I have 3 separate fields and I want the 4th field to show a result based on the 3. The responses can be yes, no, maybe If at least 2 of the 3 columns are YES, then result should be YES If at least 2 of the 3 columns are NO, then result should be NO If at least 2 of the 3 columns are MAYBE, then the result should be MAYBE If each column has one response of each, then the result should be MAYBE I am new to Airtable and am more familiar with Excel, so a simple formula or guidance would be helpful. My current Excel has a long formula of nested IF and COUNTIF. Are there equivalents of those on here?

In the Project Tracker example base you can link a Task record to a Project record. How can I do something similar, but only show the Project records that are not “Complete”? Thank you.

Hi. I’ve been struggling to find solution to format formula result into currency. So idea is that I have 4 columns. Hourly price / Time spent / Billable? / Cost €25.00 / 1:20:11 / True / Formula which looks if entry is billable (true/false), and if it is, then calculates cost. If not, set cost as €0 Current formula - IF({Billable?}=“True”,{Hourly rate}*Duration/3600, “€0.00”) What i would like to do is get outcome to be an actual currency, not plain text. If possible, even act as currency value, not only look like it. When i go into Formatting tab, it says - “Your result type is not a number or a date. Formatting options are currently only available if your result type is a number or a date.” An I get result which looks something like this - 33.40972222222222 Any suggestions?

Does Aritable support API keys for specific workspace or database? I do not want to give away access to my whole account.

My experience with using functions is very limited. Please see my current function and result in the screenshot below (I was not able to post an image to this post, I will try to add it in the comment below). I would like the result to be: Brand Guide Webpage or Database - STK, SZ, UWP, TC What should my function be to achieve the desired result?

I have a base that tracks creative campaigns with hard drop dates. I want to be able to calculate a start date for an individual campaign based on the projected number of workdays required to walk the campaign through a production cycle. My production cycles are housed in a related table with a column for each stage and a number in days for the amount of time necessary to complete each stage. Each row has a summed value for the total number of days for the production cycle. In my campaigns table, I want to calculate a start date based on the publish date by subtracting the number of days to complete the production cycle. I’m trying to use the WORKDAY function like so … WORKDAY({Drop Date}, -{Lead Time}) When I give it a drop date of 6/5/2019 and subtract 14 days (the rollup value from my cycles table), it returns a date of 5/27/2019, which represents a difference of 9 workdays in the 14-day stretch I supplied the function. I need to figure out how to subtract 14 workdays, making the ca

I have people submitting records through a form. Records have {Date Ordered} field with creation date. The records are ads that go into publications so there’s a {Print Date} field. I want to flag all orders that come in the day before or the day of print date with “Late Ad” how do I do this?

Hi Airtable, I have a table containing hundreds of units in an apartment building. I am trying to get my contractor on task with specific work orders to each unit (i.e. Replace toilet, replace showerhead, paint walls, etc). My method to do this would be to link that field to another table. The problem I run into is that it only shows one “Replace toilet” with all of the units attached. This would make it act as if he can only check the box once hes completed every single unit. How can I easily make hundreds of separate “replace toilet” work orders that he can check off as he completes?

Im running a stock return spreadsheet and have zapier updating the current price on one column. I then calculate the difference that I bought the stock at vs the current price. I want to add another column that watches for the highest return I have had and the percent return. Is there an if statement that can be watching the price difference and only change the cell if its higher than the previous high I’ve had? Example. I buy a stock for $10 its now at $15. The net profit is $5. My highest return column shows $5. Tomorrow the stock goes to $20, the highest return column now shows $10 because its higher than the $5.

Hello! I am venturing into some of the more robust AirTable features and am stuck on this formula. I need to create a formula where a task ‘Start Date’ is extrapolated from the ‘Project Due Date’, based on the ‘Project Status’. This is what I am attempting: The project due date is 5/30/19 Task 1 is in the ‘Project Kickoff’ stage Task 2 is in the ‘Week 1 - Prototyping’ stage Task 3 is in the ‘Week 2 - Design & Development’ stage Task 4 is in the ‘Week 3 - Design & Development’ stage I want the due date for task 1 to be 4 weeks BEFORE the project due date. (5/2/19) I want the due date for task 2 to be 3 weeks BEFORE the project due date. (5/9/19) I want the due date for task 3 to be 2 weeks BEFORE the project due date. (5/16/19) I want the due date for task 4 to be 1 week BEFORE the project due date. (5/23/19) I’ve been trying to use nested IF formulas, combined with the DATEADD formula, but not having any luck. Help!

IF( AND( {Date target goals to be published*} <= NOW(), {Link Building Status} = “Posted/Scheduled” ), “Live”, IF(AND({Date target goals to be published*} < NOW(), {Link Building Status} != “Posted/Scheduled”), “Past Due”, IF(AND({Date target goals to be published*} > NOW(), {Link Building Status} = “Posted/Scheduled”), “Scheduled”) ) ) Hi I am using this formula. And it works well except for 1 thing. It is returning “past due” on the field 12 on the same day it is due. Is there anyway to make it return a result of past due after the actual day of due. Airtable Airtable: Organize anything you can imagine Airtable works like a spreadsheet but gives you the power of a database to organize anything. Sign up for free.

I calculate a member’s upcoming birthday by using formula. IF({birthday} = “”, “”,DATETIME_FORMAT(DATEADD({birthday}, DATETIME_DIFF(TODAY(), {birthday}, ‘years’) + 1, ‘year’), “YYYY-MM-DD”)) So if someone’s birthday is 1980-05-20, the field will show 2017-05-20. I want to show this in a calendar view. However it does not allow a Formula field (only allows static Date field). Is there a way to set the calculated field to have date-time format?

Hello all :slightly_smiling_face: I’m trying to work out a formula that establishes whether to charge VAT on a product or not but can’t seem to get the IF/AND/OR statement correct. The conditions that I require are as follows: If Gender is equal to “Boy’s” or “Girl’s” then 0% or If Gender is equal to “Men’s” and Size is less than 6.5 then 0% or If Gender is equal to “Women’s” and Size is less than 5.5 and Heel Height is less than 4 then 0% Else 20% I’m stuck in a bit of a black hole trying to figure this one out - any suggestions/examples on how to get this going or where to get started would be most appreciated!

Hi everyone ! Here’s a very simple formula : IF( {Edition}=1, {Genuine Console Family}, IF( NOT( AND( {Accessories list}, {Games} ) ), {Genuine Console Family} ) ) I don’t know why, the first IF doesn’t work at all. I check the checkbox and nothing happens. But, when Accessories list and Games have values, I can check and the field is fill with the right value (Genuine Console Family). Thanks a lot for any help.

Hi, I have had a lot of success using formulas in the past, but I am stumped on how to properly format the following: I have three columns: Email, Phone, and Wants Follow Up? I have been stumped on making a formula where IF the Email cell OR the Phone number cell is filled out (AKA not blank), then the output will be a YES in the Wants Follow Up? cell. I know I must be making an simple mistake, because the formulas I have tried only give a YES output if both the Phone and Email cells are filled out, not either-or. The actual OR formula as shown on the Airtable help section just outputs a 1, but I want YES text to be shown, not a 1. What am I not doing correctly? Thanks!

Some of my photos are not loading into airtable and I am wondering if there is a resolution limitation and this is causing me restrictions? Any suggestions?

Hi everyone. I’ve been banging my head against this for a while now and decided to ask the community. In Google Sheets I had a spreadsheet with 2 sheets. One was holding expenditures and with dates, and a formula was used to derive a month and year of the expense. (5/2018, 6/2018, etc). So in an example where I had multiple expenses in a month each would have a separate line with the date, amount (column G), some description, and at the end the ‘month’ formula field (column H). The second sheet had a 1st column of all months/years value since the records began (Column A), and then a SUMIF(Sheet1!H:H,An,Sheet1:G:G) I’ve got the tables set up in AirTable, just trying to get the last table to add up all values of a specified column if another column has the same value as the row’s first column in the new table. Hope this makes sense … Can it be done?

I’m experiencing a condition where typing in a Long Text cell does not produce all letters. Typing the full alphabet (abcde . . . wxyz) produces only the letters “dghjkloqruvwxyz.” This only happens on one computer I have (Windows 7, Chrome browser), and only in Airtable on that computer (Word, Excel, etc. are fine). Typing in other field types (Single Line Text, email, URL) seems to work fine. This happens in my own bases and in the Airtable sample bases I have in my workspace. I’ve tried using a different keyboard on that computer but still experience the issue. I’ve also tried clearing my browser cache and deleting Airtable cookies, etc., and have tried logging out of Airtable and back in. I’m able to type normally in my bases on my Windows 10 laptop. Any thoughts on how I can get my Long Text fields working again? I’ve emailed support. Thanks, Steve

Hi there I’d like to use the datetime_diff() function to compare a date in the {Date} column of each record to a fixed date: 29 March 2019. I can’t seem to figure out the syntax to insert that fixed date into the formula: datetime_diff({Date}, [what syntax to make 2019-03-29 a datetime?], ‘days’} Thanks Travis

Hi all, I have a form which asks the user to input student numbers from an excel/google sheet into a long text field. This will happen weekly. How might I take each of these student numbers (separated by a space) and put them onto a separate record (where student number is the primary key) in a separate table? Happy for other suggestions.

Hello Everyone, I’m very new with AirTable and I have been struggling with this formula. I have these 3 different columns: 1) Lead Count, 2) Opportunity Count 3) Total Amount ($). I’m creating a formula to select the Account Status based on these three columns in this way: If Lead Count = 0 --> “Cold” If Lead Count = 1 --> “Aware” If Lead Count >1 --> “Qualified” OR If Opportunity Count >0 --> Opportunity (regardless of Lead Count) If Total Amount ($) > 0 --> Customer (regardless of anything else) How can I put this into a formula?