Solved

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?

We are looking to build a risk matrix like the attached graphic using AirTable. The table would be a list of risks with drop-downs to assign the occurrence and probability. That part is easy enough, but then I also want to bin it into the High/Med/Low category based on a lookup table. Still doable. Where my challenge is is formatting the grid to have the appropriate colors. I tried conditional formatting, but it does not carry into the grid, as there’s no option in the color. Any ideas on how to solve this?

Hi guys, I’m new to formulas and having trouble figuring out the correct formula for my needs. I have 4 fields: Sale Total (Currency), Split (multiple select), My Portion (Currency), & Commission (Formula). What I’m trying to get the Commision formula to do: If Split field is empty (none selected) = Calculate 30% of sum from “Sale Total” field. But if there is anything at all selected in the Split field = Calculate the 30% from the “My Portion” field instead. What is the formula to achieve this? Thanks in advance for your help!!

Hi, Is it possible to create multiple records in one API request? The API documents only speak of creating one record at a time. I have a quiz app and want to post the answers (one answer per record) to my AirTable, but since the AirTable API has a rate limit of 5 requests per second, I can’t just dump the answers via multiple requests, so want to post them all at once. Is it possible? Thanks!

I’m trying to work out some hire prices using a formula, where the weekly cost of item is used to calculate the daily cost of it. I have an item that cost me £1000, and I have decided that the weekly hire price is this figure divided by 10, so £100 a week. The daily price is calculated by dividing that by 3, so £33.33. However, I want the spreadsheet to round this up to £33.50. How do I use the ROUND function to do this? At the moment I have: Weekly cost = {Purchase Cost}/10 Then, daily cost = {Weekly Cost}/3 For both, I want it to round to the next 50p. Thanks!

I recently discovered that when I multiply 6.1 * 3, and convert the product to a string using product & “” the result is a string with repeating decimals, even though the numeric result is simply 18.3. This is actually causing a serious problem in my table when formatting prices for invoices. Any insight is appreciated, thanks!

Dear Airtable, I am trying to automate something. I am having people submit a form. In this form, Column/Question 2 corresponds to a Multiple Select field where they can select their name from a dropdown. Column/Question 3 is where they input a time and then they hit submit I want the value from Sheet 2 Person A Column 3 to add with the value on Sheet 1 Person A Column 3, value from Sheet 2 Person B Column 3 to add with the value on Sheet 2 Person B Column 3 etc. I have spent the past 3 days trying to figure it out with rollup and I’m still super confused. Any help is appreciated. Thanks in advance!

I have two types of contacts in our CRM. I would like to be able to show certain fields for one type and show other fields for the other type. Is this possible to have this behavior? Thanks.

Hi How do I do the interactive tutorial on this community forum? Here is the screenshot of the Badge description: Thank you, Mary P.S. Another member was looking for this too, so I hope I will be able to find it, so I can do the tutorial. Mary

Airtable Gurus, I need help! I’m looking for a way to return all the field names that contain a certain value. Let me explain: I’m gathering documents from clients, and I’ve sent them a survey asking them what types of documents they have, and in what form. The survey contained multiple questions along these lines: Do you have documents relating to Topic X? Check all that apply: [ ] Emails [ ] Hard Copy Documents [ ] Electronic Documents As a result, I have many multiple-select Document Category Fields that contain one or more of the “Document Format” responses (e.g., “Emails,” “Hard Copy,” etc.). What I’d like to do is now generate a list for each client of all the documents they said they had, so that I can follow up on each category and ensure that we’ve collected everything they have. The way I imagine this working (although I’m open to other suggestions), is a single field for each document category, which would search in each Document Category Field for a particular Docum

I’m writing a php script in which I need to fetch all records from a certain base of about 1000 records (and store them in one array so I can handle some stuff). As I understand the max pageSize is 100, but with the offset it returns and using this as a parameter in your next request you can get the next pages. But this doesn’t seem to really work. I can get a few pages (actually sometimes just one) until it throws the error LIST_RECORDS_ITERATOR_NOT_AVAILABLE on me. I simply never am able to fetch every page. This error always occurs. How can I proceed from this error to be able to fetch every record? Am I missing something? A snippet from my code: //curl code ... curl_close($ch); $airtable_response = json_decode($entries, TRUE); foreach ($airtable_response["records"] as $key => $record) { $all_records[] = $record; } // Next page if there is one if( $airtable_response['offset'] ) { fetch_records($url . "?offset=" . $airtable_response['offset']); } else { return $all_records; }

Newbie here. I have a school table with a list of schools, a School district table, and a Contacts table. Schools are linked to school districts. Contacts can be linked to a school OR a school district. What I am trying to do is enter a new contact in the contacts table:. If the contact is related to a school, I choose the school in the school field and the district field is auto-populated If the contact is a district contact (no school) I want to be able to type in or choose the district in the same District field. I don’t know how to accomplish both in the same district field.

Hi there I am just getting started with air table and am stuck on something. Say I have a table which is categories of tasks, and then I want within each category to have actual tasks. Is there a way that I can click on something in the higher level table (a category) and then go to the lower level table, but only see the tasks associated with that category, without having to filter the tasks by the category field? - i.e. it would auto-filter the task table based on what I had clicked on? I know it will seem like, in this situation, it isn’t that hard to just then filter, but this is just an example of how I want to use it - I want to be able to drill-down into data which is all nested.