-
COUNTIFS with OR
I am trying to solve for a formula to countifs all conditions, except for one that I want to count if either/or: =COUNTIFS({HR Projects - Project Stage}, Metrics16, {HR Projects - PMO Must-Do}, 1, {Range 4}, 0, (OR{HR Projects - PMO Range 7}, "Inclusion & Diversity", "Employee Experience") Thank you!
-
AVERAGEIF with an AND
I'm trying to find the average lead time for completed projects that were started this year and I'm having an awful time. Full disclosure, I'm not great a writing formulas. I can get the average lead time for completed projects. This works just fine: =AVERAGEIF({Status}, CONTAINS("complete", @cell), {Lead Time}) And I can…
-
Update Requests
I would like to have a update request go out when the value of a cell in a column goes bellow the number in a cell in another column in the same row, im wondering if this is possible. I cant find a way to do so. the catch is the numbers will be different for every row so i cant use one specific number which is the only…
-
Sheets to Reports - Possible bug discovered
Just sharing some items I discovered. I have a master sheet and a report that feeds from that master sheet. I had a specific column set up as text/number data type with a formula in there to compute a "Yes" or "No". Those "Yes" and "No" fields were pulling into the report but not editable (since you can't edit formulas).…
-
Keeping Formulas When Downloading to Excel
Hello, I found online that it says when you download a sheet into an Excel sheet that it does not keep the formulas as they are different. Now just in case, I thought I'd ask: Is there a work around for this at all? Is there absolutely no way to keep your formulas when you transfer them to an Excel?
-
Health Column Formula For Dependencies
I have the following formula in the health column. =IF(OR(Status@row = "Completed", [End Date]@row - TODAY() >= 7), "Green", IF([End Date]@row - TODAY() <= -1, "Red", "Yellow")) It works fine. If End date is more than 7 days out then the health column is green, If End Date has passed then Red. The problem is that I didn't…
-
Very simple if/and formula returning blank cell
I'm incredibly confused by the results I'm receiving It's literally just IF(AND(Column1@row = "this", Column2@row = "that"), "say this") The conditions are met, yet the result is a blank cell. I've used this same function syntax all across this sheet and it works fine. Am I running into formula limits or something? I was…
-
Quick help on a formula
I know I'm missing something small and I cannot get this formula to work. Basically you throw a date into the "desired start date" and it will populate a small timeline of required milestone dates based on another sheet that's referenced. Works fine in our master sheet (right side in picture). However when I started…
-
Dynamic Date cell --> to feed into NetWorkDays formula
Hi all, I'm very new to SS and maybe am going about this backwards....GOAL: I'm trying to create a running countdown between the current day and the due date of a project. I figured out to use this formula: =NETWORKDAYS([Start Date]31, [End Date]28) BUT I want this number to dynamically "count down" as we approach the end…
-
(over-)due tickets
Hi, has anyone an idea how to get the number of due tickets (due date is yesterday or more) overdue tickets (more than 14 / 30 days)