I need to ensure no dates in my base land on a weekend or holiday. I’m trying to use the WORKDAY(startDate, numDays, [holidays]) formula to accomplish this. However… issues. I’m using “0” as numDays since I do not want to add any days if the date alr...
Hey Friends!Got an invoice table that calculates taxes before we send it out. We're in the service industry, meaning sales are done in many different counties.Currently I just have Airtable reference the address to pull the county and apply that coun...
A few months ago I received an email from product@mail.airtable.com descibing changes to handling of dates and timezones in scripting. Do I recall correctly? Can someone point me to the info it described? I’m still doing manual timezone adjustments i...
I have a base where conversations with customers are sorted into different category, like pricing, features, complaints, technical requests, etc.I want to create an overview that shows how many conversations of each category happened in different tim...
Hi, I have two dates in my base, one is manually inputted, the second is linked from another tab. The date pulled from another tab is the most recent date and we need this date to replace the manually inputted date so we can track most recent updates...
Hello! Use Case: New Employees start at our company and we input a load of default events/meetings into their calendarsI manually input Start Dateand I want an automation/formula to inputDay 1 Start Start Date (ADD TIME 9am)Day 1 End Start Date(ADD T...
My table tracks publication start and end dates for various websites, and I need to determine the time between the previous record's end date with the next record's start date.Examples: Site A's publication will be taken down on May 31, and the new ...
Hey all! I’m a bit stuck here and hope that somebody might have an idea to share. Context: I have a table that lists a bunch of SaaS products that I use (such as Airtable!). Many of them have monthly recurring costs on the same date each month. What ...
Hello,As projects come to a close, I want to review how successful my team was on staying on task and completing tasks by the deadline. My base is set up to flag overdue tasks, so I know in the moment when something is overdue and needs to get done A...
I am trying to create a scheduling tool in Airtable to book appointments with outside clients. I created a form that is linked to schedule availability and includes name, role, email, etc. At the bottom of the form, they can choose a date/time. Is th...
