-
Create way to reflect quarter?
Dear brains, I have the following setup that I need some suggestions on: I have a database that captures planned travel across the year, and is captured just before every quarter for the upcoming quarter plus one month (so for example, the db will be populated in September for Q2 travel from October - January, but January…
-
COUNTIFS for Escalation Tracking
I am looking to create a formula that counts the how many times over the last 12 months escalations of a certain deal size occurred. Deal size is represented as range of AUM in text format. The current formula I'm using is =COUNTIFS({Escalations Range 1}, "75M - 150M", {Escalations Range 2}, >TODAY(-365)) I created a…
-
Create master list sheet for multiple individual sheets and count the data from individual sheets
Hi there I have a question to how to automatically link the count formula from one master list to individual sheet. Below is my workflow. I have created multiple individual sheets for each of my program to track the program status, (Pink Heading) Sheet 1 - Program 123, Sheet 2 - Program 124 … Then, I created a (Blue…
-
Help with Dates
Hi, I've got this formula below and I'm very confused why it spits out 1 rather than 0 as I believe 12/29/2024 is less than 1/5/25. Is it because it's parsing it as DDMMYYYY rather than MMDDYYYY? I feel like that's probably not the case since 12/29/2024 would spit out an error if the format was supposed to be DDMMYYYY.…
-
How to calculate number of cells with dates within the last 15 days?
I'm trying to calculate how many rows on my project sheet have a "completed" status in the "project / task health" column and also have a date in the "completed date" column within the last 15 days. This is the formula I am trying to use: =COUNTIFS([Project / Task Health]:[Project / Task Health], "completed", [Completed…
-
Card View showing Undefined Column
In my sheet, I switch from Grid View to Card View, but the columns don't list out all Owners although each list item has an Owner. Some items are shown under an Undefined column. How can I get the Card View to recognize the Owner names for those appearing in the Undefined column? That way there are columns showing each…
-
How To Have Risk Column Automatically Update Based On Certain Conditions
Hello, Can anyone help me write a formula based on the following conditions. Risk Status = "Green" if the following conditions are met: [Delivery Confirmed] is checked Risk Status = "Gray" if the following conditions are met: [Release Date] is Blank Risk Status = "Red" if any of the following conditions are met below:…
-
Help with Health color formula
I need help with my Health column formulas. I cannot figure out why it's not working. What am I missing? Available health options: Red, Yellow, Green, Gray Health formula: =IF(COUNT(CHILDREN()) > 0, IF(COUNTIFS(CHILDREN(), "Red") > 0, "Red", IF(COUNTIFS(CHILDREN(), "Yellow") > 0, "Yellow", "Green")), IF(AND(ISBLANK([End…
-
How to count multiple values in the same column
Background info : Product name is MR/HV13 This product has 4 types (MR/HV1375, MR/HV1385, MR/HV1395 and MR/HV13115) I would like to count how many entries of each of the product types were submitted and total them under the mother product name which MR/HV13 Initially, im using COUNTIFS and planning to do a monthly data…
-
Formula keeps giving back #UNPARSEABLE
My below formula keeps giving me an error and I can't see to find the problem. It also seems to not be recognizing the column references when the names match exactly. =COUNTIFS([Project Start Date]:[Project Start Date], >=DATE(2023, 1, 1), [Project Status]:[Project Status], OR(@cell = "green", @cell = "yellow" ), [PD…
