-
Health column?
Hello, I'm attempting to create a function in my "Health" column that will return Red, Yellow, or Green based on: 1) Status (dropdown input by sheet user) 2) Dates in the date columns to the right, broken down by step We are attempting to track communications through various review processes. Some require legal review, and…
-
Automating Status of "Completed"
I want to be able to have all tasks with a status of "completed" moved to the bottom of my parent section. I don't want to move to another sheet, but instead to the bottom of the parent. Is there a way to do this? Formula / Automation? Thanks in advance! -mc
-
Sumifs cross sheet
Hello, I am trying to pull in project expenses from an expense tracking sheet, based on multiple criteria. I want to match the project row in my consolidation sheet with the expense sheet (to determine row being calculated) I then want to only look at expense lines that are "Completed" (no more expenses are expected on the…
-
Formula to pull through names of all projects relating to a programme
Hi I'm looking for a formula that will reference a sheet that holds programme and project names. I want to pull through all projects related to a particular project. How can I best do this? I did put it in a report but, on my Dashboard it means I can't pull the data through on my metric widget. I don't want it to show on…
-
How do I stop counting overdue days when the completion date is met using my formula below?
I have column headers (that reference my formula, conditional formatting, and workflows) for: assigned start date, assigned due date, projected duration, days remaining, overdue, start date, completed date, actual duration, and done. My formula to count days "overdue" is below: =IF(Done@row <> "Complete", IF(TODAY() -…
-
Weeks to Project Due
Hi All, I am looking for a very simple formula to help me return the following: The product due date is 10/17/21, week 0, and I would like to create a formula to tell me what working week we are currently in today. I am able Any help is greatly appreciated
-
Sum Values in Matrix
Hello, I'm trying to sum all the values in a 2 axis matrix that meet a criteria for row and column. Name on rows and columns could be repeated. In the example of the image the result be 11. Thanks for your help.
-
Formula using OR
Can someone help me I keep getting a error message, I know is has to be the OR function. =COUNTIFS({Civic 2021 Range 2}, "RFP Submitted", OR({Civic 2021 Range 4}, "(Stage 3) 3.2 - WON", {Civic 2021 Range 4}, "(Stage 3) 3.3 - LOST"), {Civic 2021 Range 3}, MONTH(@cell) = 1)
-
Nested IF Statements
Hello! SS newbie here. I'm having a hard time with my nested if statements. This is what I am trying to accomplish: If number of items in Past Due Count column is =0, Traffic light is Green, 1=Yellow, 2+=Red, and if Status column (Blue Header row) ="Complete", traffic light is blue. I have this so far: =IF([Past Due…
-
Formula - Count by Month and Other Criteria
I've been trying to determine a formula I can use on a SEPERATE Sheet that will pull from the sheet in the screenshot a: - Monthly SUM number of items that are In Review, Awaiting Publication, Published/Live, etc. (i.e., the "Status" column in screenshot) so, for February, number of items in review, awaiting publication,…