I am trying to build a module in Make (Integramat) that will find a single Airtable record that matches an AND + OR condition:My formula is:AND( {NMI}="63050090121", OR( {Subscription status}="Active", {Subscription status}="Pending", {Subscription s...
Hello all, i'm fairly new to formulas and what not and need a bit of help.I'm trying to make a single select status field's Result show either "done" or "not done" based on a symbol in a separate formula i was thinking of trying use the IF functionTh...
Hello everyone, Quick question, I am using the formula DATETIME_FORMAT(Date, 'dddd d MMMM') to add the day of the week in may table (easier to fill in for the team if they know which day i.e., Monday, Tuesday, ... it is).The issus is that the formul...
I want to measure workload in a week. TABLE 1A) i use google calendarB) In airtable DATETIME dif give me the duration: 02:00C) The weeknumber is a formula week(Start) = So i get Week 2022_5TABLE 2 This contains only weeknumbers: 2022_552 problems:a:...
Hello. I'm struggling to find a way to combine the contents of several Multiple Select field into a new field, while retaining the value and color for each entry. Here's a stripped down version of what I'm trying to do: I've got 4 separate multiple s...
Hello,I am looking for a custom formula to help me solve the following.Basically: If text in column A is true then add numbers in column B + 50 otherwise null.If {inspection} contains "oil change" then add {engine hours} + 50.0 The problem I have is ...
Hi everyone!I'm new to Airtable so I need a bit of help.I have two bases with one main table named the same. "Students" and "Mentors"The "Mentors" base is published as a sync table in the "Students" base, and vice-versa.In the "Students" base, I have...
Hi everyone, Thank you in advance for any suggestions you may have I'm working on creating an always up-to-date Airtable that consists of records being updated in Podio. So within Podio, I have an app with a sheet consisting of people; my colleagues...
Hello all, I'm hoping for some help with formulas that will allow me to achieve below. I have scoured all the brilliant responses to similar questions, but none quite meet with this. The format will always be the same but character lengths with vary....
I have a field that has a ton of linked records and I'm trying to format that into a nice list for use in the Pages extension. It's generally coming through with commas and quotation marks separating it. I found this formula in another thread, whic...
I am trying to have a formula that says the following: 1) If the value in this $ field is greater than 0, 'Do this'2) also, the value in this $ field is 0, 'Do this instead'3) also, if the value in this $ field is a negative number, 'Definitely do th...
Hi everybody!I'm trying to move our Excel spreadsheet to Airtable to simplify things ans automate something.The spreadsheets is just a list of activity that we need to do (we rent stuff), have a look at the screenshot.Question: is there a way to tran...
I have a formula field containing NOW() and nothing else. The field is showing the wrong time. Right now it's 3:02 a.m. in the desired time zone (Eastern Daylight Time), but the field shows 2:59 a.m. I've attached a screenshot showing the difference ...
I organize a Run group that uses Airtable to login runners each week, via a form entry from a "Check-Ins" table. This form pulls data (names) from a larger "Runner List" that keeps track of all registered runners that have ever logged in. The "Check-...
I am trying to compare dates across 4 different columns. Here is the formula I need help with - IF(DATETIME_DIFF(({Start (from Roadmap)}, {M's Start Date}) /This is trying to compare dates in two columns OR / This is to ensure the second set of date...
Hi there,Using the formulaDATETIME_FORMAT(SET_LOCALE({Clinic Date}, 'es'), 'dddd D MMMM YYYY')to translate dates into Spanish, however, the translations are missing "de" between date, month, year. I'm having trouble adjusting the formula so that date...
Hello,I'm really new to Airtable and completely inexperienced with formula options.I'm looking to set up a formula so I can easily create a list of dates for the calendar year. Right now I used # option but I think a formula is more in line with what...
Hello everyone! I have this formula: IF(AND(DATETIME_FORMAT({Trækdato (FarPay)}, "D")<10, DATETIME_FORMAT({Dato for udløb}, "D")<10), IF(WEEKDAY(DATETIME_PARSE(DATETIME_FORMAT({Dato for udløb}, "YYYY-MM-10"),"YYYY-MM-DD"))=3, DATEADD(DATETIME_PARSE...
I am using the LEN(string) function but I want it to exclude commas, is there a way to do that? I have a list of items with commas in between, I would like a character count of the letters but not the commas.
I am trying to create a button to make calls and mail using URL "mailto:xyz@abc.com" but I am not able to use that. Can you suggest me something? The email address and phone number are stored in different columns.
| User | Count |
|---|---|
| 771 | |
| 723 | |
| 578 | |
| 461 | |
| 269 |
