Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Formulas
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Utilize Date conditions after creating date token in formula

I have used a formula to create a new date value based on another date cell: The Next Due Date uses the following formula: SWITCH(Frequency,'Weekly', DATETIME_FORMAT(DATEADD({Task Due}, 1, 'week'), 'DD/MM/YYYY'),'Monthly', DATETIME_FORMAT(DATEADD({Ta...

Screen Shot 2023-02-01 at 12.05.39 PM.png Screen Shot 2023-02-01 at 12.05.56 PM.png

Resolved! Date Span Crossover Formula/Script?

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...

Jon by 5 - Automation Enthusiast
Solved
  • 75 Views
  • 6 replies
  • 1 kudos

Resolved! Date Counting

Hello!I have a list of records that all have a start date and end date column for a number of employees.  I am wondering if there is a way to calculate the number of employees on a given day.  All the employees have different start and end dates.  So...

Make an End-Date begins the day or after the Start-Date begins

Hello everyone, I would like to create a form where people can add their event dates (event begin at 1st January 2023 and end at 2nd January 2023) and prevent the possibility of the end date to be before the start date (event begins at 1st January 20...

username1 by 4 - Data Explorer
  • 173 Views
  • 2 replies
  • 0 kudos

Resolved! DATETIME_PARSE AND CONCATENATE

 Hello everyone,I have to create a calendar of course sessions and I have a table in which I enter in one column the date, in one column the start time and in another column the end time because different days might have different times.I use the for...

How to show most recent entry in group of numbers

Ok, I have been trying to do this for a while on my own with no luck.I have a list of serial numbers. These serial numbers have more than one entry. I group the view by serial number so I can see all entries for any particular serial number. What I w...

Rich_Nuzzi_0-1674682858384.png
Rich_Nuzzi by 5 - Automation Enthusiast
  • 56 Views
  • 3 replies
  • 1 kudos

Date & Time formula incorrect

Hello!I have created an estimates / intakes base for a client. One of the goals of creating this was to have an automation that sent a confirmation email to the customer once their estimate was scheduled. When I tried to insert the Estimate Date/Time...

OpsDir_Cassie_0-1674581845622.png OpsDir_Cassie_1-1674581874105.png

SWITCH function for a date field ?

Hello,sorry, if I ask a question that might have been asked before. I am creating a simple private bookkeeping table and would like to build a SWITCH function that stamps the DATE when a value changes ("paid" / "open").Furthermore, I have tried the T...

HaraldPalma by 5 - Automation Enthusiast
  • 69 Views
  • 2 replies
  • 0 kudos

Resolved! Formula to Display "Week Of" Date

Hi AT Community, I'm new to Airtable and ’m trying to create a formula that would display the Monday of the week / "week of" date for a given date. Monday is the start date of the week. I've tried formulas from other posts but when I add the formula ...

shirt26 by 4 - Data Explorer
Solved
  • 104 Views
  • 2 replies
  • 3 kudos

Rollup Fields with Dates & Average

Hi all,I am trying to extract the mean/average of a set of dates through roll-ups. I am able to calculate the min or max date through the use of MIN(values) or MAX(values), but AVERAGE(values) returns NaN.Any suggestions? (thanks in advance!) 

Raphael1 by 4 - Data Explorer
  • 105 Views
  • 1 replies
  • 0 kudos

What datetime format is this?

I'm attempting to prep a table for import and need to recreate a concatenated formula field that includes a date field formatted like this:Can anyone identify this format for me?  Thanks!

Screen Shot 2023-01-19 at 7.50.14 PM.png

Resolved! Finding the Number of Fridays in a Month

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?

Malakai by 6 - Interface Innovator
Solved
  • 325 Views
  • 8 replies
  • 1 kudos

Resolved! Calculate "Week Commencing" - Not quite right...

Hi guys,We have a field that lists the publish date + time for a piece of web content. We want to be able to organise all of these dates into 'week commencing', ie. add a field that gives the date of the Monday of that week. So, an item published say...

newland101 by 4 - Data Explorer
Solved
  • 155 Views
  • 2 replies
  • 1 kudos