I am building a safety event submission sheet and I wanted to add some metrics to a dashboard. If an event is submitted, that day is considered a "Red" day and if no events were submitted it is a "Gre…
I am in Victoria, Australia and I am using a form to populate a sheet. I want to automatically populate the Inspection Date to be the date the row was created. I am using the formula =created@row The …
Hello All, I have a manufacturing schedule sheet which lists tasks that are sorted by date. I have a bunch of conditional formatting rules applied to make things easier to read and identify. Each day …
Hello! I need a formula to pull the most recent date in a list, but I keep getting unparsable and invalid errors. Could someone please help me create a formula to put in the highlighted cell? Please n…
Hello Everyone, I'm trying to reference data from row 44 into row 3 in the same sheet. "=[Task Name]44" works like a charm (see below). However, =[Start]44 doesn't result in the date "08/13/25" being …
Hello, I am trying to set up metrics for a lab testing schedule. I have created a pacing sheet which is set up to show how many hours of testing each analyst is assigned that day. The left column is t…
My ultimate goal is to create an automation that will look at the total audits completed for the current month and if the number <10, a notification will be sent. In order to do that, I need the 'curr…
Hello, I am using the column formula below to extract the time from the "Created Date" column. =SUBSTITUTE([Date Submitted]@row, DATEONLY([Date Submitted]@row), "") However, you can see in the screen …
I reference two created date fields from another sheet. I use the following formula to reference the created date: =IFERROR(INDEX({2a. FEMALE CHANGE ROOM Range 1}, MATCH(JOIN@row, {2a. FEMALE CHANGE R…
This is my formula: =IFERROR(YEAR(TODAY()) - YEAR([Date of Birth]@row - IF(TODAY() < DATE(YEAR(TODAY()), MONTH([Date of Birth]@row)), 1, 0)), "") It keeps rounding to the next age. For example, 04/09/…
