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...
Hi!So I'm trying to set up a table for our home school group to house everyone's birthdays. I've scoured the forums and can't work out why I'm getting an error on all dates on or after 13/05/2019. All dates prior to this work fine and I just can't fi...
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?...
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...
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...
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...
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...
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...
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...
Hi, I am trying to populate in a cell, "Urgent" when a project is coming up on its {Due Date} within 7 days of today AND the cell that has my completed date, {Date Filed} is Empty. If {Date Filed} is Not Empty, i'd like it to populate "Completed". If...
