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

Forum Posts

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
  • 265 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
  • 349 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
  • 492 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
  • 359 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
  • 326 Views
  • 1 replies
  • 0 kudos

Resolved! Concatenate not pulling accurate last modified date

Hi there!I am trying to create a formula that will pull the Last Modified date and combine it with my initials and my Pending Items column. The formula I'm using right now works, but the Last Modified date is pulling tomorrow's date. I'm assuming thi...

RosalindaE_1-1703638828030.png
RosalindaE by 4 - Data Explorer
Solved
  • 318 Views
  • 2 replies
  • 1 kudos

Resolved! Column with only hour

Hello everyone, I have a data base with activities wher date and time are fulfilled but I would like to show only the hour in one column.I'm unable to display what i want. I have for example one column with ISO 14/12/2023 1:52 and i would like two di...

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

if is_after 24 hrs

hey there,how would i go about creating a formula column where if a timestamp from a column (let's call that column "timestamp") is older than 24 hrs, then the resulting value would be "follow up", otherwise the resulting value would be "do not follo...

dk1988 by 4 - Data Explorer
  • 290 Views
  • 1 replies
  • 0 kudos

Dateadd Formula Wrong Result

Hi,I have a database with special dates of each month (Christmas, Halloween, etc). I'm using the DATEADD formula to add 1 year to a date field.For example, for Christmas I have the date 24/12/2023 and I expect the DATEADD formula to result in 24/12/2...

pablog by 4 - Data Explorer
  • 614 Views
  • 5 replies
  • 0 kudos

Resolved! Referencing specific date and time within formula

I need to be able to write a formula that checks if the last modified date is after a specific date and time. Basically, I imported a large batch of data and I want to track whenever a change is made after the specific date and time of import. I'm ha...

Dara_Molotsky by 5 - Automation Enthusiast
Solved
  • 825 Views
  • 6 replies
  • 3 kudos

Resolved! Get Latest Date Summary based on all records in another table

I've used hours to search for a solution via Airtable support pages, this community, Youtube (interesting video) and even ChatGPT, but I can't seem to find an out-of-the-box solution. Hopefully someone like you can help In an Airtable dashboard inter...

Schermafbeelding 2023-02-23 om 10.47.07.png Schermafbeelding 2023-02-23 om 11.36.59.png
stenkate by 6 - Interface Innovator
Solved
  • 1530 Views
  • 6 replies
  • 2 kudos

Setting Timezone without Time in Date Field

Hello!I'm having issues with Airtable's default GMT timezone. I have a Date field (which I do not want to have time displayed for) as well as a formula field using the DATEADD formula to calculate the next time a task is due, based on frequency. In t...

Screenshot 2023-02-20 at 2.10.04 PM.png Screenshot 2023-02-20 at 2.07.35 PM.png

Remove date/time from field

I just started using Airtable and I'm trying to remove the date/time from a column or create a new column that has the date/time removed with just the remaining text. The column is linked to another airtable and it is using the primary field, so I do...

JJJ by 4 - Data Explorer
  • 309 Views
  • 1 replies
  • 0 kudos

Resolved! IF formula to return # of hours only if month falls within a date range

Hi-  I'm a pretty new Airtable user, and have been trying to find solutions via the community posts, but haven't seen anything exactly addressing what I'm attempting to do.I am trying to populate a field with a number of hours to be worked, only if t...

RobinJ by 5 - Automation Enthusiast
Solved
  • 452 Views
  • 2 replies
  • 1 kudos

Split start and end dates which can be formatted differently

Hi there!I am getting start and end date as a text in one field.BUT format could be different in each record (mm/dd/yyyy OR yyyy-mm-dd)I want to find a formula to split A field (which could be formatted in two ways) into start (B) and end (C) datesTi...

paulius by 4 - Data Explorer
  • 191 Views
  • 0 replies
  • 0 kudos