Formulas

I’ve created a form that I’ve asked employees to fill out daily to help us track COVID-19 systems in our work force. I have a second table in my base that has the entire employee list with emails. I would like to create a formula/view where I can see who hasn’t filled out the form on a particular day so that I can send an email reminder to ping them. It’s not as simple as a date match, because I don’t want to see previous dates, only a particular date to see who is missing if that makes sense. New to doing this and any help is greatly appreciated!

Hello everyone, Due to Covid 19, my company decided to find an inexpensive way to create a Lead Management system for our Telemarketing and Telefund campaigns. Airtable seems to work great so far with the actual calling (even though it is a bit more hands on) but I am running into a small issue with our calling calendar. To give you some details, the calendar needs to work as a working document, showing (by month) which segments are called by Telemarketing and which by Telefund. The way I have set is by: a) Creating 3 tables in order to create groups for the segments (e.g Series A, Series B etc = Renewals, Tickets to X performance = 2021 Fall tickets etc.) One for Telemarketing, and one for Telefund as well as one table to group our suppressions. b) Under the original table, starting with the months as the initial column I added a date for when each extraction needs to be completed, a completed/not completed indicator, expected revenue (sep

I can’t find the way to format properly to date a rollup field. The formatting tab return that it’s not a date field. I have that : 2020-10-05T00:00:00.000Z and I want just that : 2020-10-05 Yet, the field rolled up is a date and the aggragation formula is ARRAYUNIQUE(values) Thanks in advance

calculate check out date based on check in date + number of days

I’m trying to create a template for a source bibliography that would include punctuation in the formula. I have multiple fields that will eventually be combined. Can someone tell me why I’m getting an X in Column 1, Row 3, when Column 3, Row 3 is blank? I would have expected that field to be blank. Here’s my records Here’s my formula Thank you, Stacey

Hi all. Sure this is super simple and I’m no doubt being super simple myself in not getting the solution… I have a sheet where I am keeping track on recurring charges. I’m dealing with 3 specific columns in this sheet Col 1 [$ Charge] Col 2 [currency selection…eg AUD, USD, GBP etc) Col 3 [$AUD Charge] Ultimately for each line item I add, I want all charges to be converted to AUD (this would be COL3) and from there I can run further calculation based on this number. So I’m assuming the formulas for column 3 would be: If “Currency” is “AUD” then display the value already entered in “$ Charge”. And… If “Currency” is “USD” then multiply by “<FX rate that I’ll input>” then display the calculation as a “$ value” I’m just not sure how I would write those formulas in Airtable? Possible? Thanks so much Ian

I use Integromat to automatically get the records, and I’m trying to create a search formula to get the list of records that have a birthday a week from now. Here’s the filter: Where {{Birthday}} is within the next number of days '7' How can I make a search formula based out of this filter? I like something from the FROMNOW([date]) which Birthday is the column, but there’s no integer to mark the days. Hope to hear back soon.

I have a couple fields that are all multiple selects, that I want to consolidate to one field that tells me what wasn’t chosen. For Example, I have 3 fields called VIDEO, AUDIO, GRAPHICS all with multiple options to select. I want to create a field that combines them all with the unselected options. If VIDEO has the options: Master, Web, DCP and I select only Master and DCP If AUDIO has: Stereo, 5.1, Stems and I select only Stereo, 5.1 If GRAPHICS has: poster, stills and I select only poster Then I want one field Called Missing that outputs the missing options: Web, Stems, stills Thank you.

Hi Everyone, i’m loving Airtable but am still quite new to the formulas. i am inputting dates of my staffs first aid and criminal record checks to expire after 3 and 5 years. i’m hoping to have the date issued in on column and the next have active or expired… but dear god i cant figure it out! anyone give me a hand here? thanks in advance.

I’ve got a datetime field called Start time (UTC) I want to take the time component and reformat the minutes into a fraction. For example: Source Desired output 14:00 14 14:15 14.25 14:30 14.5 14:55 14.92 I have tried taking the minute component and conditionally dividing it by 60 to at least get started (before I sort out rounding etc), but I just get #ERROR. Here’s my formula: IF(DATETIME_FORMAT({Start time (UTC)},'m')=0,"",(DATETIME_FORMAT({Start time (UTC)},'m')/60))

I want to use a formula to add the Collaborations initials to the Event name so I know who is going just by looking at the primary field name in the calendar view but I am unclear how to accomplish this.

I need a field to add 10% to the previous totals column and then another field that adds 20% to the previous, my experience in formulas is basic +,-,x & divide, and I cannot find the simple solution yet, please help

is it possible to remove spacing between words using formula

Hi, I would like my first column to be a formula that combines columns A-B-C if a specific value is selected in a single select column and combines different columns if another value is selected in that same single select column. I have a single select column called {Calendar} with 2 value options “Event” or “Series”. If {Calendar} is selected to be “Event” I’d like the formula to combine {Calendar}&"-"&{Date}&"-"&{Client}&"-"&{Street} If {Calendar} is “Series” I’d like the formula to combine {Calendar}&"-"&{Date}&"-"&{Site}&"-"&{Service} I would appreciate any help - I am completely stuck and need this in order to merge my Event and Series bases. Thank you! Alix

Is there any way to use the number of records in a tab in a formula? Eg: tab 1 > column 2 has a number x and in column 3 I want a formula that divides that number x by the number of records in that row Question form a colleague to calculate some Business Continuity Management score…

Hello Everyone, I am looking for a way to manage my blogs on airtable ( texts, pics, etc…) and display it directly on my WordPress website from there. Is there a way to do so? Thanks a lot!

Hello, forgive my English, I’m Brazilian and I’m having difficulties with the use of the IF command. First, I have 5 different dates, which I will use as a review in the studies, and I needed to compare all these dates at once with the current day, so if date 1 is less than today, date 1 would return to me, if it were bigger i would return date 2, however, if date 2 was smaller, i would return date 3, and so on. Does anyone have any idea how to do this? !

My formula is MONTH({Trial Date})-1 I want that to then return a month name instead of a number. I’ve been trying to figure out the DATETIME_FORMAT to do it, but I cant get it.

Newbie here so be kind :slightly_smiling_face: This might have been asked before, but the only one i found that was a little relevant, the poster was asked a few times why he/she isn’t using the same table for their needs. So lets say i am insisting on using a few tables. It is for inventory. I will create tables for example: Available (featuring a column for manually entered/edited qty) Incoming (featuring a column for manually entered/edited qty) Outgoing (featuring a column for manually entered/edited qty) I will have a main table for an ‘overview’ of the combined above qtys. There wil be a ‘Total’ column in this main table. In this main table, the qtys from tables: Available Stock + Incoming - Outgoing will be calculated if i can work out how to make the tables work together? For example, in Google sheets or excel, a formula between sheets would be like: =‘ORDER LIST’!C116+‘SUPPLIER 1’!C9 So how to make a similar formula for Ai

Hello I’m new in the Airtable community, and formula are definitely not my area of expertise, I’m trying to make a formula that counts the days of difference between requested return date and the real return dates, however if dates are the same i want the cell to stay empty. like : Date return : 02/02/2020 real return : 02/13/2020 Delay : 11 i try with this formula without succes : IF(IS_AFTER({Real return dates}, {Date return}), DATETIME_DIFF( {Real return dates}}, {Date return}, ‘days’ )) Sorry if this sounds dumb or simple, i’m very new to airtable and formula! Thanks alex

I’ll preface this with a “Key” that gives context to my field types and field names. [Date #1] = “Start Time” Date Field (set to GMT) [Date #2] = “End Time” Date Field (set to GMT) [Stream URL] = URL Field I’m trying to make an IF() statement in a formula field that would reveal the [Stream URL] if the current point in time (down to minutes or seconds, I don’t care which) is after [Date #1] and before [Date #2]…otherwise, reveal the text “No Stream Available” I have tried things like this and come up short" IF( AND( IS_AFTER( NOW(), {Start Time} ), IS_BEFORE( NOW(), {End Time} ) ), {Stream URL}, "No Stream Available" ) Help would be appreciated :pray:

I have 3 tables: 1.Assets 2. Contacts & 3. Maintenance calls. If I have a form to start a call for a repair and I ask for a phone number, how can I add automatically to the form (or later, to the table itself) the info about his contact details and the asset, based on that (the assets and contacts are linked together) Thanks a lot

Hey there, I have a table where all the leads are automatically copied to fields. I’d like to count how many leads/calls/sales I have made based on the date. Can anyone help me with that?

Hi i am in New Zealand and our date format is dd,mm,yyyy and I am trying to calculate years and months using this code: DATETIME_DIFF(TODAY(), {Date Of Birth}, ‘years’) & ’ years, ’ & MOD(DATETIME_DIFF(TODAY(), {Date Of Birth}, ‘months’), 12) & ’ months’. It is working however only on this date format (mm,dd,yyyy) how can i change this so it works for me please?

My base is for keeping track of genealogy research projects. The Main Table is a list of projects that links to a People Table and a Timeline Table People Table: Has columns for First, Last and Middle name. Has a column that concatenates to list the Full Name and the Primary record field Timeline Table Each record is linked to a project from the Main table and a person. The same person can be linked to multiple timeline records Has a lookup column to display the Full Name field from the People Table Main Table Lookup pulls the Full Name from the Timeline Table and repeats it since a person can be linked to multiple records in the Time Line