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( ...
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")
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?...
Hi ! Coleagues, I have a project in AirTable in a single table with 174 rows and 11 (eleven) categories that I can group these rows. Each of these 174 tasks has its own "Start Date" and "End Date" column, with date format in it. I want to...
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 ...
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?
Hello,I have been googling this for a few days now and really need some help!I am trying to set up an existing customer email reminder automation that uses date the next time we are going to visit a venue. The trigger will start a month or so before ...
What can I use in a formula field to copy the date from one field to another without changing it into a text string?For context, I have install dates and site visit dates in the same table, and the dates are in the same column for 'start' and 'end'. ...
Hi ! I created a column to identify if the "End Date" of a task belongs to one of the weeks below, based on the ISO numbers for each week of the year (1~52 or 53). But I am facing an error due to the year, that I cannot overpass. It is ...
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...
