Hello!I am creating a list of tasks that need due dates assigned using the following conditions:1. Each task is due one day after the previous task is due (note: dependencies would be nice to have but not necessary)2. The tasks are never due on Frida...
Hi expert guys and gals, I am struggling with what appears to be a straightforward mundane issue, but I have scoured the Community and the internet without any luck. I have workers schedules and sometimes they work Monday to Friday, but sometimes the...
I am struggling to get the DATETIME_FORMAT to return the correct time for me. For example, my Start Date is 10 January 2023 00:00 and in my formula column, I just want it to extract the time of the "Start Date". So I put in this formula: DATETIME_FOR...
I'm working with some data coming from another group and they use both text and dates in a fields that I need to pull apart and use the dates to estimate further due dates down the line. I'm trying to avoid the big #ERROR! when the field has text and...
Hello everyone, Pretty new to Airtable but I am enjoying the platform and the features it offers. Currently I have a table with data for when we last saw specific people. The date is being entered as February 13, 2023 for example and I am converting ...
I'm trying to create a date formula with the next/upcoming birthdate from a staff profile with Date of Birth. I need this to be formatted as a date so I can use it in a calendar, which has proven to be more difficult than I anticipated. Here are 2 wa...
I'm hoping someone can help me with a date formula and how to implement it.I've got a project plan (with dependencies) and I've got three fields, "start date" "end date" and duration.The project has a kick-off date and all start and end dates cascade...
Hey dear Airtabler!I have a question about tracking the duration between modifications. A user will type a number in the same field several times a day and I would like to check how long each interval took to use this duration in a formula. How to bu...
Hi,I am getting this error when I try to upload a string valued date to a "Date" type column in airtable using python script. [Error: {\'type\': \'INVALID_VALUE_FOR_COLUMN\', \'message\': \'Field "Uploaded Date" cannot accept the provided value\'}]Wh...
Hi all,I'm wondering: Do any of you Airtable experts have an idea how I could calculate how many Fridays (or any other weekdays for that matter) there are in a given month?
Dear All,Im trying to create a formula where if an someone starts before the 15th of the month then return the 1st of that month. If they start on the 15th or after then return the 1st of the following month.I have created the below nested IF stateme...
Hi All-I am looking to have a conditional field in grid view so that if we are approaching an expiration date, the field will change color according to how soon- e.g. using (TODAY) red if 30 days from expiry, yellow 60 days, green 90 days. So far, I ...
Hello! I need some help from this community because I lack the knowledge to develop formulas. I really appreciate your help.I'm trying to create a view for a database where I only see records where the answer for "Dates Available" is exactly between...
HiIf anyone has any ideas about this I would be very grateful - I can't quite see a way through this one!One of the elements of the system I'm building schedules the use of specific tools. I would like to be automatically notified if a tool is double...
I've used hours to search for a solution via Airtable support pages, this community, Youtube (interesting video) and even ChatGPT, but I can't seem to find an out-of-the-box solution. Hopefully someone like you can help In an Airtable dashboard inter...
Hello,I need to calculate a date. Here is an example:Start date of employee is 2023-05-03. The previous Monday, an email should be sent to the employee.How can I calculate the date based on the weekday.I have a formula, but it only works if employee ...
Hey All!I'm sure I'm overlooking a tiny detail, but here goes.My existing formula is:DATETIME_FORMAT({Date and Time},'MM-DD-YY h:mm a')&" GMT"&" - "&{Course Name}The documentation shows to add a timezone, to do this:DATETIME_FORMAT(SET_TIMEZONE("07/1...
I have a table that includes a date field as well as a single select field with options that are times of day (e.g., 9:00am, 12:00pm, 3:00pm). This allows users to select a date and time from a limited set of time options rather than Airtable's unres...
Good afternoon!I'd like to create a field that would simply show if a date within the record is within the past year. We already have a field "Date Received" for each record. I'd like to have a field that can quickly show if that date is within the p...
I'm trying to find a way to display time zone for a 'formula' field that ends up being a datetime, in the same way that time zone works for actual datetime fields.I've reviewed the new SET_TIMEZONE function and some posts here, but not finding an ans...
