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

Forum Posts

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
  • 207 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
  • 111 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
  • 247 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
  • 186 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
  • 149 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
  • 215 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
  • 267 Views
  • 2 replies
  • 0 kudos

Resolved! DATE FORMAT

Hello, I have a cell with a date picking like "20240204 12:00" and I would like to format the date to "Feb 4th".I don't find how to reformat in this particular format.  Thank you for your help ! 

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

Airtable doesn't count December 31, 2023 in the correct week

I'm using a date field {Date Processed} and a formula field {Report Periods} to interpret that date and produce a comma separated list to find the year, quarter, month, week, and day. I use this for reporting. Check out this screenshot showing how 12...

rileyspiller_1-1704234402848.png
rileyspiller by 5 - Automation Enthusiast
  • 310 Views
  • 2 replies
  • 0 kudos

Filter by time | Trigger automation by time

I have a date & time field.For example, below is the data. I will have a different date and time and 100 rows with data.1 Jan 2024 1:00 PMAt 1:00 PM on 1 Jan 2024, I want to send a Slack message using airtable automation.How can we make this trigger?...

itsmeayyub by 5 - Automation Enthusiast
  • 281 Views
  • 1 replies
  • 0 kudos