Formulas

Hi, I would like to achieve something that seems basic but i can’t find a solution. I have a table of contacts, another table of companies and of third one of projets. I link a contact to a company and a company to a specific project. I have several contacts for each company and i would like to link a project to a specific contact. I obviously can link the project to a contacts but i would like to only be able to select someone from the company in charge of the project. At this point i can pic any contact. I know that we can make a condition on a specific view but the view as to be “dynamic”. I don’t want to manually create a view for each company. Thanks for your healp!

I have a table that contains my users, and their current balance of chips in a casino. I’m building a leaderboard that will tell them who the top five chip holders are. (This is the easy part.) I also want to tell them what place THEY are in, if they’re not in the top five. This requires one of two solutions: Grab all of the data, and iterate through it until I find the user. This is a heavy operation, because I’d have to pull all of the user data to my application before iterating through all of it. Have a ranked column that automatically updates every time that a user’s balance changes, much like Lookup, Rollup, or Formula fields. This is my preferred approach, but I can’t figure out how to do this. Do any of you amazing people have some guidance or advice? Thanks!

When calculating the difference between two dates it gives me NAN, since one of the cells is empty. ¿How can i fix it? Help me :blush: IF( AND( {start_isolete}, NOT(DATETIME_DIFF({date_out}, {start_isolete}, ‘days’) < 1) ), DATETIME_DIFF({date_out}, {start_isolete}, ‘days’) )

Hi, I need some help creating a formula. I currently have the following set up: Table1 Primary column = text Start column = date End column = date Table2 Primary column = date Notes column = text In Table1, I’d like to display what Table2 records exist that are in between the Start and End dates for each Table1 record. Any advice would be appreciated!

Hello all! I have a question. I would like to create a formula with 2 conditions. IF “Item” in row 1 = “item” in row 2 AND “P” in row 1 is equal to “P” in row 2 then “it’s ok” otherwise “it’s not” Do you think it’s possible? Thanks for your help!

Hello all! I wouldlike to know if it’s possible to have in the column “test” all the items which are in the same period. For example in the first row of the colum “test” the result would be “FRT54522” because “FRT54522” has a period in common with “FRT5678C”. Many thanks for your help :slightly_smiling_face:

I’m having a strange issue with my formula, it’s been working for the past year but then all of a sudden it didn’t seem to be updating. I ended up fixing it by duplicating the formula into a completely new field and it seems to work on the new field, but I don’t want to break any old references, etc. Any ideas what’s going on?

Hello all, Il have concatenate 3 cells and it gives something like that “FRT5678C9Validated”. I wouldlike to count in another column the number of time it appears in the fist column. As you see “FRT5678C9Validated” appears 2 times but it only counts 1. Can you help me please? Thanks and have a nice WE! For

Hello there! I have following problem: My database primary field is a date. I do entrys just like in a diary. For each entry, I can choose the select field 1 or select field 2 as type. Now I want to count all input fields in concurrence between select field 1 and select field 2 and display it in a third field. So for example: Name / Input Field / Accumulated Select field 1 - empty - empty Select field 2 - 100 - 100 Select field 2 - 150 - 250 Select field 2 - 125 - 375 Select field 2 - 25 - 400 Select field 2 - 100 - 500 Select field 1 - empty - empty Select field 2 - 50 - 50 Select field 2 - 100 - 150 … I know want a third field that displays the sum or accumulated value of input field between the two select field 1. The table is sorted by the date field. Is this in a

To give some background, I work at a fitness company; we treat “classes” as projects. Looking to: Count number of classes scheduled in a specific week. Count number of filmed, scheduled classes in that week Find out what the percentage is of scheduled vs. filmed and if possible, show in a block

hi, how can i use text with quotation marks inside of an if-statement? my simplified case: IF(Item = “string”, 1, 0) my string looks sth like this: ‘product “type” extension’ but it doesnt recognise the strings if they contain ", which the entry im trying to work with does. ‘string’ doesnt work either

Hi, I am creating a schedule, the schedule us currently ordered by start time. I have a formula that adds duration to start time to create an end time. However whenever I change a duration the order does not change automatically, this is because the start time is not connected to the previous session’s end time. Is there anyway to do this so that the start time equals the end time of the previous row?

I believe I need a script rather than a combo of filtered views/linked fields/conditional rollups to accomplish my goal: I have 3 tables: Employees, Seminars, Registrations I’m trying to populate a field in the Registrations table with a sum of values contained in the Seminars table IF certain conditions are met when compared against other fields in the Registrations table. Below is my best effort at writing this out…obviously not actual JavaScript or Airtable syntax, but hopefully its a start. Tables are bold, fields are italic. Registrations PDH Earned is sum of Seminars/Webinars (PDH) IF Seminars/Webinars Attendees contains Registrations Employee AND IF Seminars/Webinars Date is (>= Registrations Previous Renewal

I wanted to make the primary field of a table into a link to another table. (Like using a foreign key as part of a primary key in a database.) Of course, I immediately discovered that was not allowed. So, I created a new field, made it a link, then used a formula in the primary field to copy the value of new field (that was now a link field) to the primary field. To test whether that would be allowed, I created an exceedingly simple formula in the primary field. It was just the field name of the new field that was created to be the link to another table. At first, I thought it worked perfectly. But, later I realized that there was a problem. If the text string in the link field (which was the value from the primary field in the other table) contained a comma, Airtable automatically enclosed the whole string in double quotation marks. If the text string in the link field did not contain a comma, Airtable simply copied the text string without adding double quotati

I use lots of formulas that pull in a single-select field as part of the data, but I have one that’s mangling the select options, and I don’t know what’s messing it up. Any help anyone’s got is appreciated!

Hello, I’m having an issue with comparing two different dates to figure out how many days elapsed from the date listed to the date sold. Here’s my formula below that I’m currently using. How can I alter the formula so that if there are no dates entered into those fields it will just show up blank? Thanks for any help you can provide! DATETIME_DIFF({Sold On},{Listed},‘days’) & ’ Days’

Hi all, I’ve a table with all teams and other table with the standings of the matches. Now I want create a field with the trend of the tournament, for example a field with last 5 positions? Someone know a formulas to do this? Team Table In this case I want in Trend field about Team A this values:1,3,1 Tournament Table Thanks

Hi. Noob alert! This is my first attempt at formulas of this nature. I am trying to concate an address (Street 1, Street 2, City, State, Postcode, Country), separated by a comma and space (", "). However, most addresses I enter do not fill the ‘Street 2’ cell, which results in an additional ", " in the formula outcome. I have spent hours trying to correct this and cannot figure it out. I would be grateful for any assistance! Thank you. Here is an image of the issue:

Is it possible to automatically pull EXIF data from an image uploaded on a form created with Airtable and add it to a form. So the user fills in our form and uploads an image. When the image is received then the EXIF data is automatically pulled from the image and filled into file on the admin console? I am looking to pull the gps data in the image. They type of camera. The date and time. etc Any assistance will be appreciated.

I am trying to automate affiliate links. Sounds so easy! What we know: <a href=“http://Internet URL goes here.”>Title the visitor sees. My two fields are Affiliate Company Name and BITLY (the url) What is the formula for my HTML link? Concatenate? I am stuck. Searched other posts and I could not get this. Thank you!!

Example for a service department we received in a part 08/31/20 and complete the repair 09/03/20. I have my dates set up for admins to enter but I need to show total days to completion. I;ve tried =DAYS and DIFFERENT_DAYS but can’t get them to work. SHould I just export to excel and do it there?

I know I’m overlooking something here but I can’t figure out what that is. I’m trying to create a Publishing Status field using nested IF statements. So far, I’ve only tested the first few statements, but I can’t get anything other than step 1 to show. I still need to add all of this: IF(Done =NOT(Blank()), “step 15”, IF(Published =NOT(BLANK()), “step 14”, IF(Uploaded =NOT(BLANK()), “step 13”, IF(Accepted =NOT(BLANK()), “step 12”, IF({Client Approves Draft} = NOT(BLANK()), “step 11”, IF({Draft Delivery URL} = NOT(BLANK()), “step 10”, IF({Senior Draft Review} =NOT(BLANK()), “step 9”, IF({Internal Draft URL} =NOT(BLANK()), “step 8”, IF({Client Approves Outline} =NOT(BLANK()), “step 7”, IF({Outline Delivery URL} =NOT(BLANK()), “step 6”, IF({Senior Outline Review} =NOT(BLANK()), “step 5”, IF({In

Hi there! I’m an Airtable noob, but a spreadsheet lover. I’m trying to create a formula (Switch looked like the best), that will create custom dates based on the “Task Name.” It involves date math based on “Original Publish Date” field which is a date. Here is a rough example of what I’m trying: SWITCH( {Task Name}, “Create Illustration”, DATEADD({Original Publish Date},-14,‘days’), “Generate blog post and schedule post”, DATEADD({Original Publish Date},-13,‘days’), “Create snippets for social media”, DATEADD({Original Publish Date},-12,‘days’), ) I’ve tried paranthesis around dateadd and end before the comma. That didn’t work either. Is this possible? I see other formulas that seem to work.

Hi, I have a real problem dealing with the button field’s open URL feature & also the formula field. What I’m trying to do is to pre-fill two form fields by clicking a button. What I did is I followed your tutorials to create the formula for the button field, but it throws an error that the formula is not right. My formula is: VIEWLINK&prefill_Scheduled+Session={Scheduled%20Session}&prefill_Task+Number={Task%20Number} I don’t know exactly where is the error is, I tried replacing the (+) sign with “%20” and tried putting “” before and after the URL, and also tried to replace the “&” after the URL to “?”. I just want to prefill these two fields when I click on the button and leave other fields to be populated manually. How can I do that? Thanks,

I’m not sure why this one isn’t working, because I’ve tried copying and pasting from another base where this formula DOES work. I’m trying to write an IF statement for the Gift ID. If “Donor Account” is not blank, GIFT ID should pull Donor Account after the date. If it IS blank, it should pull Company. This is my starting point, but it’s telling me it’s not a real formula. (DATETIME_FORMAT({Date of donation}, ‘M/D/YYYY’) & " — ") & IF(Donor account, Donor account,Company) Thoughts?