-
Project health formula based on due date
I want to create a project health formula that accomplishes the following: If target end date is >3 days, status is complete, or target end date is blank = green If target end date is in 1-3 days and status is not complete = yellow If target end date is today or 1+ days ago and status is not complete = red
-
Hi, Can someone help me with using @row within my COUNTIFS formula?
The formula I'm using is: =COUNTIFS({OKS Satellite Accumulation Area Inspection Range 3}, "A-1", {OKS Satellite Accumulation Area Inspection Range 5}, "No") For some reason, when I add @row to both ranges, it comes back as unparseable Thanks
-
Health Check Using Nested IF with Various Criteria
Hello, I am trying to created a nested IF formula and stuck. A column was created for each color to help with validation. Originally, YELLOW was set at IF([Time Left]@row >= 3), but then both YELLOW and GRAY would highlight. Note: That any value would return a yellow ball that is greater than 3, even N/A. When the value is…
-
COUNTIF to count cells with a date less than, and ignore blank cells
Good afternoon. I am trying to count some data in a Date Closed column. I want to count the number of cells showing a date less than 4/30/21. There are some blank cells that I am not sure how to account for. =COUNTIF({Circle K Summary Date Closed}, @cell <= DATE(2021, 4, 30)) I am also going to want to sum the amounts in a…
-
Trying to only pull the month from a cell if the a certain drop box is picked
I am trying to count the amount of projects in a month with the date entered but only pull it out if a the drop down box says archived, I believe the month count is correct as that part alone works but when trying to add the code for the dropdown box it does not work, any help would be apricated, code below;…
-
How to link a row with children to another sheet
So I figured out how to link cells between sheets, but my source sheet has a structure 2-3 levels deep (rows with children). If I try to link the entire sheet it shows up at destination sheet but the structure is flattened.
-
How to add an and/or statement into a sheet formula
I'm a total noob when it comes to formulas and I was hoping someone could assist me with figuring out how to add an "and/or" portion into this formula: =IF(AND([End Date]3 < TODAY(), NOT(Status3 = "Complete")), 1, 0) Within the "Complete" portion I would like an "and/or" statement for "Cancelled". So that the "At Risk"…
-
Health column that references variance column before setting baselines
I am working on a project plan template for a colleague and they want the health column to be dependent on variance. The issue is they will struggle to write or edit formulas and the variance column doesn't appear until baselines are set. Has anyone come up with a solution for this? The current formula I have been testing…
-
AND function
Hi I am trying to write a formula that would count the number of calls in the last 15 days. Below is my formula. I am first looking at my date column so that it is in between today and 15 days ago. Then I need to only count for if the Type of Dealer (Single Select Drop Down) = DAP Dealer and Merchant if they are New and…
-
Checkbox Functionality
I've been converting another group's GoogleSheet into SS. Is there a way to create functionality that limits the checkboxes in a column to one true value? Meaning, if a different box is checked, all others are unchecked? Essentially, the true would then feed a vlookup for chart formulas on another sheet. I could obviously…
