Hi everyone! In one table, i got Name + Surname + Email AddressIn another table, i only got Email Address, but i need to fill in the Name + Surname that i have in the other table.How could i do this?Thanks a lotMarco
I cannot decide if I'm better off with an automation or else I'm just not meant to do if else formulas. I need to first check if a date field is not blank. If it is not blank, then I want to compare it with another date field. If it's later than othe...
Hey all, first post in here. Has anyone else noticed that when creating a view and setting the filters (particularly on conditions relating to a date field that includes a time) there is no way to set the filter to read hours rather than days? My use...
Hello below is a table of scores and the corresponding status. I also have a risk register for each risk I want to be able to select the probability (1-5) and the Imapct (1-5) and it automatically returns the status as defined by the table below. Is ...
Hi,To explain a bit : We have workshops that happen on different dates and people can register to those in a form.So I created a formula with the name of the workshop + the date of the workshop. I want that, in the form, people can only chose on date...
Hi, I'm trying to make a formula that combines different records to a readable title.I'd like to add the Product field to the formula, but only if it has not more than one value and only if the value is not 'Algemeen'. The last part I can fix, but I ...
Hello, I would like to create an invitation form for a party with 150 people maximum. The first 150 registrants receive an automatic email to confirm their participation and the others an email explaining to them that they are on the waiting list.Eac...
I have 5 fields (WBS1, WBS2, WBS3, WBS4, WBS5) which are all different levels of WBS and I have a formula that combines it all into 1 number: WBS1& IF(WBS2="","","."&WBS2 & IF(WBS3="","", "."&WBS3 &IF(WBS4="","","."&WBS4 &IF(WBS5="","","."&WBS5)))) T...
Trouble with date formula: September 14, 2023 + Coaching=Coaching 2023-09-16T04:00:00.000Z. CONCATENATE({Mtg Type} & ' ' & {date test})The date always comes out wrong in the Concatenation.
Hello, all.I'm new to Airtable and I need to create a form that tracks how many hours my coaching team is meeting with individuals each month. Each entry would be a new meeting, and I meet with individuals only once each month. Ideally, it would all ...
Hi folks,I'm have a dataset of events in Airtable with each event as a row, and each row has a different number of sessions that can make up the complete event. This means I have 8 end date & time columns to capture the finish time of each session. I...
Hello everyone. I am trying to create a formula with the following logic: I have two fields (A and B) and these fields can contain different kind of values. Let's say that field A contains value A and field B contains value B, then I want the formul...
I'm trying to improve the content calendar we are using. I have a Content Field, which is the full post that we're going to copy and paste into Facebook. I'd like to have a column that will pull just the first line of the post using a formula. Any id...
Hi there,I want to have a column which displays two bits of data. Those are a cumulative $ amount and below that a cumulative % amount. I have these two lookup fields separately however need to combine them into one field column. Any help would be gr...
I am using a mid formula to extract a string of text. The string appears as expected in the cell, but when Make (Integromat) runs the search it is adding an extra space before the string. " <string>" If the empty space is present, wouldn't I see it i...
Hi, I am creating a CO2 emission calculator on airtable and i can't seem to get my formula right.The formula in question is:({Émission véhicule en Kg single} + {Émission véhicule en Kg total} + {Émission repas en Kg}) / 1000 The formula either calcul...
I work where following up with my clients are essential. Right now I have 3 columns in the table that. I'm trying to link together using IF Formula and it's not working so looking for some help here. First column is "Last Contact Date" which is in "D...
Hi,I am trying to create a simple IF Statement to produce the result PASS or FAIL if the value in another column is >= 80%: In Column 1 ('% germination rate on second check') are % figures with values ranging from 0% to 100%. The purpose of the Colu...
I have a base for timesheets. I have a column which is set to decimal for hours total called qty eg. 9.50 or 10.00. Then I have a formula that will accept the total hours or put something different depending on leave status abbreviation but it won’t ...
I have a series of records that include a Start Date field that I want to incorporate into a larger CONCATENATE formula. However, some of the records do not yet have a date and the Start Date field is blank so my formula is returning an #ERROR. I ...
| User | Count |
|---|---|
| 793 | |
| 782 | |
| 587 | |
| 485 | |
| 277 |
