-
Date format incorrect on forms
Since the updates to the forms, some of the forms we use now have the dates showing as mm/dd/yyyy rather than the format dd/mm/yyyy. Is anyone else having this issue, has anyone else found a way to resolve this? Thanks, John
-
Countifs between 2 dates with status
Within Sheet Summary I can't get this formula to work, it keeps saying invalid value. Any help would be greatly appreciated. I am attempting to create a dashboard for items I have being completed on time or not using "0" or "1" through other formulas within the sheet. For example, looking for the number of CPAs completed…
-
Merged: Feature Request: Duration Calculation from Date & Time Columns
This discussion has been merged.
-
How to use a nested if with count
We would like to have all the criteria for a created date by week. the number of new helpdesk tickets created by each end user for a given week. Example: Week of 7/7/25 Mickey submitted 5 tickets, Donald Duck submitted 10 tickets, part of Donalds 10 tickets only 5 were reported in week 7/7/25. Report Week of 7/7: Name:…
-
IF Statements with Dates
Hi all, I am clearly missing something… I have a sheet with columns for the Start and Date Ends and then another column to track the Status (In Progress, Enrolled/Upcoming, Completed). The formula is currently: =IF([Start Date]@row > TODAY(), "Enrolled", IF([Start Date]@row < TODAY(), "In Progress", IF([End Date]@row <…
-
Formula for counting rows as they flow in and out
Hi Everyone, We have an intake sheet, fed by a form, that assigns rows to staff members. Leadership wants to be able to balance workload by tracking numbers of rows assigned over a timeframe. On a metric sheet, we use =COUNTIFS({Column Name}, "Person Name") to see how many each person has assigned to them at any given…
-
Automated Date Capture Process with Recurrence
I have a sheet where we track Products (per row) and we need to track a user access review every year. To do so, I want to document the Product Owner and the Product Initiation Date - from there (when new row and product initiation date is not blank), I would need to auto fill a cell (Column: Next User Access Review) with…
-
Formula for counting rows as they flow in and out
Hi Everyone, We have an intake sheet, fed by a form, that assigns rows to staff members. Leadership wants to be able to balance workload by tracking numbers of rows assigned over a timeframe. On a metric sheet, we use =COUNTIFS({Column Name}, "Person Name") to see how many each person has assigned to them at any given…
-
Date reference and subtraction MM/YYYY
I am trying to reference a cell in the same sheet carrying today's date in MM/YYYY format using =MONTH(TODAY()) + "/" + YEAR(TODAY()). I need to keep an up to date month reference in the sheet for a span of a year. How do I rerence the "Today MM/YYYY" cell and subract a month from it while maintaining the same MM/YYYY…
-
If And Formula including dates and isblank
Hello, I am trying to create a formula that will flag the column Delivered Out, if the On Hand Inventory is equal to 0 and the Date Delivered is today or in the past. Both conditions must be met so if On Hand Inventory or Date Delivered Out is blank, it does not flag Delivered Out.