Formulas

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 functionThis is a rough rendition of it butIF(    {PM Time Left} contains this symbol⏳ THEN{PM Service Status} is "done" or "not done" based on the symbol) {PM Time Left}<---- this is my formulated field from other date inputs{PM Service Status} is "done" <---- This is the field i want to have formulated based on {PM Time Left} containing the ⏳ symbol  

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 formula does not show the same value as the column date and loops between march 1st and March 6th.Any of you had the problem ?THANKS A LOT

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: When i link records, I can't link with the weeknumber 2022_5 because this is a calculated field (with a formula). If fill this manually in, the link is workingb: The duration is also calculated field DateTimeDif(end-start) but I cannot use this field in a rollup field. If i add manually activities duration, then this work...So, I come from filemaker and it feels a lack because i can't link records using Calculated Formulafields to link. Or is it wrong?  

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 finding the correct way to prevent all engine hours having 50 added to it so I can determine when the next oil change is due.Would this be possible?

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 have access to Podio, so when someone new needs to be added to the database, they can go on Podio and add to the table. However, in Airtable, I want to be able to update the new records that are created as well as any changes being made. That way, I can ensure that any new data being added to Podio is also being reflected correctly in Airtable.At the moment, I have the simple scenario to 'watch items' in Podio and to 'create records' in Airtable. The thing that this does not take into account is the new data that has been added to Podio. Could someone suggest a scenario that will allow me to continuously update Airtable with the right records so that I can always have the most up-to-date information, even whe

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 a list of students, and each row has an associated "Mentor" from the Mentors base.Now, on the "Mentors" base, I'm trying to count how many students each mentor is assigned to.I imagine I might need to use a formula, but that's beyond what I know how to do.Help? 😄 

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. Also, the final .pdf that I am excluding may sometimes be a different file format. 

I've got records of song names.  I have a field with the dates we've played the song.  I want another field to extract the most recent date the song was played, but don't know how to get there.  How do I extract the highest number from an array?  Seems like it should be a simple MAX() command, but that doesn't work. 

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 this'. I have no problem writing formula to address 1 and 2, but I can't figure out how to incorporate condition 3.  Currently, my formula goes as follows (and is missing #3):IF({Current due after credits}=0, "NO CURRENT DUE",IF({Current due after credits}>0,"CREATE REMIT"))  

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 transform this spreadsheet into a Airtable app? I need to be able to edit every field in the table, without using a form for each row, it would be too long.If this is possible, my idea would be to have a single "technician" and "Van" column each with a multi option selection, but since we can have multiple installation per day, is there a way to get an alert if I select the same technician for 2 row in the same day?Is there a way to highlight/separate/color all the row that have the same day?Sorry if these are silly question, but I'm just starting with Airtable and so far...I like it!!!Thanks!

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 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-Ins" table tracks the weekly login for each run and then syncs back to the "Runner List" master sheet that tallies their cumulative runs they've attended. I'm looking to create a new table that tells us how many new runners show up each week.Logic would be that the new table looks to the "Runner List" Table and searches any values that have the "Total Runs" column (which is a formula that sums all of their weekly run logins) equal to "1" and also where the check-in is the current date.Any help would be appreciated, Thanks!

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 comparisons are also accounted for.  ((DATETIME_DIFF({End (from Roadmap)}, {M's End Date copy})))) /This is trying to compare the second set of dates in two columns If the first or second condition is true i.e the dates don't match I need it to return a value of say 1. Can someone help correct

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 read. For example, the translation is working well and producing "jueves 30 marzo 2023" however, I need it to translate to say "jueves 30 de marzo de 2023" I've tried problem solving with formulas I found in AT trainings, but it's not working for me. How can I update the formula to include the word "de"?

I try the formula that IF({Date due}!=0,CREATED_TIME({Date due}),BLANK()), but the result is the created time of the row, not the date the {Date due} cell changes. What should I do?

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 I need...Here is an example 

Hi there! I've been trying to replace  "," by "&" in a lookup field using Substitute and IF statements but I still receive an error or the result is not giving me what I want. So the result I want is IF First name contains  "," then replace by &..  

Hello,I'm completely new to Air Table and very unfamiliar with the available formulas.I want to have rows display dates for the whole of 2023. Yes, a long list of every day of the year. I'm including a picture as an example.I'm sure I can achieve this with a formula? Instead of manually...  

Hello. Looking for a formula that allows me to both convert to central time & round to nearest hour. What I have 2022-11-11 4:01pm 2022-11-11 2:01pm 2022-11-11 12:02pm 2022-11-11 10:15am Want 2022-11-11 4:00pm 2022-11-11 2:00pm 2022-11-11 12:00pm 2022-11-11 10:00am

This has probably been answered before, but I'm not sure how formulas work or how to maniuplate them to fit my use case.My base has multiple tables, one of which is a Members table. This includes the person's name as the primary field and other info, including their birthdate, in other fields.On another table, I have a list named Releases. Each Release record links to the Members table, and includes every Member who participated in a Release. Also, each Release has a release date field.As an example (Note that I'm only interested in linking to the H!P Members field, not the Non-H!P Members field):Let's use the record named Morning Coffee to hopefully explain things well enough.Morning Coffee was released 1998-01-28, and five H!P Members participated in the release: Nakazawa Yuuko, Ishiguro Aya, Iida Kaori, Abe Natsumi, Fukud

I am using a Formula field as my Primary Field for a schedule table (each record is a time slot).Among my formula for naming each time slot, I would like to add a number (ie. 001, 002) which is generated based on the Date field.ie. Record X: March 5, 2022 = 001, Record Y: May 7, 2022 = 002, Record Z: February 9, 2024 = 003So, I need a formula that creates a number based on the record's Date field, in relation to the rest of the records.On top of that, I would like to have separate sequences of numbers based on another field. I don't want all records named in sequential order, I want all Screening (option in single select field named "Type") records named 001>, and all Volunteer Shift records named 001>, etc.ie. Screening A is named 'Screening 001' (although it may be the 10th record in the sorted-by-date table) and the volunteer shift for that screening might be named 'Volunteer Shift 005' (because there are 4 volunteer shifts schedu

I'm currently working on a project in AirTable where I need to include .PNG images in a mapping application. However, I realized that .CSV files can't store .PNGs, so I decided to pull the URLs of the .PNGs in my base and create a new field to store them. This seemed to work fine, but I soon discovered that the URLs for the .PNG images expire every 3 hours. So they were coming up as a thumbnail on my map, and then they expired and disappeared. To solve this issue, I'm looking for a script that can run an automation to automatically update the image addresses in each corresponding record by using the file with each record. I've tried searching for solutions on my own, but haven't had any luck so far.

I'm trying to create a field which lists a user's two heads of department (HoD) for each building.I have all the pieces I need in my current table, but am struggling to find the best way of looking up the data to return.I have the following fields for every user: Building (Single Select), Department (Single line text), HOD (formula returning true/false - there are two HoDs for each department) and would like to have a field called User's HoD that returns the two users who match Building, Department and HoD = true.Any suggestions would be really appreciated!

Hello everyone,We have a team of 10 persons that have a non-linear schedule (i.e., We are working between 1 and 5 days a week and those days varies from one week to the other).We have defined a set a todos (4tasks) for each day. Every week (Sunday) we are assigning people to one of the 4 tasks for the week to come.Based on that assignation, we want to automate daily slack send-out specifically to the person responsible of completing the task. The current way that we have a doing it is :- a google sheet in which we enter the name of the responsible (one week in advance) for a specific task and day- index(match()) formula to match the name and the slack ID on the gsheet-zapier to copy everything to airtable  -slack automation (with an if (date=today) then slack the ID)We are trying to cut the gsheet to airtable automation, but we would need an equivalent to index(macth()) formula in airtable 

I am trying to create formulas that skips weekends, showing 5 days after a date field called Sendt (and then two other formula fields for 14 days later and 30 days later)I tried using the workday function, however it is displaying a Sunday, as you can see in the screen shot below.I have tried, I kid you not, over 30 different types of formulas and cannot get this to work. What am I doing wrong and how I can get the formula to spit out the next BUSINESS DAY 5 days after the Sendt date? For reference 3/27 is a Monday and 4/2 is a Sunday.