-
Update a Symbol column based on another sheet's checkbox, whilst maintaining other information
Okay, I have a three-part problem that I, in no way, can solve on my own. Question 1 Above is a destination sheet we use that determines which operators are cleared on specific disciplines. We'd like to automate this based on the Cleared column in our main training source sheet (see picture below). When that checkbox is…
-
Multiple IF Statements
I'm hoping someone can help me determine the error in my IF statement. We have tasks in our projects assigned to a specific role: either an SL (Senior Lead), SPL (Senior Project Lead), or a PC (Project Coordinator). I have those initials and the person assigned to those roles at the top of my sheet. I.e.: PL Steve Smith,…
-
Counting multiple columns, per person for not blank
I know this should be easier than I am making it but.. I need to count per person, the number of columns with dates OR the number for not blank divided by 2. Help please :)
-
Conditional formula IF number show "text"
I need to create a formula in a new column that automatically shows " probability" depends on the % entered manually in column "Probability to win". For example if i input 5% should should "Very low" Depends on % that is entered on column “Probability to win” return on “probability” column: If Blank – TBD If 0%-5% = Very…
-
Is there a way to calculate percent complete in the summary page without parent/child relation?
I have a action tracker for my department. All information in as via a form. I want to use the Summary Sheet to show overall % complete of all tasks based on the % Complete column. Is there a way to do this in the summary sheet without having to create the parent child relation?
-
Adding months to a cell linked date
Hi everyone, I am trying to add 3 months and 6 months on from a date that comes from another sheet. =DATE(YEAR([Date (Hidden)]5), MONTH([Date (Hidden)]5) + 6, DAY([Date (Hidden)]5)) That is the formula I am using. As long as it is in the same year this formula works but if the it goes into the next year the formula becomes…
-
Formula for Milestone Health
I'm trying to figure out a formula for "Site Health". Each site has 9 milestones that will have a "Milestone Health" column. Each milestone must be completed a certain number of days before the project end date (October 31-22). I don't know how to create a formula to make the milestone health Green, Yellow and Red. At the…
-
Adding Cells together - but ignoring blank cells - problem with output.
I've created a Sheet that collects data from various sheets and collates it to enable a Cashflow Graph to be produced. The rows noted as "Forecast", "Actual" & "Forecast Cumulative" all work as intended with cells appropriately left blank where there is no value - this ensures the graphs don't bounce back and forth to $0.…
-
How to use OR for COUNTIFS, referencing 2 columns in another sheet
Hi, I have the following formula in a column, =COUNTIFS({Sheet Range 1}, [Column Sample]@row, {Sheet Range 2}, "ABC", OR({Sheet Range 3}, >TODAY(), {Sheet Range 4}, >TODAY() I need to do if column A = 1. column B = 2, (next should be OR) or column C = 3 or column D = 4 Please help out!
-
Help with sorting numbers and letters that are combined in one cell?
I would like to sort by a column that has both numbers and letters in a cell. Such as 1, 1a, 1b, 1c. Right now if I sort it by it by the ascending option, it's able to do 1a, 1b, and 1c correctly, however it separates it from the numbers that don't have any letters. For example: This is what it does: 1 2 3 1a 1b 2a 2c 3b…
