I could not find a solution for this in the forums: From a list of dates, I need to find that date that is the last date on that list before the launch date of a given project. The idea is to find the date best suited for an event to happen before a ...
I run a table that keeps track of content my team creates for a digital billboard. When we hear about new content, our project manager builds out a production schedule based on the date the content is supposed to go live on screen.To help my PM with ...
Hi,I'm trying to determine how to display the difference between two dates as years, months then days.I have a start date and an end date, (the moment a worker started in the company and the moment he ended his contract with us), and I need to know h...
I'm using the WORKDAY function and it's skipping the weekend as it should, but it always returns the previous Friday. Is there a way to have it return Friday if the date falls on a Saturday, and return Monday if it falls on Sunday?
"I am conducting research to monitor the depression status of patients. It's crucial that I track their status on a weekly basis. Consequently, I am looking to set up a reminder calendar to facilitate this. I've utilized the provided formula to deter...
I created a table called Items (household items). In Items, there is a partially filled-out field, PurchaseDate, that is some items have a PurchaseDate; other items don't have a Purchase Date (field is left blank). I want to run a filter of those i...
Hi all, I'm not sure if my aim should be achieved with a formula or an automation but I'm hoping someone can help me. I have a various payment schedules for different companies which show me the dates each one is due to make a payment - I upload thes...
I'm getting an invalid Switch formula, even though it's super simple.I have several columns of singular date fields. Each date field is a milestone. I'm writing a simple Switch formula to check if Today() = one of the date fields, then if so say the ...
Hi, currently my team wants to have a form to submit warning for staff. A warning will last for 30 days, if staff violate within 30 days, it will automatically be their 2nd warning just by submitting formPlease help, i don't know how to set up the fi...
Morning! I'm having trouble getting Airtable to recognise the output of this formula as a date. It is basically saying "if it's in this city/country, you need to begin the project x,y or z number of months before the required by date". The last "othe...
