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

Forum Posts

Dates "sheet"? Update records based on one date

I want to create a "sheet" timetable that creates new dates using a formula based on one date that is inputted. I know there's probably a better way to say that so please disregard my ignorance. Here's what I want to happen...I input the "Class Start...

malloryjax by 4 - Data Explorer
  • 120 Views
  • 2 replies
  • 0 kudos

Resolved! Converting partial year and text to year/month

Hello! I have a large set of dates that are a partial year and month, and would like to convert this to a final date of the month format. Examples:Data I HaveDesired Format24-Apr2024-04-3024-Aug2024-08-3023-Dec2023-12-31I've tried concat using LEFT( ...

betteratuno by 4 - Data Explorer
Solved
  • 226 Views
  • 1 replies
  • 3 kudos

Resolved! Day date glitch

why does a 'day date' formula, based on a 'start time' return a day as the day before, when the start time is before 8am? Here is my formula column which is based on my start day/time fieldDATETIME_FORMAT(Start,"D-ddd") 

GGA by 4 - Data Explorer
Solved
  • 196 Views
  • 2 replies
  • 3 kudos

Resolved! Add Dates Automatically based on Word

If there are options in a drop down menu (example Quiz or Test), start dates are entered by user, can I add a new column with a formula that detects the word 'quiz' or 'test' in the previous column and add an end date automatically based on the word?...

JaclynB by 5 - Automation Enthusiast
Solved
  • 2300 Views
  • 7 replies
  • 2 kudos

Adding a date to an IF statement

Hey all, I could use some help and I'm hoping this isn't too difficult. I am trying to add a formula that compares an event date to the date of the next time change. If it is before the date of the time change, it runs one formula, if after, it runs ...

AaronB by 4 - Data Explorer
  • 411 Views
  • 5 replies
  • 7 kudos

Filter rollup field by created date

I have rollup field that sum all the records from a table. I want to limit the sum from all to sum for current month only.How can I do it? 

SoMedia by 4 - Data Explorer
  • 165 Views
  • 1 replies
  • 1 kudos

Resolved! Create a "next work anniversary" date from employee start date.

I want to automate an email that goes to staff two weeks before their leave year renews on the anniversary of their start date each year.Is it possible to create a formula which will automatically show the next anniversary in a date format? For examp...

Calculating Average Time of Day

Hi. I’m looking for a way to calculate an average time of day for an average start time and average end time. Airtable has the date and time field, and the time duration field, butI need the average start time and end time, as separate values.I need ...

Workday formula returning the wrong dates

Hi - desperately need help in figuring out what in the world is not working. I am creating a production timeline where the campaign launch is the starting point. From there, I want to count and report certain milestone dates bases on a typical timeli...

rseltzer_2-1706909236983.png
rseltzer by 4 - Data Explorer
  • 308 Views
  • 3 replies
  • 0 kudos

Pulling pieces of information from one field to another

I currently have a 'Date' field that shows year, month and date. I am trying to create a new 'Year' field that is just for the year. Is it possible to create a formula or automation that allows for my new 'Year' field to automatically pull the year f...

ivy by 4 - Data Explorer
  • 227 Views
  • 1 replies
  • 0 kudos

Having birthdays show up on a calendar view in Airtable

I have a field where people can enter a birthdate. I want that to show up on a calendar view in Airtable. Unless the year is the current year, it's not showing up on the calendar. I tried using a formula field but then I can't get the formula field t...

akidz2 by 4 - Data Explorer
  • 170 Views
  • 0 replies
  • 0 kudos

error in formula to calculate month start and end date

I have a table with work months like here: I'm trying to calculate the start and end datetimes of the month but the formula is giving inconsistent answers. It's correct for some months but there's an error in End Dates for March, May, July, October a...

Screenshot 2024-01-19 at 19.14.03.png
Neptune292 by 4 - Data Explorer
  • 249 Views
  • 2 replies
  • 0 kudos

I want to calculate how much of a service is is split monthly

I want to make sure the cost of the services is split according to the months it's meant to run. For example, a Product is $16,500 and will run for 6 months (Start in Feb, End Jul), so Product Per Month is $2,750. I want to create a formula that puts...

Joanne_Georges_0-1675358064701.png

Resolved! Date add option

Hi, I have a column with a date and time (starting date and time) in one tab and another column (Duration time) with a duration in another tab. I created a lookup in order to use this duration in a formula to get the endin date and time. I couldn't f...

JeremiBen by 5 - Automation Enthusiast
Solved
  • 322 Views
  • 2 replies
  • 0 kudos