-
Project Plan - Excluding rows from the overall completion percentage calculations
I am creating a project plan that will be used for Lifecycle maintenance programmes. Each project plan will consist of up to 8 different work packages which will have their own task lines in. (See attached pic) This basic format will be the standard for all Lifecycle programmes. One of these will be for one of the…
-
What is wrong with my formula?
Probably something obvious... =COUNTIF((Position2:Position136, (CONTAINS("Medical Assistant", @cell))), AND([Cleared to Return?]2:[Cleared to Return?]136, OR(CONTAINS("No", @cell), CONTAINS("Contingent", @cell))))
-
#Blocked when trying to delete column
I have a column "INACTIVE" that I'm trying to delete because I don't need it anymore. However, when I do, a different column that has a formula in it changes to "#BLOCKED." The "inactive" column is not part of the formula. I don't understand why deleting this column is causing this other column to be impacted. Below is the…
-
Need help with an ISBLANK AND statement please
Hi, I have an approval due date column and an approval date column and fa approval past due column - I would like the approval past due column to have a red circle if the approval due date is past due and the approval date is blank (this is because there will be a blank in the approval date column until it is approved) but…
-
Row Copy Automation
I have two sheets - a Checkpoint sheet and a project RAID log. If Action Required is set to YES on the checkpoint sheet, the copy row automation should trigger to copy the row from the checkpoint sheet to the project RAID log. I have hidden columns in both sheets so that they match but only the relevant columns are shown…
-
If 100% complete, mark another column Done
This works on another sheet, so not sure what I'm missing. I have two columns : Status and Complete%. If a row in Complete % is entered as 100%, I want Status to show as Done. Here's the formula I've tried to put in the Status column, which outputs #UNPASEABLE =IF([% complete]@row = 100%, "Done")
-
How do I return a value from a chart on another sheet using multiple values?
I have a Data Chart for wiring harnesses based on Year, Make, and Model of commercial Vehicle (it's quite extensive) I have another chart that has incoming orders, where I am given the year, make, and model of the vehicle I need to return the harness from the Data Chart formulaically. In excel, I am able to do this with…
-
Contains any text
I am trying to write a formula that asks if a cell has any text (at all, not specific text), then I want to reduce another cell by 1000 if true, blank if false. This can also be achieved if it is not blank? I have written a formula that provides a month that we have to employ a new staff member to service the growth from…
-
Modified (date) and filters
My team is maintaining a sheet consisting of row entries for tracking activities. Multiple collaborators are providing updates. I have a column with their name so they can easily filter which rows belong to them from a pull down. I also have a column with a Modified(date) field. I do some calculations to show when a row…
-
COUNTIFS with OR
Hello! Could I please get some help with this COUNTIFS? The intention is to count the rows where 1-Ref is either Complete or Attestation. I tried the below but it's currently returning UNPARSABLE. =COUNTIFS([1-Ref]:[1-Ref], OR(([1-Ref]:[1-Ref] = "Completed", ([1-Ref]:[1-Ref] = "Attestation")) Thank you!
