Hello,as the subject says i'm looking to write a formula which returns a childs age at 1. august 2023 based on their birthday. i'm currently using a formula which gives me some info, but i would really like to know if there are other possibilities. T...
Hi all, I have a formula field that is used to output a date that is +28 days from a separate date field. Here is my current formula: DATEADD({470 Certification Sent Date}, 28,'days') I need this field to always be 12:00a in the 'Americas/New_Yor...
Hi all, Hoping someone can help. I'm trying to create a time sheet where the user inputs the hours & minutes they worked in 15min increments - so 1.25 (1 hour 15 mins), 1.5 (1hr 30 mins) etc.How do I get this to appear as 1hr 15 mins, 1hr 30 mins in ...
Hello my friends. I have a seasonal task calendar that is organized by project WEEKS. Our team works from Week 57 until Week 30. Tasks are entered into the Primary Column with an associated Start Date and End Date. Currently, the Project WEEKS are se...
Dear Airtable Community, I have a board with records organized with date field and category list.1 - I would like to count the number of days in this record. If 4 records are posted with the same date I want it to count 1.Ex : 01/01/2022 I have 4 rec...
Hi, I'm working on a task list with two date fields - Action Date (the date to focus on something) and Due Date. Not every task has a due date. and not every task has an action date. Is there a formula I can use to pull either the earliest of those t...
Currently, the yyyy-mm that were paid are stored in a lookup field named Month Paid For.For instance, we only paid the vendor until 2022-11 even though we were supposed to pay them as of 2023-2. How do I obtain the months that have not yet been paid?...
How to create formula that filter the rows by last month?The filter function doesn't allow a date range (which is strange). e.g. If I want to filter rows with dates fall within February 2023, how do I do that? Thanks a lot!
I know this is super simple, but I am new to formulas. Here's my problem:I have volunteers signing up for a rotation and I'm trying to make a view that will capture their hotel needs, which are generally: Check In one day BEFORE their First Day BOG a...
Hi everyone,An application is sending me a date in ISO format (2022-02-13) and I want to convert it in the european date format without dropping the day and month leading zeros ( = 13/02/2022). I managed to convert from ISO to European but the leadin...
