Formulas

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?

Hello Community, I’m having an issue with a substitute function I hope you ban help with. I need to substitute certain numbers in a string that includes quote marks, and I get errors or invalid formulas in every try This is my original string, I have it in a separate field called _bto _data a:2:{i:1595610800;a:29:{s:10:“query_type”;s:12:“category_ids”;s:21:“assigned_category_ids”;a:1:{i:0;i:227;}s:14:“selection_mode”;s:9:“dropdowns”;s:10:“default_id”;s:4:“2615”;s:5:“title”;s:26:“Elige la base de tu Anillo”;s:11:“description”;s:97:“Selecciona una de las opciones de la lista con el metal, talla y piedras secundarias que deseas. “;s:12:“thumbnail_id”;s:0:””;s:12:“quantity_min”;i:1;s:12:“quantity_max”;i:1;s:8:“discount”;s:0:"";s:19:“priced_individually”;s:3:“yes”;s:20:“shipped_individually”;s:2:“no”;s:8:“optional”;s:2:“no”;s:14:“display_prices”;s:8:“absolute”;s:13:“select_action”;s:4:“view”;s:18:“hide_product_title”;s:2:“no”;s:24:“hide_product_description”;s:

Hi guys, I really need help with setting up the search formula for my specific case. We have an attendees email column in Airtable, which each cell will includes multi emails, e.g. email1, email2, email3. In the zap, I need to search certain email in this column, and find the right row, then read the other related info from the same row. I used the FIND("{{94825201__hidden_email}}",{AttendeeEmails}) in the search formula in Zap, which works, but it doesn’t apply to find the exact same email, e.g larose@test.com (let’s say email A), and rose@test.com (let’s say email B), when searching B, the system will find A. Then I changed the formula to FIND(", {{94825201__hidden_email}}",{AttendeeEmails}), added ", " into, which can help to find e.g “, A”, but this doesn’t apply to the first email address, since there’s no ", " before it. Does anyone have an

I have two fields in a table for a sheet music library: Last Name and Given Names. Is there a formula expression that will produce the initials for the given names? For example, If the Given Names field is just “Johann”, I would like to produce the string “J.”. If the Given Names field is “Johann Sebastion”, I would like to produce the string, "J. S. ". If the Given Names field is “Carl Philipp Emanuel”, I would like to produce the string, "C. P. E. ". Etc. Thank you for any comments. DG

Hello, I’m trying to create an automatic file numbering scheme for my project list and file list. I’ve read some of the other posts on this but can’t get my specific need. I’d like the filing scheme to be: year (last 2 digits) + 3 digit sequential number: so 20-001, 20-002, etc. I figured out how to pull out the string value for the year from current date (i.e. “20”) and I’ve figured out how to sequentially number entries. But I can’t get the two together. For example, when 2021 starts, I want the numbering to reset to 001. Is there anyway to do that? Many thanks,

I am looking for a way to trigger a timestamp when a status changes. This is for an article writing process and we have 3 status options, (In Creation, In Review, Complete). I want a timestamp to take place when the status is changed between each status so at the end, I can calculate how many days the article was in each status. I am hoping to do this so the timestamp doesn’t override itself when the status changes but can help me see how long it stayed in each status. I know how to trigger a timestamp using a checkbox but want the status change to trigger that on its own. THANKS SO MUCH FOR THE HELP!

Hi Folks, I need help writing a formula that returns only data for this week related to a release date I know this formula works IF(WEEKNUM({Release Date})=WEEKNUM(TODAY()),“this week”,“NOT”) However, it still shows me content released for the next year same as this week. I only want to work on the current year not all years in my view. Thanks, A lot for your time

Hi, for my academic research database I’m trying to write a formula that will automatically extract a four-digit number from a cell (i.e. extracting year from a citekey). For example (Citekey --> Year), Downs1965NonmarketDecisionMaking --> 1965 Welborn1968BureaucracyAnthonyDowns --> 1968 Any ideas on how I might be able to do this? Thanks.